in dialog file I have
Unable to create or attach to the segment used for fenced routine
communications. Decrease the amount of database shared memory used by your
instance, and try again
My both dbm and db parameter are set automatic
what to do
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: pic26602.jpg)
"Jagdish S Rawat
"
<db2udbdba-ezmlms To
hield-x96761959.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
08/30/2006 05:26 Subject
PM Re: SQL1042C An unexpected system
error occurred. SQLSTATE=58004
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
---------------------------------------------------------------------
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