IBM Support

-525 error on NULLID.SYSSTAT package when trying to set CURRENT SCHEMA against a DB2 for z/OS database

Troubleshooting


Problem

-525 error on NULLID.SYSSTAT package when trying to set CURRENT SCHEMA against a DB2 for z/OS database

Symptom

When trying to set the CURRENT SCHEMA, a -525 error may occur on the NULLID.SYSSTAT package.

Below is an example of the error that may be displayed:

DSNT408I SQLCODE = -525, ERROR: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE,
IT WAS IN ERROR AT BIND TIME FOR SECTION = 34 PACKAGE = DBB0.NULLID.SYSSTAT CONSISTENCY TOKEN = X'5359534C564C3031' ,
DSNT418I SQLSTATE = 51015 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -230 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF1A' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

CURRENT SCHEMA can be set different ways:
- SET CURRENT SCHEMA command
- CurrentSchema keyword

[{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.5;9.7;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21608714

Page Feedback