Ansicht
Dokumentation

SQL0904 - Resource limit exceeded. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.


Message : SQL0904
Resource limit exceeded.

Message Long Text :

Cause . . . . . : Resource limit type &1 exceeded with reason code &2. A list of the limit types follows:
-- Type 1 indicates that the user profile storage limit or the machine storage limit was exceeded.
-- Type 2 indicates that the machine lock limit was exceeded.
-- Type 3 indicates that the query resource limit was exceeded. For more information see the previously listed message CPD4365.
-- Type 4 indicates that a journal error has occurred.
-- Type 5 indicates that the commit lock limit was exceeded.
-- Type 6 indicates that the maximum size of the table has been reached.
-- Type 7 indicates that the maximum size of the prepared statement area has been reached.
-- Type 8 indicates that the maximum number of cursors have been opened for this job.
-- Type 9 indicates that the maximum number of entries in the lock table have been used for this job.
-- Type 12 indicates that the maximum DRDA communications buffer size was exceeded.
-- Type 13 indicates that the maximum amount of blocked data was exceeded.
-- Type 14 indicates that the maximum amount of descriptor space has been allocated.
Recovery . . . : Do one of the following: If this is error type 1, contact the security officer to increase the user profile storage limit, or delete some objects to free up storage and then try the request again.
-- If this is error type 2, then try the operation when the number of machine locks held has decreased.
-- If this is error types 3, 4, or 5, see previously listed messages in the job log for recovery information.
-- If this is error type 6, Some of the rows from this table must be moved to another table.
-- If this is error type 7, issue a COMMIT or ROLLBACK without the HOLD clause before issuing anymore PREPARE statements.
-- If this is error type 8, issue a CLOSE before issuing any more OPEN statements.
-- If this is error type 9, issue a COMMIT or ROLLBACK without the HOLD clause.
-- If this is error type 12, reduce the total size of column data supplied with the SQL request.
-- If this is error type 13, reduce the number of rows in the block.
-- If this is error type 14, reduce the number of allocated descriptors with the DEALLOCATE DESCRIPTOR statement.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3248 Date: 20240426 Time: 185808     sap01-206 ( 2 ms )