Query command
Use the query command to list backup objects that were sent to IBM Storage Protect™ by Data Protection for DB2®.
The objects that are displayed can be filtered with command options. For more information about command options, see Backup Object Manager command options.
- List all backup objects that
are related to DB2 (database
or table space backups and DB2
log file backups):
backom -c q_all [-i instance] [-a database alias] [-n node number] [-t timestamp | time range] [-l log number | log number range][-e execution profile] [-m output mode] [-v] - List database backups:
backom -c q_db [-i instance] [-a database alias] [-n node number] [-t timestamp | time range] [-e execution profile] [-m output mode] [-v] - List table space backups:
backom -c q_ts [-i instance] [-a database alias] [-n node number] [-t timestamp | time range] [-e execution profile] [-m output mode] [-v] - List table space definition information (TDI) images that are
related to a full DB2 database
backup:
backom -c q_tdi -a database alias -t timestamp [-i instance][-n node number] [-e execution profile] [-m output mode] [-v] - List DB2 log file backups:
backom -c q_log [-a database alias] [-n node number] [-t timestamp | time range] [-l log number | log number range] [-e execution profile] [-m output mode] [-v] - List backup objects available on IBM Storage Protect (database or table space backups, DB2 log file backups, and file backups):
backom -c q_raw [-f file name] [-e execution profile][-m output mode] [-v]