To ease Virtual System Table (VST) updating on replication targets, the following modifiable VST tables and fields are allowed on replication targets.

Database connection (_Connect)

Field name Data type Description
_Connect-Misc CHARACTER User updatable field.

User connection (_MyConnection)

Table 1.
Field name Data type Description
_MyConn-UserMisc CHARACTER User updatable field.

Database features (_Database-Feature)

Field Name Data Type Description
_DBFeature_Enabled CHARACTER "1" indicates the feature is enabled; "0" indicates the feature is not enabled
Note: The only feature that may be enabled on a replication target is Large Database Entry Keys. It may only be enabled.

Database startup parameters file status (_DbParams)

Field name Data type Description
_DbParams-Value CHARACTER The current value specified for the parameter
Note: The following list contains the Database Startup Parameters that may have their value fields modified on a replication target. Other Startup Parameters are fixed and may not be modified.
  • Base Index (-baseindex)
  • Base LOB (-baselob)
  • Base Table (-basetable)
  • Base User Index (-baseuserindex)
  • Base User LOB (-baseuserlob)
  • Base User Table (-baseusertable)
  • BI Writer Scan Delay (-bwdelay)
  • Diagnostic Directory (-diagDir)
  • Diagnostic Events Value (-diagEvent)
  • Diagnostic Events Level (-diagEvtLevel)
  • Diagnostic Field Separator (-diagFS)
  • Diagnostic Data Format (-diagFormat)
  • Diagnostic Pause Length (-diagPause)
  • Diagnostic Prefix Value (-diagPrefix)
  • Log File Archive Directory (-lgArchiveDir)
  • Log File Archive Enable (-lgArchiveEnable)
  • Log File Truncate Frequency (-lgTruncateFrequency)
  • Log File Truncate Size (-lgTruncateSize)
  • Log File Truncate Time (-lgTruncateTime)
  • Limit Log File Payload (-limitLgPayload)
  • LRU Force Skips (-lruskips)
  • LRU Alternate Buffer Pool Force Skips (-lru2skips)
  • Nap Time (-nap)
  • Nap Maximum (-napmax)
  • Login Governor (-nGovernor)
  • Number of Checkpoint Statistics (-numCheckpointStats)
  • Omit Log Messages (-omitLgMsgs)
  • PICA Queue Nap Time (-picanap)
  • Prefetch Delay (-prefetchDelay)
  • Prefetch Factor (-prefetchFactor)
  • Prefetch Num Recs (-prefetchNumRecs)
  • Prefetch Priority (-prefetchPriority)
  • Page Writer Queue Delay (-pwqdelay)
  • Page Writer Queue Minimum (-pwqmin)
  • Page Writer Scan Delay (-pwsdelay)
  • Page Writer Scan (-pwscan)
  • Page Writer Maximum Buffers (-pwwmax)
  • Record Free Chain Search Depth Factor (-recspacesearchdepth)
  • Spin Lock Retries (-spin)
  • Server-side join (-ssj)
  • Database Client Notification (-usernotifytime)
  • Database Consistency Check (-DbCheck)
  • Lock Governor (-LGovernor)
  • Memory Consistency Check (-MemCheck)
  • Message Wait (-Nmsgwait)
  • Autonomous Update Statistics (-SQLAutoStats)
  • Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
  • Transaction End (TXE) Commit Lock Skip Limit (-TXESkipLimit)