User status (_UserStatus)

Table 111. _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
55	PROUTIL ENABLELARGEFILES	Performing an operation on a binary large object (BLOB)
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

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 Table 111 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