APAR status
Closed as program error.
Error description
This case is related to APAR IJ25026 . The fix should include a db2 platform, the process is working fine in Oracle and MSSQL envirinmantes . The Recreating the issue just require restarting DB2 while Maximo is running and your user is logged in. L2 has reproduces it in 7612 Example stack trace below: [12/7/21 1:42:46:828 UTC] 007578f4 SystemOut O 07 Dec 2021 01:42:46:817 [ERROR] [MXServerMIF03] [] [jcc][t4][10335][10366][3.68.61] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][t4][10335][10366][3.68.61] Invalid operation: Connection is closed. ERRORCODE=-4470, SQLSTATE=08003 at com.ibm.db2.jcc.am.gd.a(gd.java:739) at com.ibm.db2.jcc.am.gd.a(gd.java:66) at com.ibm.db2.jcc.am.gd.a(gd.java:128) 12/14/2021 7:55 PM | SC TS007832159 | CaseHistory: Owner Change
Local fix
n/a
Problem summary
**************************************************************** * PROBLEM DESCRIPTION: * * When running DB2, and if the database has been shutdown * * whilst maximo application server is running, maximo retains * * the database connections. * ****************************************************************
Problem conclusion
A new validation for DB2 database disconnect has been introduced such that maximo application will detect closed database connections due to database shutdown and will free these connections.
Temporary fix
Comments
APAR Information
APAR number
IJ37056
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-01-10
Closed date
2022-01-26
Last modified date
2022-01-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MAXIMO ASST MGM
Fixed component ID
5724R46AM
Applicable component levels
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761"}]
Document Information
Modified date:
27 January 2022