Utility Operations › Using the Utility Statements › SQL and Non-SQL

SQL and Non-SQL

Some utilities can only be used for SQL or non-SQL databases. Others can be used without regard for the type of database you are using.

SQL database only

• BUILD
• INSTALL STAMPS
• LOAD
• SYNCHRONIZE STAMPS
• VALIDATE

Non-SQL database only

• CLEANUP
• FASTLOAD
• MAINTAIN INDEX
• RESTRUCTURE CONNECT
• RESTRUCTURE
• IDMSRSTC

For both SQL and non-SQL databases

• ARCHIVE JOURNAL
• ARCHIVE LOG
• ARCHIVE TRACE
• BACKUP
• CONVERT CATALOG
• CONVERT PAGE
• CREATE DSMODEL
• EXPAND PAGE
• EXTRACT JOURNAL
• FIX ARCHIVE
• FIX PAGE
• FORMAT
• LOCK
• MERGE ARCHIVE
• PRINT INDEX
• PRINT JOURNAL
• PRINT LOG
• PRINT PAGE
• PRINT SPACE
• PUNCH
• RELOAD
• REORG
• RESTORE
• ROLLBACK
• ROLLFORWARD
• TUNE INDEX
• UNLOAD
• UNLOCK
• UPDATE STATISTICS
• IDMSDBAN
• IDMSCALC
• IDMSDIRL
• IDMSLOOK
• IDMSRPTS