hello
we are running Db2 on z V12 FL 510
We seem to have an issue with the following problem:
we are getting -904 with the error message
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C9009C, TYPE OF RESOURCE 00000210
AND RESOURCE NAME WRKDB2E .DSN32K08.00000001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXIDCL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 39 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000027' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Looking into the failing statement we found:
DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMORRF ( TEMP_EONRID_DE SMALLINT
NOT NULL , TEMP_ORNRID DECIMAL ( 12 , 0 ) NOT NULL , TEMP_KRNRID
INTEGER NOT NULL , TEMP_ORTXID_REF CHAR ( 36 ) NOT NULL ,
TEMP_ORNRID_REF_RADNR INTEGER NOT NULL ,
TEMP_ORNRID_DELAD_ORDERRAD DECIMAL ( 12 , 0 ) NOT NULL ,
TEMP_XGTXID_REQUEST_SYS CHAR ( 4 ) NOT NULL ,
TEMP_ANTAL_DELAD_ORDERRAD SMALLINT NOT NULL ) ON COMMIT DROP
TABLE
so the error happens when trying to create DGTT in DSNDB07 tablespace
Because it is a datasharing member,the databasename is WRKDB2E -but it is DSNDB07
All tablespaces in that database are defined as PBG (that is UTS)
what we suspect is,that number of parallel executed transactions with this DGTT is higher than number of 32K tablespaces in DSNDB07.
so my question is:
should it be a good solution to replace (re-define) all tablespaces in DSNDB07 as segmented
and by that allow many DGTT-transactions to be located in one tablespace,contrary the current situation,where only one DGTT can exist in every tablesapce,untill ihe transaction commits ?
br
Henrik
HCL Technology
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.