Troubleshooting › Receive an Error Message in the Command Manager

Receive an Error Message in the Command Manager

Symptom:

I entered an SQL command in the DBA Command Manager for DB2 module, and I receive an error.

Solution:

Some messages clearly state the issue. For example, the following error message indicates that you have used an incorrect range:

-490, ERROR: NUMBER 1000000000000000 DIRECTLY SPECIFIED IN AN SQL STATEMENT IS OUTSIDE THE RANGE OF ALLOWABLE VALUES IN THIS CONTEXT (1, 2147483647)

Other messages can be less clear. For example, the following message indicates that you have specified an undefined name, but the message does not detail what constitutes a defined name:

-204, ERROR: SYSIBM.SYTABLES IS AN UNDEFINED NAME

To resolve command-related errors

1. Confirm that you have used the proper syntax in your command.
2. Copy the message text, paste it in the Knowledge Center, and perform a search.

   The Knowledge Center integrates with the MVS/Quick-Ref™ product by Chicago-Soft, Ltd. This feature lets you access the MVS/Quick-Ref messages directly in CA Chorus when you encounter an error.