Hi All,

When ever I am trying to execute snapshot for db i got error
SQL1042C An unexpected system error occurred. SQLSTATE=58004

Can any one suggest what is the problem
I have restart the instance many times

when I fire the follwoing statement it works
db2 get snapshot for db on coatsaix | grep -i "Log Space"

Log space available to the database (Bytes)= 979200000
Log space used by the database (Bytes) = 0
Maximum secondary log space used (Bytes) = 0
Maximum total log space used (Bytes) = 0

I have fired the following statement
db2 "select total_log_available - total_log_used from
table(snapshot_database('coatsaix', -1)) as snapshot_database"
it give me error
SQL1042C An unexpected system error occurred. SQLSTATE=58004

Right now I am chaing the DBM and DB parameters.

with regards,

Jagdish S. Rawat
IBM Certified DB2 DBA
IGSI, DLF Infinity Tower A, 4th Floor,
DLF Phase-II, NH-8,
Gurgoan -122001
Ph.# +91-124-4347152(Direct) +91-124-4347000 Ext. # 47152
Fax# +91-124-2566701
Mob# +919818433596
(Embedded image moved to file: pic28210.jpg)

DB2 & UDB email list listserv db2-l LazyDBA home page