APAR status
Closed as fixed if next.
Error description
BigSQL 4.2.5 upgrade fails during the backup phase with the following error message: INFO: Performing Big SQL engine upgrade readiness check ERROR: The Big SQL engine upgrade readiness check failed ERROR: Consult the log file /var/ibm/bigsql/logs/upgrade-check.log on the <nodename> node The upgrade-check.log contains an error similar to: Version of DB2CKUPGRADE being run: VERSION "11.1" Database: "BIGSQL" SQL10007N Message "5555" could not be retrieved. Reason code: "4". DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "/var/ibm/bigsql/logs/upgrade-check.log". This is due to invalid objects in the database.
Local fix
Clean up any invalid objects before upgrading. SELECT * FROM SYSCAT.INVALIDOBJECTS will show how many objects in the database need to be rebuilt. Then run CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() iteratively until the select from SYSCAT.INVALIDOBJECTS returns no rows. Any objects that cannot be revalidated should be dropped.
Problem summary
See error description The problem is fixed in Version 5.0.3 and later fix packs.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PI84938
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
425
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-25
Closed date
2019-03-26
Last modified date
2019-03-26
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Unknown
Fix information
Applicable component levels
R425 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"425","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 August 2020