Ansicht
Dokumentation

CPI430A - COMMIT(*ALL) or COMMIT(*CS) specified but files locked *SHRNUP. ( OS/400 )

ROGBILLS - Synchronize billing plans   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : CPI430A
COMMIT(*ALL) or COMMIT(*CS) specified but files locked *SHRNUP.

Message Long Text :

Cause . . . . . : The *ALL or *CS value was specified for either the Start Commitment Control (STRCMTCTL) command, the COMMIT parameter on the precompile command, or the COMMIT parameter on the Start SQL (STRSQL) command. However, the query was not opened under commitment control. Instead, the base files were locked at the *SHRNUP lock state. Also, any base files that are system database files were locked at the *SHRRD lock state. If the ROLLBACK statement is used, the cursor's position will not be the same as it was at the start of the unit of recovery.
Neither the *ALL nor the *CS value for the COMMIT parameter can be used on a query which specifies one of the following:
-- The GROUP BY clause, HAVING clause, GRPFLD parameter, GRPSLT parameter, or a column function.
-- The UNIQUEKEY parameter.
-- A complex logical file which had to be copied to a temporary file.

In addition, the *ALL value for the COMMIT parameter cannot be used on a query which specifies one of the following:
-- The DISTINCT keyword.
-- The UNION, EXCEPT, or INTERSECT keyword.
-- The ORDER BY keyword or KEYFLD parameter and the sum of the lengths of the fields given in the clause or parameter requires that a sort be performed.
-- A system database file was referenced in the query.
-- A user-defined table function was referenced in the query.
Recovery . . . :
-- Use the Work with Object Lock (WRKOBJLCK) command to determine which files were locked at the share-no-update (*SHRNUP) lock state.
-- If a lock state of share-no-update (*SHRNUP) on the files is too restrictive, either do not specify commitment control or specify the *CHG value for either the STRCMTCTL command, the COMMIT parameter on the precompile command, or the COMMIT parameter on the STRSQL command. Try the request again after making these changes.

Message File : QCPFMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3271 Date: 20240427 Time: 055541     sap01-206 ( 2 ms )