APAR status
Closed as program error.
Error description
By default, on installation, Big SQL sets the database manager configuration parameter SYSADM_GROUP to "BIGSQLADM". If this setting is customised to any other value, installation of patches will reset the parameter to the default value. As a result, bigsql start may fail with the following error: SQL1092N The requested command or operation failed because the user ID does not have the authority to perform the requested command or operation. User ID: <user-id>. Checking the dbm cfg shows that the SYSADM_GROUP has been changed to BIGSQLADM.
Local fix
Correct the SYSADM_GROUP dbm cfg parameter after patch installation.
Problem summary
See error description
Problem conclusion
The problem is fixed in Version 5.0.1.0 and later fix packs
Temporary fix
Comments
APAR Information
APAR number
PI85439
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-08-03
Closed date
2018-03-01
Last modified date
2018-03-01
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
Fixed component name
INFO BIGINSIGHT
Fixed component ID
5725C0900
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":"410","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 August 2020