Any Idea Guys,
I have again call a procedure and again got the same error
the procedure is in the right place i have sysadmin authority.
db2 "call sysproc.CREATE_STORAGEMGMT_TABLES('USERSPACE1')"
SQL1042C An unexpected system error occurred. SQLSTATE=58004
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: pic25246.jpg)
"Jagdish S Rawat
"
<db2udbdba-ezmlms To
hield-x29080003.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
08/29/2006 02:53 Subject
PM SQL1042C An unexpected system
error occurred. SQLSTATE=58004
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)
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page