Messages BMC17500 through BMC17599


For the 

DASD MANAGER PLUS for DB2

 product, this topic explains each message in the designated range.

Number

Description

BMC17506

The DROP_RECOVERY_LOG purge completed successfully

Explanation: The specified drop recovery log records were purged successfully from the drop recovery log.

User response: No action is required.

BMC17507

The variable variable is undefined

Explanation: The system found a variable that is undefined.

User response: Determine whether the named variable is your variable, an ISPF variable, or a CATALOG MANAGER variable. (Normally, ISPF variables start with Z, and CATALOG MANAGER variables start with ACT or CAT.)

  • If the variable is one of your variables, define it properly.
  • If the variable is an ISPF variable, collect the necessary information and contact IBM Technical Support.
  • If the variable is a CATALOG MANAGER variable, collect the necessary information and contact BMC Customer Support.


BMC17508

The SESSION_LOG purge completed successfully

Explanation: The specified session log records were purged successfully from the drop recovery log.

User response: No action is required.

BMC17509

The command text contained unrecognized parameters

Explanation: A portion of the text following the command verb was not recognized as an acceptable parameter.

User response: Ensure that the parameters are correct for the command you entered.

BMC17510

The session decrement is invalid

Explanation: You have attempted to access a session log that does not exist.

User response: Issue the SESSION command again with a valid session decrement.

BMC17511

Sorry, you are not authorized to use Catalog Manager

Explanation: Required authorization is missing.

User response: Contact your DB2 system administrator for authorization to execute the CATALOG MANAGER product’s main plan.

BMC17512

The indicated statement is not valid SQL for DropRecovery

Explanation: The SQL statement specified for Drop Recovery is not valid.

User response: Correct the Drop Recovery SQL statement.

BMC17513

At least one table must be selected for a USER search

Explanation: A USER search was attempted without selecting a table to search.

User response: Select at least one table, and perform the USER search again.

BMC17514

Some privileges in the REVOKE were granted by others

Explanation: Some of the privileges that you are trying to REVOKE were granted by others, so the REVOKE will fail. You must have SYSADM authority to revoke privileges that were granted by someone else.

User response: Revoke the privileges that you granted, then have someone with SYSADM authority revoke the remaining privileges.

BMC17515

User search requires a GRANTEE or GRANTOR value

Explanation: You attempted to search for a user, however you did not enter a value for either the GRANTOR or GRANTEE on the Catalog Search User panel.

User response: In the Catalog Search User panel, supply one or both values.

BMC17516

The search parameters for this list have been lost

Explanation: The search parameters for this list have been lost. Consequently, they cannot be refreshed.

User response: Specify the search parameters again and resubmit the request.

BMC17517

The command entered is not in the command table

Explanation: The command being issued is not in the command table.

User response: Correct the command.

BMC17518

Not enough of the command was entered to tell which one

Explanation: CATALOG MANAGER accepts abbreviated command names. However, enough characters in the command name must be entered to make the command unique from all other commands. The command name that was entered did not have enough characters specified to make it unique.

User response: Type enough characters of the command name to distinguish it from all other commands.

BMC17519

Authorization error for plan plan

Explanation: An authorization error exists for the identified plan.

User response: Ensure that you have specified the correct plan. If you have, someone with the appropriate authority must grant you sufficient authority to use the plan.

BMC17520

No DB2 SSID was entered in the SSID field

Explanation: The system requires a DB2 SSID in the SSID field, but did not find one.

User response: Enter a DB2 SSID in the SSID field.

BMC17521

Commands must be entered on the table line, not column line.

Explanation: Commands were entered on the column line. Instead, they must be entered on the table line.

User response: Enter your command on the table line.

BMC17522

RENAME requires entry of new name following command

Explanation: The system did not find a new name following the RENAME command.

User response: Enter a new name following the RENAME command.

BMC17523

CALL ATTACH RC= returnCode REASON= reason

Explanation: CALL ATTACH has returned a return code and a reason code.

User response: Determine the cause of this message from the return code and the reason code, and correct the problem.

BMC17524

The DB2 CALL ATTACH SETUP function has a nonzero return code.

Explanation: The DB2 CALL ATTACH SETUP function has issued an error code.

User response: Determine the cause of this message from the return code, and correct the problem.

BMC17525

The object type specified is not valid

Explanation: An invalid objected type was specified.

User response: Enter a valid object type.

BMC17526

PLAN plan ERROR

Explanation: CALL ATTACH has returned a return code and a reason code.

User response: Determine the cause of this message from the return code and the reason code, and correct the problem.

BMC17527

An object type must be entered for the current action

Explanation: The system did not find an object type in the object type field on the main menu.

User response: Enter the required object type in the object type field.

BMC17528

No data met the selection spec of the previous request

Explanation: No data met the selection specifications. Therefore no data was displayed.

User response: Ensure that the selection specifications are correct. If the selection specifications were correct, no action is required. If they are incorrect, correct them.

BMC17529

ssid MISMATCH

Explanation: CALL ATTACH has returned a return code and a reason code.

User response: Determine the cause of this message from the return code and the reason code, and correct the problem.

BMC17530

The qualifier is too long or has too many periods

Explanation: The format of the qualifier is not valid for a single-part name.

User response: Verify that the length of the qualifier is not too long and that the qualifier has the correct number of periods. Correct the qualifier, if necessary.

BMC17531

command is not a valid command

Explanation: The command shown is not in the CATALOG MANAGER command table. If you are in a session profile, the customized command table does not include the specified command.

User response: Enter the correct command.

BMC17532

command could be two or more valid commands

Explanation: CATALOG MANAGER accepts abbreviated versions of commands as long as the abbreviation has sufficient characters to make the command unique and distinguishable from the other commands. The portion of the command entered was not enough to distinguish it from other similar commands.

User response: Enter sufficient characters to make the command unique.

BMC17533

The object type cannot be used with command

Explanation: The object type is not valid for the command issued.

User response: Correct the object type or change the command.

BMC17534

At least one column heading must be entered as a sort key

Explanation: The SORT command requires at least one column name as a key, and the system did not find one.

User response: Enter one or more column names as sort keys.

BMC17535

The sort key entered is not any displayed column heading

Explanation: The specified sort key is not a displayed column heading.

User response: Enter one or more correct column names as sort keys.

BMC17536

The LIST command must contain a valid object type

Explanation: An invalid object type follows the LIST command.

User response: Enter a valid object type for the LIST command.

BMC17538

The object type in the LIST command is not valid for this list.

Explanation: The object type is not valid for the selected list.

User response: Enter a valid object type for the selected list.

BMC17539

The object name could not be determined from the input

Explanation: The specified object name is not valid for the specified object type.

User response: Enter the correct object name for the specified object type.

BMC17540

function is not a valid function

Explanation: The command shown is not in the CATALOG MANAGER command table.

User response: Enter the correct command.

BMC17541

objectTypeNAME REQUIRED

Explanation: The name of the indicated object type, which is required, was not entered on the current SQL specification panel.

User response: Enter the name of the indicated object type on the current SQL specification panel.

BMC17542

The valid BUFFERPOOL values are BP0, BP1, BP2 and BP3

Explanation: An invalid BUFFERPOOL value was specified. The system recognizes only BP0, BP1, BP2 and BP32K as valid BUFFERPOOL values.

User response: Specify a valid BUFFERPOOL value.

BMC17543

The number of stacked lists has reached the maximum

Explanation: The number of stacked (nested) lists has reached the maximum number allowed, which is 13.

User response: Enter a LIST or SEARCH command on the Command line, an END command to the previous list, or a RETURN command to the main menu.

BMC17544

At least one volume must be entered for a stogroup

Explanation: To create a storage group, at least one volume must be specified.

User response: Specify at least one volume.

BMC17545

The TABLE/VIEW CREATOR must be entered

Explanation: The system requires that you specify either the table or view CREATOR.

User response: Enter the ID of the table or view CREATOR.

BMC17546

command must contain a valid object type

Explanation: The indicated command must be followed by a valid object type.

User response: Enter the command again, followed by the valid object type.

BMC17547

The object type in the command command is unknown

Explanation: The indicated command is followed by an unrecognizable object type.

User response: Enter the correct object type.

BMC17548

The TABLE/VIEW name must be entered.

Explanation: CREATE SYNONYM requires the qualified name of the table or view.

User response: Enter the table or view qualified name.

BMC17549

The VCAT name or alias must be entered

Explanation: CREATE STOGROUP requires the VCAT name or alias of the VSAM catalog.

User response: Enter the VCAT name or alias of the VSAM catalog.

BMC17550

LABEL objectType qualifiedNamehad SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL LABEL ON statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17551

CREATE objectType qualifiedNamehad SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL CREATE statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17552

No processing can be done on a list with no lines

Explanation: A list must have at least one entry for valid processing.

User response: No action is required.

BMC17553

ALTER objectType qualifiedNamehad SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL ALTER statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17554

GRANT objectType had SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL GRANT statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17555

REVOKE objectType had SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL REVOKE statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17556

COPYAUTHS objectType qualifiedNamehad SQL return code returnCode

Explanation: This message shows the SQL return code for a COPYAUTHS command.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17557

COMMENT objectType qualifiedName had SQL return code returnCode

Explanation: This message shows the SQL return code for an SQL COMMENT ON statement.

User response: Ensure that the return code is what you expected. If it is appropriate, no action is required. If it is an unexpected return code, determine the cause of the error, and correct the problem.

BMC17558

objectName had no authorizations or was not found

Explanation: The FROM object of a COPYAUTHS command had no authorizations to copy, or the authorizations could not be found.

User response: If the FROM object has no authorizations, this message is informational, and no action is required. If the FROM object has authorizations, this message reports an error that requires corrective action. Determine the cause of the error, such as an incorrect object name, and correct the problem.

BMC17559

CALL ATTACH RC= returnCode REASON= reason

Explanation: A general CALL ATTACH error has occurred.

User response: Press HELP (or F1) to display the return code and reason code for the error. Determine from the return code and reason code what caused the error. Correct the cause of the error.

BMC17560

The datatype indicated with -> is invalid

Explanation: The system did not find the specified data type in the data type table.

User response: Enter a valid data type for this function.

BMC17561

command is not a valid command on this panel

Explanation: The command indicated in the long text is not valid from the current panel.

User response: Change the command or the panel.

BMC17562

The last entry must not be deleted or delete past list end

Explanation: You attempted to delete the last remaining entry in this table. This table, however, must contain at least one entry.

User response: You can leave the table with the current entry. However, if the entry must be removed, you can enter a temporary entry, then remove this entry.

BMC17563

The only valid line cmds are D(elete), I(nsert), R(epeat)

Explanation: The system found an invalid line command. The only valid line commands on the CREATE TABLESPACE and CREATE INDEX panels are D (delete), I (insert), and R (repeat).

User response: Enter a valid line command.

BMC17564

Only valid line cmds are D(elete), I(nsert), R(epeat)

Explanation: The system found an invalid line command. The only valid line commands on the CREATE TABLE and ALTER TABLE panels are D (delete), I (insert), R (repeat), and E (edit).

User response: Enter a valid line command.

BMC17565

LIST objects: CK DB TS TB IX VW PL PR SG SU DM SY CO US AL LO

Explanation: An invalid LIST object was entered on the main menu or on the Command line of a list panel. The main menu shows the first-level lists that are valid from that panel. A LIST panel shows which list commands are valid across the top of the panel.

User response: Enter a valid LIST object.

BMC17566

The character entered is not a valid line command

Explanation: The only valid line command on the CREATE VIEW and CREATE INDEX PARTITION panels is E (edit).

User response: Enter an E.

BMC17567

The field indicated by the cursor is invalid

Explanation: This message is sent to the CREATE TABLE panel when a command other than NOT NULL or WITH DEFAULT is entered in the corresponding columns.

User response: Correct the column entries.

BMC17568

List is longer than the max in your options (DOPTS in batch)

Explanation: The first CATALOG MANAGER options panel specifies the maximum number of lines in any list. The requested list has more entries than is allowed.

User response: Either change the maximum number of lines on the first CATALOG MANAGER options panel to a larger number, or redefine the request to reduce the number of entries in the requested list.

BMC17569

The COUNT command must be entered on a list line

Explanation: The COUNT command is invalid where entered.

User response: Enter the COUNT command on a list line.

BMC17570

An invalid line command was entered

Explanation: An unrecognizable line command was entered.

User response: Correct the line command.

BMC17571

A non-zero code was returned from writing the AUDIT LOG

Explanation: The log record was not written for the last executed data definition language (DDL) statement.

User response: Determine the type of error from the previously displayed SQL error panel, and correct the error.

BMC17572

A non-zero code was returned from writing the SESSION LOG

Explanation: The log record was not written for the last executed data definition language (DDL) statement.

User response: Determine the type of error from the previously displayed SQL error panel, and correct the error.

BMC17573

You can save the SQL in the SQL_Table or a PDS but not both

Explanation: You have asked the system to save the SQL in both the SQL_Table and in a PDS. The system can save SQL either in the SQL_Table or in a PDS, but not both.

User response: Resubmit the request by specifying that the system save the SQL in either the SQL_Table or in the PDS.

BMC17574

A non-zero code was returned from writing the RECOVERY LOG

Explanation: All recovery log records were not written for the last drop statement with recovery on. The object was not dropped.

User response: Determine the type of error from the previously displayed SQL error panel, and correct the error.

BMC17575

The last SQL statement executed had a code returnCode

Explanation: The last SQL statement executed returned the specified code.

User response: Determine which SQL statement was the last to be executed. Then determine whether this is an acceptable code. If it is acceptable, no action is required. If the code is not acceptable, determine the cause and correct the problem.

BMC17576

ssid INVALID SSID

Explanation: The DB2 version for the specified SSID cannot be found. Possible causes include the DB2 libraries for the specified version are not available or the SSID was entered incorrectly.

User response: Ensure that the DB2 libraries for the specified version are available and that the SSID was entered correctly.

BMC17577

commandName objectType not valid for this object

Explanation: The specified object type is not valid for the command you entered.

User response: Enter CMD on the command line to see a list of valid commands and their object types. Then, enter a valid command and object type.

BMC17578

The SAVE of the previous SQL was not successful

Explanation: The attempted SQL save failed.

User response: Check the data set name and the element (member) name, and correct any errors.

BMC17579

Can’t log image copy for DROP TB in explicit TS

Explanation: You cannot log image copy for DROP TB in an explicit TS. Therefore, the image copy cannot be used to restore data.

User response: Choose to DROP a different table, or choose not to log image copies with the selected table. Then try the DROP again.

BMC17580

Month must be 01 - 12

Explanation: An invalid month number was entered on one of the log maintenance panels.

User response: Enter a value in the range of 01 through 12.

BMC17581

Day is zero or larger than the number of days in the month

Explanation: An invalid day number was entered on one of the log maintenance panels.

User response: Enter a value other than 0 and no greater than the number of days in the specified month.

BMC17582

Mins and secs may not be over 59 and must be 0 for hour 24

Explanation: An invalid time was entered on one of the log maintenance panels. Minutes and seconds cannot be greater than 59 and must be 0 for hour 24.

User response: Enter the minutes and seconds in a range from 0 through 59.

BMC17583

Catalog Manager cannot find the names of its tables

Explanation: This message normally indicates an installation problem. The synonyms for referencing the CATALOG MANAGER tables (the logs) may not have been created using the same TSO ID as was used in binding the CATALOG MANAGER plans.

User response: Create the synonyms for referencing the CATALOG MANAGER tables (the logs) by using the same TSO ID as was used in binding the CATALOG MANAGER plans.

BMC17584

Nothing to ALTER was entered on the ALTER panels

Explanation: A request to generate an ALTER data definition language (DDL) statement was issued but no change data was entered.

User response: Enter the change data.

BMC17585

The only valid parameters are PAGE, ROW or KEY

Explanation: The system found invalid HEX parameters. The only valid parameters are PAGE, ROW, or KEY.

User response: Ensure that only the PAGE, ROW, or KEY parameters are used.

BMC17586

A name has not been entered for a key column

Explanation: On CREATE INDEX, a key column name is required.

User response: Enter a key column name.

BMC17587

The pattern must contain other than blank or wildcard

Explanation: The pattern for the volume name must contain at least one character other than a wildcard.

User response: Specify the pattern again, including at least one character.

BMC17588

An index partition did not have a limit key

Explanation: On CREATE INDEX with multiple partitions, a limit key, which is required for at least one partition, was not specified.

User response: Ensure that at least one partition has a limit key.

BMC17589

More than one column has the same key seq

Explanation: More than one column has the same key sequence.

User response: Ensure that each column has a unique key sequence.

BMC17590

Most Catalog Manager commands are not valid from this panel

Explanation: This message is issued from the additional functions menu and the search panels. Only ISPF commands are valid from these panels.

User response: Ensure that you are using only valid ISPF commands on these panels.

BMC17591

The TS command required that the timestamp be entered

Explanation: The TS command requires a timestamp which was not found.

User response: Enter a 1- to 16-digit hexadecimal number following the command.

BMC17592

YYYY-MM-DD, HH:MM:SS: XXXXXX

Explanation: This message gives the converted date and time for the timestamp and storeclock.

User response: No action is required.

BMC17593

The variable must contain only A-F and 0-9

Explanation: The TI (timestamp convert) or STCK (storeclock convert) command contained an invalid hexadecimal digit.

User response: Enter a variable containing characters A through F or digits 0 through 9.

BMC17594

ssid has posted the CALL ATTACH terminating ECB

Explanation: This DB2 system is going down or has already gone down.

User response: Notify your database administrator or the appropriate computer support personnel that the system is down.

BMC17595

PAGE number is past the end of data for this dataset

Explanation: The display of data is set by page or row. You have entered an “add to” number that is too large, and the indicated page number is past the end of data for this data set.

User response: Reduce the “add to” number.

BMC17596

After eliminating SQL that would fail nothing was left to revoke

Explanation: After eliminating SQL that would fail, nothing is left to REVOKE.

User response: Correct the SQL.

BMC17597

One or more columns in the table has no name

Explanation: One or more columns in the table lacks a name.

User response: Verify that each column in the table being created has a valid column name.

BMC17598

Unsupported DB2 Version. Use product at your own risk.

Explanation: You are using a version of CATALOG MANAGER that does not tolerate or exploit the features of the DB2 version that are you using. For example, if you are using CATALOG MANAGER version 9.3.00 or earlier on a DB2 Version 10 subsystem, you might receive unpredictable results.

User response: No action is required.

BMC17599

No passwords were found for CATALOG BROWSER

Explanation: Using CATALOG BROWSER requires installation of at least one of the BMC Software utilities. Correct installation includes specifying the password for the utility.

User response: Check whether any of the BMC Software utilities is installed.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Messages library