Query command
Use the query command to list backup objects that were sent to IBM Spectrum 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 Spectrum 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]