User status (_UserStatus)

The _UserStatus VST displays the progress of PROUTIL and PROBKUP utilities.

Field name Data type Description
_UserStatus-Counter INTEGER Count blocks accessed, records moved, tables moved, or indexes compacted, etc
_UserStatus-ObjectId INTEGER The table or index worked on
_UserStatus-ObjectType INTEGER The type of object worked on
_UserStatus-Operation CHARACTER Name of the online utility for which status is being monitored
_UserStatus-State INTEGER The state the utility is in. See _UserStatus-State descriptions for descriptions of utility states)
_UserStatus-Target INTEGER The end value of the counter (if known)
_UserStatus-TenantId INTEGER Tenant ID of the user
_UserStatus-UserId INT64 User number
Table 1. _UserStatus-State descriptions
_UserStatus-State value Utility Description
11 PROUTIL Attempting to get a table lock
12 PROUTIL Attempting to get an administration lock
13 PROUTIL Attempting to lock a storage object
24 PROUTIL TABLEMOVE Copying records from one area to another
25 PROUTIL TABLEMOVE Creating a new, alternate index
26 PROUTIL TABLEMOVE Removing records from the source area after copying from source to target
27 PROUTIL TABLEMOVE Removing old indexes
31 PROUTIL IDXMOVE Creating a new index
32 PROUTIL IDXMOVE Removing old index
41 PROUTIL IDXCOMPACT Scanning the index delete chain
42 PROUTIL IDXCOMPACT Compacting a non-leaf index block
43 PROUTIL IDXCOMPACT Compacting a leaf index block
51 PROUTIL IDXFIX Scanning the record manager blocks in a database
52 PROUTIL IDXFIX Scanning the index blocks
53 PROUTIL IDXFIX Comparing index dbkeys for chosen indexes
54 PROUTIL IDXFIX Building the target indexes from the source index
60 PROBKUP Initializing area descriptors
61 PROBKUP Backing up active before-image clusters
62 PROBKUP Estimating size of backup files
63 PROBKUP Flushing the buffer pool and before-image buffers
64 PROBKUP Backing up area object blocks
65 PROBKUP Backing up the before-image file
66 PROBKUP Backing up the database blocks per area
70 PROUTIL DBANALYS Examining the record manager chain
71 PROUTIL DBANALYS Examining the index delete chain
72 PROUTIL DBANALYS Examining the free chain
73 PROUTIL DBANALYS Examining each database block
74 PROUTIL DBANALYS Gathering fragmentation statistics
80 PROUTIL DUMP Validating user input
81 PROUTIL DUMP Validating column index
82 PROUTIL DUMP Validating column data type
83 PROUTIL DUMP Dumping records from the specified table using the specified index
84 PROUTIL DUMP Dumping records for encrypted dump file by dump specified
85 PROUTIL DUMP Prompt for and validate pass phrase for encrypted dump file
86 PROUTIL DUMP Preparing information for encrypted dump file header
87 PROUTIL DUMP Reserved for future use.
88 PROUTIL DUMP Validating input
89 PROUTIL DUMP Dumping records by binary dump (non-encrypted dump file)
90 PROUTIL IDXMOVE Validating user input
91 PROUTIL IDXMOVE Validating target area
92 PROUTIL IDXMOVE Attempting to get a table lock
93 PROUTIL IDXMOVE Moving the index blocks from source to target areas
100 PROUTIL IDXFIX Creating new indexes for schema index rebuilds
101 PROUTIL IDXFIX Scanning all blocks with index blocks of interest
102 PROUTIL IDXFIX Scanning all blocks with index or record manager blocks of interest
103 PROUTIL IDXFIX Scanning all blocks to reconstruct the indexes
104 PROUTIL IDXFIX Rebuilding indexes from the sort files
105 PROUTIL IDXFIX Activating every rebuilt index
106 PROUTIL IDXFIX Deleting old schema indexes
110 PROUTIL TABLEMOVE Validating user input
111 PROUTIL TABLEMOVE Validating target area
112 PROUTIL TABLEMOVE Attempting to get a table lock
113 PROUTIL TABLEMOVE Looking for inactive indexes
114 PROUTIL TABLEMOVE Deleting template record from source area
115 PROUTIL TABLEMOVE Moving table from source to target area
116 PROUTIL TABLEMOVE Creating template record in target area
117 PROUTIL IDXACTIVATE Validating command line input
118 PROUTIL IDXACTIVATE Building index entries phase
119 PROUTIL IDXACTIVATE Lock the index records of the index(s) being activated
120 PROUTIL IDXACTIVATE Activating the index in process
121 PROUTIL IDXACTIVATE Locking the _Index record of the index being activated
122 PROUTIL IDXCHECK Locking the database schema to support the check process
123 PROUTIL IDXCHECK Locking the _Index records of indexes being checked from other index utilities
124 PROUTIL IDXCHECK Locking the table of the index being checked so its data will not change during check.
125 PROUTIL IDXCHECK Examining the index blocks of an index for and internal validation pass
126 PROUTIL IDXCHECK Examining an index's key entries for internal consistency
127 PROUTIL EPOLICY Obtaining the encrypted object's internal information for later processing
128 PROUTIL EPOLICY Scanning the encrypted blocks of an object
129 PROUTIL EPOLICY Scanning and raising an encrypted object's blocks to a new policy level
130 PROUTIL EPOLICY Changing an object's encrypted policy's attributes
131 PROUTIL DISABLEENCRYPTION Attempting to disable AI encryption
132 PROUTIL DISABLEENCRYPTION Attempting to disable BI encryption
133 PROUTIL DISABLEENCRYPTION Executing update phase of Disable Encryption
134 PROUTIL DISABLEENCRYPTION Executing decrypt phase of Disable Encryption
135 PROUTIL DISABLEENCRYPTION Disabling feature bit of Disable Encryption
136 PROUTIL IDXDEACTIVATE An attempt to deactivate an index or indexes is in progress
137 PROUTIL IDXDEACTIVATE Validating the command line input
138 PROUTIL IDXDEACTIVATE Acquiring the index locks to block other utilities from operating on the index(s)
139 PROUTIL IDXDEACTIVATE Locking the _Index records of the deactivating index
140 PROUTIL IDXDEACTIVATE Locking the _StorageObject records of the deactivating index
141 PROUTIL IDXDEACTIVATE Reserved for future use.
142 PROUTIL DEALLOCATE Locking the Schema records to support the deallocation process
143 PROUTIL DEALLOCATE Locking the _Tenant records to support the deallocation process
144 PROUTIL DEALLOCATE Locking the table or tables involved in the deallocation process
145 PROUTIL DEALLOCATE Locking the _Index record of the index or indexes involved in the deallocation process
146 PROUTIL DEALLOCATE Locking the LOB object or objects involved in the deallocation process
147 PROUTIL DEALLOCATE Changing internal object block values for objects involved in the deallocaton process
148 PROUTIL DEALLOCATE Wait point encountered because processes are blocking the deallocation process.
149 PROUTIL DEALLOCATE Releasing all locks acquired by the deallocation process
150 PROUTIL MTIDXBUILD Obtaining admin lock for MTIDXBUILD
151 PROUTIL MTIDXBUILD Recreating objects in MTIDXBUILD
152 PROUTIL MTIDXBUILD Building index tree for MTIDXBUILD
153 PROUTIL DATAMOVE Validating input for DATAMOVE
154 PROUTIL DATAMOVE Validating target database for DATAMOVE
155 PROUTIL DATAMOVE Locking table partition for DATAMOVE
156 PROUTIL DATAMOVE Checking for inactive indexes in DATAMOVE
157 PROUTIL DATAMOVE Moving data in DATAMOVE
158 PROUTIL DATAMOVE Moving a sequence in DATAMOVE
159 PROUTIL DATAMOVE The table instance is being deallocated
160 PROUTIL DATAMOVE Comparing schemas in DATAMOVE
161 PROUTIL DATAMOVE Updating the table instance storage object's object state
162 PROUTIL DATAMOVE Unlocking the table partition lock
1100 PROSHUT Waiting for user input