Db2 SQL Performance Analyzer ISPF panel messages The following messages are issued under TSO by the SQL PA CLIST and ISPF panel processes: ANL001IFor statements that contain SQL errors, the explain report does not exist.ANL002ERequired values are missing.ANL003IThe 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.ANL005EThe package does not exist in the SYSIBM.SYSPACKAGE catalog table.ANL006EThe specified value is invalid.ANL007EThe source module was not found.ANL008ESQL statements for the source module could not be extracted.ANL009EThe specified data set is unavailable.ANL010EThe data set that contains the specified member is not partitioned.ANL011EThe installed base parameter file was not found.ANL012EThe specified primary command is invalidANL015EWildcards are not supported. Remove all specified wildcards and try again.ANL017EThe specified value contains too many characters.ANL018EThe specified value for the degree of parallelism is invalid. Specify 1 or ANY.ANL019EAn alphabetic character value is specified in a field that can contain only a numeric value. Specify a numeric value.ANL020EThe name of the table creator is required. Specify the name of the table creator.ANL022EThe specified table does not exist in the package.ANL024EThe specified QUERYNO does exist in the package.ANL026EThe specified value of FORCE is invalid.ANL027EThe specified pattern was not found in the name of any member.ANL028EThe data set could not be opened.ANL029EThe specified data set does not exist or is not cataloged.ANL030EA member name was not specified for the PDS.ANL031EThe format of the specified data set is invalid.ANL032EThe specified qualifier is invalid.ANL033EThe specified QUERYNO was not found in the PLAN_TABLE.ANL034EThe QMF query was not found in the OBJECT_DATA table.ANL036EThe PLAN_TABLE was not found in the Db2 system catalog for the specified authorization ID.ANL037EThe table for the specified name and creator was not found in the Db2 system catalog.ANL038EThe index for the specified name and creator was not found in the Db2 system catalog.ANL039EThe specified member contains no records.ANL040EThe specified member or data set was not found.ANL041EThe specified index exists in the system catalog.ANL042IThe maximum number of SQL statements that can be explained was reached. ANL043EThe specified Db2 run library was not found.ANL044EThe specified CEE run library was not found.ANL045EThe specified SQL PA load library was not found.ANL046EThe specified Db2 load library was not found.ANL047EThe specified Db2 exit library was not found.ANL048EThe specified table space or database was not found in the Db2 system catalog.ANL049EThe user user_ID is not authorized to set the CURRENT SQLID value to ID.ANL050EANLCHECK was not bound.ANL051IIf the value of SQLID is blank, it will be set to +OFF+ after you exit.ANL052EThe specified line command is invalid.ANL053EIn Db2 10 and later releases, all plans must be bound by using the PKLIST option.ANL054ENo explainable statements were found in the selected input.ANL055WThe ANLPARM user parameter file is undefined. Default values will be used for processing, and changes will not be permanently saved.ANL056WThe ANLCNTL system parameter file is undefined. Default values will be used for processing, and changes will not be permanently saved.ANL059WThe specified database and table space information cannot be obtained from the SQL_ID.EEEWORK table. The default database and table space will be used.ANL060EA connection to the remote Db2 subsystem was not made. Ensure that SYSIBM.LOCATIONS contains the location_name location.ANL061EInformation from the QMF tables could not be retrieved.ANL062EThe QMF object type must be QUERY.ANL063EThe QMF query subtype must be SQL.ANL064EThe QMF query was not saved with SHARE=YES and is restricted to the owner.ANL065EThe value specified for primary space allocation is not valid.ANL066EThe value specified for secondary space allocation is not valid.ANL067IVIEW is disabled in the ISPF Configuration Table so BROWSE is used instead.ANL068IVIEW is disabled in the ISPF Configuration Table so BROWSE is used instead. Query query_number must be found manually.ANL069EDuring an attempt to view or browse the data_set_name report, a return code of return_code_number was issued.ANL070WThe user user_ID is not authorized to save to parameter_file. Changes will be effective for only the current session.ANL071EReports are unavailable because either no previous reports exist or an error occurred when the reports were generated.ANL072EThe SQL_ID.DSN_VIRTUAL_INDEXES Db2 table could not be created.ANL073EAn error occurred while the data_set_name data set was being created.ANL074EAn error occurred while the parameter values were being copied to the data_set_name data set.ANL075EThe specified virtual index already exists in the Db2 system catalog.ANL076EThe index_name virtual index created by creator_name was not found in the Db2 system catalog.ANL077IThe specified index exists in the Db2 system catalog and was already dropped virtually.ANL078EThe specified index is a virtual index in the Db2 system catalog.ANL079EThe specified column name column_name is not in the specified table.ANL080EThe value must not contain embedded blanks.ANL081EUser 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.ANL082ENO cannot be specified for the INCLUDE NULL KEYS parameter when the key_column key column does not allow null values.ANL083ENO cannot be specified for the INCLUDE NULL KEYS parameter when YES is specified for the PARTITIONED parameter.ANL084ENO cannot be specified for the INCLUDE NULL KEYS parameter when YES is specified for the UNIQUE parameter.ANL086WThe user-level user parameter data set is unavailable or does not exist. The job cards cannot be saved.ANL087IThe job cards were saved.ANL088IThe 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.ANL089IThe user-level user parameter data set was created. Press Enter to save the job cards, or press PF3 to cancel the changes. ANL091ENO 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'.ANL092EAN ERROR OCCURRED WHEN ACCESSING userid.REGISTRY WHILE SELECTING A GENERIC ID FOR USE. VERIFY THAT THE REGISTRY WAS SET UP AND IS AVAILABLE.ANL112EThe Db2 SQL authorization ID can only be changed when SETPLAN is set to ALLOW or YES. Contact the administrator regarding the value of SETPLAN.ANL113WThe user username is not authorized to change data set name.ANL114EThe user username is not authorized to change the value of DATAGRP. The value of DATAGRP is unchanged.ANL115EThe user username is not authorized to change the value of system parameter DATAGRP in the EEEAUTH table. The value of DATAGRP is unchanged.ANL116IThe 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.ANL134Euserid 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+.ANL135EIf a wild card character is used in a Collection ID, then both Collection IDs must be identical. ANL136IAt 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.ANL137INo tables were found in the selected input.ANL9012THE 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) ANL9013SQL PA ENCOUNTERED PROBLEMS RESTORING CATALOG STATISTICS FROM prefix.ANL520.SANLSTAT (member), RC: retcode CHECK RETURN CODE, AND CONSIDER MANUAL STATS RESTORATION ANL9014SQL 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 ANL9015SQL 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. ANL9016SQL 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 ANL9017SQL 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. ANL9020THE 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) ANL9021CANNOT 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) ANL9022CANNOT 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) ANL9023CANNOT 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