Db2 SQL Performance Analyzer ISPF panel messages

The following messages are issued under TSO by the SQL PA CLIST and ISPF panel processes:

ANL001I
For statements that contain SQL errors, the explain report does not exist.
ANL002E
Required values are missing.
ANL003I
The selected feature is unavailable when the input source is a plan, or when ANLCSPA is used, or when the SQL Display or the Tables Display is used.
ANL005E
The package does not exist in the SYSIBM.SYSPACKAGE catalog table.
ANL006E
The specified value is invalid.
ANL007E
The source module was not found.
ANL008E
SQL statements for the source module could not be extracted.
ANL009E
The specified data set is unavailable.
ANL010E
The data set that contains the specified member is not partitioned.
ANL011E
The installed base parameter file was not found.
ANL012E
The specified primary command is invalid
ANL015E
Wildcards are not supported. Remove all specified wildcards and try again.
ANL017E
The specified value contains too many characters.
ANL018E
The specified value for the degree of parallelism is invalid. Specify 1 or ANY.
ANL019E
An alphabetic character value is specified in a field that can contain only a numeric value. Specify a numeric value.
ANL020E
The name of the table creator is required. Specify the name of the table creator.
ANL022E
The specified table does not exist in the package.
ANL024E
The specified QUERYNO does exist in the package.
ANL026E
The specified value of FORCE is invalid.
ANL027E
The specified pattern was not found in the name of any member.
ANL028E
The data set could not be opened.
ANL029E
The specified data set does not exist or is not cataloged.
ANL030E
A member name was not specified for the PDS.
ANL031E
The format of the specified data set is invalid.
ANL032E
The specified qualifier is invalid.
ANL033E
The specified QUERYNO was not found in the PLAN_TABLE.
ANL034E
The QMF query was not found in the OBJECT_DATA table.
ANL036E
The PLAN_TABLE was not found in the Db2 system catalog for the specified authorization ID.
ANL037E
The table for the specified name and creator was not found in the Db2 system catalog.
ANL038E
The index for the specified name and creator was not found in the Db2 system catalog.
ANL039E
The specified member contains no records.
ANL040E
The specified member or data set was not found.
ANL041E
The specified index exists in the system catalog.
ANL042I
The maximum number of SQL statements that can be explained was reached.
ANL043E
The specified Db2 run library was not found.
ANL044E
The specified CEE run library was not found.
ANL045E
The specified SQL PA load library was not found.
ANL046E
The specified Db2 load library was not found.
ANL047E
The specified Db2 exit library was not found.
ANL048E
The specified table space or database was not found in the Db2 system catalog.
ANL049E
The user user_ID is not authorized to set the CURRENT SQLID value to ID.
ANL050E
ANLCHECK was not bound.
ANL051I
If the value of SQLID is blank, it will be set to +OFF+ after you exit.
ANL052E
The specified line command is invalid.
ANL053E
In Db2 10 and later releases, all plans must be bound by using the PKLIST option.
ANL054E
No explainable statements were found in the selected input.
ANL055W
The ANLPARM user parameter file is undefined. Default values will be used for processing, and changes will not be permanently saved.
ANL056W
The ANLCNTL system parameter file is undefined. Default values will be used for processing, and changes will not be permanently saved.
ANL059W
The specified database and table space information cannot be obtained from the SQL_ID.EEEWORK table. The default database and table space will be used.
ANL060E
A connection to the remote Db2 subsystem was not made. Ensure that SYSIBM.LOCATIONS contains the location_name location.
ANL061E
Information from the QMF tables could not be retrieved.
ANL062E
The QMF object type must be QUERY.
ANL063E
The QMF query subtype must be SQL.
ANL064E
The QMF query was not saved with SHARE=YES and is restricted to the owner.
ANL065E
The value specified for primary space allocation is not valid.
ANL066E
The value specified for secondary space allocation is not valid.
ANL067I
VIEW is disabled in the ISPF Configuration Table so BROWSE is used instead.
ANL068I
VIEW is disabled in the ISPF Configuration Table so BROWSE is used instead. Query query_number must be found manually.
ANL069E
During an attempt to view or browse the data_set_name report, a return code of return_code_number was issued.
ANL070W
The user user_ID is not authorized to save to parameter_file. Changes will be effective for only the current session.
ANL071E
Reports are unavailable because either no previous reports exist or an error occurred when the reports were generated.
ANL072E
The SQL_ID.DSN_VIRTUAL_INDEXES Db2 table could not be created.
ANL073E
An error occurred while the data_set_name data set was being created.
ANL074E
An error occurred while the parameter values were being copied to the data_set_name data set.
ANL075E
The specified virtual index already exists in the Db2 system catalog.
ANL076E
The index_name virtual index created by creator_name was not found in the Db2 system catalog.
ANL077I
The specified index exists in the Db2 system catalog and was already dropped virtually.
ANL078E
The specified index is a virtual index in the Db2 system catalog.
ANL079E
The specified column name column_name is not in the specified table.
ANL080E
The value must not contain embedded blanks.
ANL081E
User user_ID needs the privilege for SELECT from SYSIBM.SYSINDEXES and SYSIBM.SYSCOLUMNS, CREATE INDEX, and CREATE TABLE owner_name.DSN_VIRTUAL_INDEXES, if DSN_VIRTUAL_INDEXES table is not created at SQL PA customization.
ANL082E
NO cannot be specified for the INCLUDE NULL KEYS parameter when the key_column key column does not allow null values.
ANL083E
NO cannot be specified for the INCLUDE NULL KEYS parameter when YES is specified for the PARTITIONED parameter.
ANL084E
NO cannot be specified for the INCLUDE NULL KEYS parameter when YES is specified for the UNIQUE parameter.
ANL086W
The user-level user parameter data set is unavailable or does not exist. The job cards cannot be saved.
ANL087I
The job cards were saved.
ANL088I
The user-level user parameter data set must be created before the job cards can be saved. To create the data set with the displayed name and settings, press Enter. Otherwise, change the name, settings, or both, and press Enter.
ANL089I
The user-level user parameter data set was created. Press Enter to save the job cards, or press PF3 to cancel the changes.
ANL091E
NO GENERIC IDs ARE AVAILABLE IN userid.REGISTRY. EITHER CHANGE THE CURRENT SQL ID TO A VALUE OTHER THAN +OFF+ OR MODIFY THE REGISTRY TABLE TO FREE THE ENTRIES THAT ARE NO LONGER BEING USED BY CHANGING ANLINUSE FROM 'Y' TO 'N'.
ANL092E
AN ERROR OCCURRED WHEN ACCESSING userid.REGISTRY WHILE SELECTING A GENERIC ID FOR USE. VERIFY THAT THE REGISTRY WAS SET UP AND IS AVAILABLE.
ANL112E
The Db2 SQL authorization ID can only be changed when SETPLAN is set to ALLOW or YES. Contact the administrator regarding the value of SETPLAN.
ANL113W
The user username is not authorized to change data set name.
ANL114E
The user username is not authorized to change the value of DATAGRP. The value of DATAGRP is unchanged.
ANL115E
The user username is not authorized to change the value of system parameter DATAGRP in the EEEAUTH table. The value of DATAGRP is unchanged.
ANL116I
The user username is not authorized to see user table data. The statistics collected will be incomplete since it will not contain user table data such as HIGH2KEY and LOW2KEY.
ANL134E
userid is a generic ID and cannot be used as the SQL authorization ID. To use a generic ID, set the New Db2 SQL authorization ID to +OFF+.
ANL135E
If a wild card character is used in a Collection ID, then both Collection IDs must be identical.
ANL136I
At least one table was not found in the catalog. To view the containing statements, run the E line command on the "<table not found>" row and view the SQL report from the resulting Query Limits report.
ANL137I
No tables were found in the selected input.
ANL9012
THE DATA SET OR MEMBER TO BE RESTORED DOES NOT EXIST. CHECK YOUR SPELLING FOR THIS MEMBER NAME AND THEN RETRY. SQL PA CANNOT LOCATE: prefix.ANL520.SANLSTAT (member)
ANL9013
SQL PA ENCOUNTERED PROBLEMS RESTORING CATALOG STATISTICS FROM prefix.ANL520.SANLSTAT (member), RC: retcode CHECK RETURN CODE, AND CONSIDER MANUAL STATS RESTORATION
ANL9014
SQL PA ENCOUNTERED PROBLEMS RETRIEVING CATALOG STATISTICS FOR DISPLAY. CHECK SPELLING OF YOUR CREATOR AND TABLE NAME AND ALSO THE SUBSYSTEM ID, THEN RETRY. RC: retcod
ANL9015
SQL PA ENCOUNTERED PROBLEMS UPDATING CATALOG STATISTICS FOR THIS TABLE. CONTACT SYSTEM SUPPORT. RC: retcode SQL PA WAS UNABLE TO UPDATE THE CATALOG FOR THIS TABLE.
ANL9016
SQL PA ENCOUNTERED PROBLEMS RETRIEVING CATALOG STATISTICS FOR DISPLAY. CHECK SPELLING OF YOUR CREATOR AND INDEX NAME AND ALSO THE SUBSYSTEM ID, THEN RETRY. RC: retcode
ANL9017
SQL PA ENCOUNTERED PROBLEMS UPDATING CATALOG STATISTICS FOR THIS INDEX. CONTACT SYSTEM SUPPORT. RC: retcode SQL PA WAS UNABLE TO UPDATE THE CATALOG FOR THIS INDEX.
ANL9020
THE DATA SET OR MEMBER TO APPLY THE STATS DOES NOT EXIST CHECK YOUR SPELLING FOR THIS MEMBER NAME AND THEN RETRY. SQL PA CANNOT LOCATE: prefix.ANL520.SANLSTAT (member)
ANL9021
CANNOT EDIT THE JCL TO APPLY STATISTICS TO THE CATALOG. DATA SET OR MEMBER MAY NOT EXIST, OR COULD BE ALREADY IN USE OR EDIT BY ANOTHER: prefix.ANL520.SANLSTAT (JOBCARD)
ANL9022
CANNOT EDIT THE MEMBER CONTAINING COLLECTION PARAMETERS. DATA SET OR MEMBER MAY NOT EXIST, OR COULD BE ALREADY IN USE OR EDIT BY ANOTHER: prefix.ANL520.SANLSTAT (member)
ANL9023
CANNOT EDIT THE JCL TO COLLECT THE CATALOG STATISTICS. DATA SET OR MEMBER MAY NOT EXIST, OR COULD BE ALREADY IN USE OR EDIT BY ANOTHER: prefix.ANL520.SANLSTAT (JOBCARD)

Parent topic: Db2 SQL Performance Analyzer messages and return codes