A fix is available
APAR status
Closed as program error.
Error description
When an Environment Definition or Legacy Table is updated using the ISPF dialog, the DB2 lock is held for the object. Running a batch job referencing the object fails with: IBM InfoSphere Optim System Error Structure - ErrCB ErrCB.ID= ZZZERRCBZZ SysRel= 11.3.0 DB2Rel= 1015(NFM) ErrCB.Type= DB2 SQL ERROR ErrCB.AuxInfo= GET an LT ErrCB.Code= -501 DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN DSNT418I SQLSTATE = 24501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF10' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION Number of Function Entries= 11 ErrCB.N(0).Src= FOPQRM 20150302 UI25494D ErrCB.N(0).Func= (000405) DSGetRM ErrCB.N(1).Src= FOPQTDAA 20150302 UI25494D ErrCB.N(1).Func= (001370) DSGetTData ErrCB.N(2).Src= FOPQCDAA 20150302 UI25494D ErrCB.N(2).Func= (000196) DSTblCols ErrCB.N(3).Src= FOPMIMP 20150320 UI26070D ErrCB.N(3).Func= (001786) ImportAD ErrCB.N(4).Src= FOPMCOM 20150302 UI25494D ErrCB.N(4).Func= (000389) EximMain ErrCB.N(5).Src= FOPUMAIN 20150302 UI25494D ErrCB.N(5).Func= (007662) GetEmbeddedObject ErrCB.N(6).Src= FOPUCRE 20150302 UI25494D ErrCB.N(6).Func= (005935) ADKeyword ErrCB.N(7).Src= FOPUCRE 20150302 UI25494D ErrCB.N(7).Func= (001811) ProcessInputParms ErrCB.N(8).Src= FOPUCRE 20150302 UI25494D ErrCB.N(8).Func= (000423) CreateStatement ErrCB.N(9).Src= FOPUMAIN 20150302 UI25494D ErrCB.N(9).Func= (000799) FOPMMUTL_dynamn ErrCB.N(10).Src= FOPMMAIN 20150302 UI25494D ErrCB.N(10).Func= (000824) Main Accessing from another ISPF dialog hangs and then fails with: A DB2 SQL Error has Occurred on 2015/03/24 15:01 DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN DSNT418I SQLSTATE = 24501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF10' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Local fix
Exit the ISPF dialog that made the update.
Problem summary
**************************************************************** * USERS AFFECTED: * * Optim Legacy users. * **************************************************************** * PROBLEM DESCRIPTION: * * When an Environment Definition or Legacy Table is updated * * using the ISPF dialog, the DB2 lock is held for the object. * * Running a batch job referencing the object fails with: * * IBM InfoSphere Optim System Error Structure - ErrCB * * ErrCB.ID= ZZZERRCBZZ * * SysRel= 11.3.0 * * DB2Rel= 1015(NFM) * * ErrCB.Type= DB2 SQL ERROR * * ErrCB.AuxInfo= GET an LT * * ErrCB.Code= -501 * * DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A * * FETCH OR * * CLOSE STATEMENT IS NOT OPEN * * DSNT418I SQLSTATE = 24501 SQLSTATE RETURN CODE * * DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR * * DSNT416I SQLERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC * * INFORMATION * * DSNT416I SQLERRD = X'FFFFFF10' X'00000000' X'00000000' * * X'FFFFFFFF' X'00000000' X'00000000' SQL * * DIAGNOSTIC * * INFORMATION * * Number of Function Entries= 11 * * ErrCB.N(0).Src= FOPQRM 20150302 UI25494D * * ErrCB.N(0).Func= (000405) DSGetRM * * ErrCB.N(1).Src= FOPQTDAA 20150302 UI25494D * * ErrCB.N(1).Func= (001370) DSGetTData * * ErrCB.N(2).Src= FOPQCDAA 20150302 UI25494D * * ErrCB.N(2).Func= (000196) DSTblCols * * ErrCB.N(3).Src= FOPMIMP 20150320 UI26070D * * ErrCB.N(3).Func= (001786) ImportAD * * ErrCB.N(4).Src= FOPMCOM 20150302 UI25494D * * ErrCB.N(4).Func= (000389) EximMain * * ErrCB.N(5).Src= FOPUMAIN 20150302 UI25494D * * ErrCB.N(5).Func= (007662) GetEmbeddedObject * * ErrCB.N(6).Src= FOPUCRE 20150302 UI25494D * * ErrCB.N(6).Func= (005935) ADKeyword * * ErrCB.N(7).Src= FOPUCRE 20150302 UI25494D * * ErrCB.N(7).Func= (001811) ProcessInputParms * * ErrCB.N(8).Src= FOPUCRE 20150302 UI25494D * * ErrCB.N(8).Func= (000423) CreateStatement * * ErrCB.N(9).Src= FOPUMAIN 20150302 UI25494D * * ErrCB.N(9).Func= (000799) FOPMMUTL_dynamn * * ErrCB.N(10).Src= FOPMMAIN 20150302 UI25494D * * ErrCB.N(10).Func= (000824) Main * * Accessing from another ISPF dialog hangs and then fails * * with: * * A DB2 SQL Error has Occurred on 2015/03/24 * * 15:01 * * * * DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A * * FETCH OR * * CLOSE STATEMENT IS NOT OPEN * * DSNT418I SQLSTATE = 24501 SQLSTATE RETURN CODE * * DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR * * DSNT416I SQLERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC * * INFORMATION * * DSNT416I SQLERRD = X'FFFFFF10' X'00000000' X'00000000' * * X'FFFFFFFF' X'00000000' X'00000000' SQL * * DIAGNOSTIC * * INFORMATION * **************************************************************** * RECOMMENDATION: * * Apply the provided fix. * **************************************************************** The update is not committed upon completion causing DB2 to retain a lock on the object.
Problem conclusion
Commits have been added after these objects are updated.
Temporary fix
Comments
APAR Information
APAR number
PI37730
Reported component name
OPTIM MOVE FOR
Reported component ID
5655V0700
Reported release
B30
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-03-24
Closed date
2015-04-07
Last modified date
2015-05-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
fopmmenu fopmptrm
Fix information
Fixed component name
OPTIM MOVE FOR
Fixed component ID
5655V0700
Applicable component levels
RB30 PSY UI26563
UP15/04/10 P F504
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B30","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 May 2015