I am getting below error while selecting the rows from table in jcl
SQL ERROR DURING SQL STATEMENT OPEN , TABLE TBLNAME
SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF
RESOURCE 00000100, AND RESOURCE NAME DB2-MANAGED SPACE WITHOUT SECONDARY ALLOCATION OR USER-MANAGED SPACE IN DSNDBD
SQLSTATE = 57011 SQLSTATE RETURN CODE
SQLERRP = DSNXRSOR SQL PROCEDURE DETECTING ERROR
SQLERRD = -115 13172746 0 13231826 -959250432 14090279 SQL DIA
SQLERRD = X'FFFFFF8D' X'00C9000A' X'00000000' X'00C9E6D2' X'C6D
without knowing db2/Z, there is probably no space enough available to allocate new pages
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
DB2 cannot find space for creating a temporary file or for inserting data
into a temporary file because the workfile database is full. DB2 cannot
perform the requested actions because of one of the following reasons:
You are running a large number of concurrent transactions requiring th
use of temporary files.
There is no space available in any of the tablespaces in the workfile
and your message states that the temp files that are defined are only defined with a PRIQTY and no SECQTY. That was done to ensure you do not go crazy with how much data you attempt to put into a temp table. Either refine your search results for the query to limit your results or spaek with your DB team about the possibility of allowing for more space.