Consider the following scenario:
In this scenario, you receive an error message that resembles the following:
However, even if you can identify the failing section by viewing the token, you don't know the details about why the command failed. After you apply this hotfix, you can get a more detailed error message, including the SQLCODE, SQLSTATE, and SQLCAMESSAGE elements, as provided by the DB2 database.
For example:
- Your application uses a DataAccessControl.CreateCustomPackages API call to create custom packages that are configured in an XML file.
- The package contains multiple sections.
- The DataAccessControl.CreateCustomPackages call fails for some reason.
In this scenario, you receive an error message that resembles the following:
Status: Failed to create package '<PackageCollection>.<ID>.<Token>'
State = 0
Status: Failed to allocate package.
State = 0
Status: The package creation process has failed on resource 'ResourceName':
State = 0
Execution failed.
State = 0
Status: Failed to allocate package.
State = 0
Status: The package creation process has failed on resource 'ResourceName':
State = 0
Execution failed.
However, even if you can identify the failing section by viewing the token, you don't know the details about why the command failed. After you apply this hotfix, you can get a more detailed error message, including the SQLCODE, SQLSTATE, and SQLCAMESSAGE elements, as provided by the DB2 database.
For example:
Status: Failed to create package '<PackageCollection>.<ID>.<Token>'
State = 0
Status: Failed section: '2'
State = 0
Status: ILLEGAL SYMBOL "ORDERS". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: , FROM INTO SQLSTATE: 42601, SQLCODE: -104
Status: The package creation process has failed on resource 'ResourceName':
State = 0
Execution failed.
State = 0
Status: Failed section: '2'
State = 0
Status: ILLEGAL SYMBOL "ORDERS". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: , FROM INTO SQLSTATE: 42601, SQLCODE: -104
Status: The package creation process has failed on resource 'ResourceName':
State = 0
Execution failed.