Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sysibmadm.dbcfg connectivity thoughts/question
13 views
Skip to first unread message
Bruce
Feb 3, 2012, 9:12:54 AM2/3/12
to
Hi All...
DB2 9.7.5 on Unix...
Um...So I wanna know if the DB is connectable...so I run one of these
SQL statements...but I can't run them unless I'm connected. For
example, if the DB is truly in RF Pending then I can't connect so can
the answer from "where name = 'restore_pending'"` be anything other
than NO?
For now I continue to use 'db2 get db cfg for xyz | grep, etc.
Kinda of a 'catch-22', no? What am I missing?
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'backup_pending'"`
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'rollfwd_pending'"`
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'restore_pending'"`
DB2 9.7.5 on Unix...
Um...So I wanna know if the DB is connectable...so I run one of these
SQL statements...but I can't run them unless I'm connected. For
example, if the DB is truly in RF Pending then I can't connect so can
the answer from "where name = 'restore_pending'"` be anything other
than NO?
For now I continue to use 'db2 get db cfg for xyz | grep, etc.
Kinda of a 'catch-22', no? What am I missing?
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'backup_pending'"`
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'rollfwd_pending'"`
db2 -x "select substr(value,1,50) from sysibmadm.dbcfg where name =
'restore_pending'"`
0 new messages