Provides startup diagnostics for dbspaces.
-iqstart N
The input parameter N is a number value that represents an integer bit mask. You may combine values to provide more than one feature. Output generated before the IQ message file is generated goes to the console. The -z startup switch provides additional startup and connection information.
The allowed values are as follows:
N=1—returns basic information about the file names from SYSIQFILES that are used when opening the dbspace. It then displays the fully qualified names used. You can use this option to create a record of the files in use by the database in the IQ message file.
N=2—stops after the transaction log replay before executing RecoveryComplete allowing you to examine the database without opening it all the way. You can combine N=2 with other options. In certain modes using N=2 may rewrite the commit_identity, but does not otherwise modify the database in a permanent manner—the checkpoint that would commit the recovery actions is not allowed to complete. All recovery actions reexecute the next time the database is opened.
N=4—returns full diagnostic information, including all rows of SYSIQFILE, the subset of file names selected if the database is a multiplex database, the fully resolved file names, each individual dbspace file header block, the database_identity, the commit_identity, each checkpoint log entry, and each transaction log entry.
N=8—allows the file paths in SYSIQFILE to be overridden. Instead of the SYSIQFILE values, the file names iqmsg.iqmsg, iqmain_1, iqmain_2, ..., iqtemp_1, iqtemp_2, and so on. will be used. These may be links and must be in the same directory as the .db file. You may use a link to the actual .db file but if the server is given a link to a .db file that uses a transaction log relative to the database, the server looks for the transaction log relative to the link, rather than to the database. In this case, create a link for the transaction log also