Previous Topic: Display Information about Message Tables

Next Topic: S9SS Messages

List of LDM Messages

The following messages can be issued by the file server, communications server, SQL server, scheduler, or CA-L-Serv's kernel.

LDM0011E

( location ) Unbalanced parentheses

Reason:

The command contains unmatched parentheses.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0012E

( location ) Misquoted text string - quote missing or not allowed

Reason:

The command contains unmatched quotes.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0013E

( location ) Parentheses not expected

Reason:

The command contains misplaced parentheses.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the statement in error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0014L

System logic error - code

Reason:

The command member invoked at CA-L-Serv startup contains inconsistent data.

Action:

Review CA-L-Serv's message log to identify the statement(s) in error. Messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0015E

Error near ( location ): Extraneous parameter xxxx - ignored

Reason:

The command contains the invalid parameter xxxx.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0016E

Unrecognized keyword xxxx

Reason:

One of the command members invoked at CA-L-Serv startup contains an invalid keyword.

Action:

Review CA-L-Serv's message log to identify the error. Restart CA-L-Serv after correcting the problem. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0017E

Keyword xxxx specified more than once

Reason:

A statement executed at CA-L-Serv startup contains an invalid repetition of keyword xxxx.

Action:

Review CA-L-Serv's message log to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0018E

Keyword xxxx could be either keyword yyyy or keyword zzzz - ambiguous

Reason:

A CA-L-Serv command contains an abbreviated keyword that cannot be processed because it is ambiguous.

Action:

Reissue the command specifying the full form of the keyword.

LDM0019E

( location ) Too many subparameters. Maximum allowed is nn. Excess parameters ignored.

Reason:

The command exceeds the maximum number of subparameters allowed for one of its keywords.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error.

LDM0020E

( location ) “text” exceeds maximum length(nn)

Reason:

The command specified a value that is in excess of the maximum length allowed.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0021E

( location ) “text “ exceeds maximum value(nn)

Reason:

The value specified by the command is in excess of the maximum allowed.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0022E

( location ) “text “ must be numeric

Reason:

The command specified a nonnumeric value where a numeric value was expected.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0023E

( location ) Unrecognized option - valid options are: options

Reason:

The command specified an invalid option. 'options' specifies the list of valid options for the command.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information.

LDM0024E

( location ) Option “xxxx “ ambiguous, could be either option1 or option2

Reason:

The command specified an abbreviated option that could be 'option1' or 'option2'.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information. Reissue the command specifying the full form of the option keyword.

LDM0025E

The xxxx parameter expects a number between n1 and n2

Reason:

The value xxxx is numeric and must be comprised between minimum value n1 and maximum value n2.

Action:

Reissue the command specifying a valid value for the parameter.

LDM0026E

The xxxx parameter expects a text string. Maximum length is nn

Reason:

The xxxx parameter must specify a text string with a maximum length of nn.

Action:

Reissue the command specifying a valid value for the parameter.

LDM0030E

( location ) Missing required parameter xxxx

Reason:

Parameter xxxx is required for this command.

Action:

Review CA-L-Serv's message log and use the information provided in [location] to identify the error. When issued at CA-L-Serv startup rather than as a response to a console command, messages LDM083E, LDM084E and LDM085E are also displayed and provide additional information. Reissue the command specifying a valid value for the parameter.

LDM0031E

( location ) operand range “xxx” invalid

Reason:

The first number you specified in a range is larger than the second number for that range.

Action:

Reissue the command specifying a valid range for the parameter.

LDM0032E

( location ) value too small. Minimum value is nnn.

Reason:

The value value specified on the command is lower than the minimum required. The minimum permissible value is nnn.

Action:

Reissue the command specifying a valid value for the parameter.

LDM0033I

A number between n1 and n2 may also be specified

Reason:

The value can also be comprised between minimum n1 and maximum n2.

Action:

Reissue the command specifying a valid value for the parameter.

LDM0034I

A text string, maximum length nnn, may also be specified

Reason:

A text string of maximum length nnn can also be specified.

Action:

Reissue the command specifying a valid value for the parameter.

LDM0035I

These options: optionlist may also be specified

Reason:

The options indicated by optionlist are also valid for the command.

Action:

Reissue the command specifying valid options.

LDM0036I

optionlist

Reason:

The options indicated by optionlist are valid for the command.

Action:

Reissue the command specifying valid options.

LDM0037E

Keyword xxxx must be specified

Reason:

Keyword xxxx must be specified for this command.

Action:

Reissue the command including keyword xxxx.

LDM0038E

Keywords xxxx and yyyy are mutually exclusive - specify only one

Reason:

Keywords xxxx and yyyy are mutually exclusive.

Action:

Reissue the command specifying only one of the mutually exclusive keywords.

LDM0039E

Specify at least one of these keywords: keywords

Reason:

At least one of the keywords specified by keywords must be specified when issuing the command.

Action:

Reissue the command specifying at least one of the keywords.

LDM0040E

The xxxx parameter expects a hex string. Maximum length is nnn bytes.

Reason:

The parameter indicated by xxxx must only contain characters 0-9 and A-F and its length must not exceed nnn bytes.

Action:

Reissue the command specifying a valid hex string.

LDM0060L

Logic error: MSG# xx issued by csect is invalid - not defined

Reason:

Message xx was not found in any of CA-L-Serv's message tables.

Action:

Make sure all message tables in their current versions are allocated to CA-L-Serv. If you have recently upgraded from a prior release, verify that the LSERVMSG message table in the LDMPARM data set was also upgraded.

Retain CA-L-Serv's logs and call CA Support.

LDM0061L

Logic error: MSG# xx issued by csect got bad WTO return code xxxx

Reason:

WTO in CSECT csect failed for message xx with a return code of xxxx.

Action:

Consult the relevant IBM documentation for an explanation of the return code. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0062L

Logic error: MSG# xx issued by csect has bad WTOR parameter list

Reason:

WTOR in CSECT csect failed for message xx because it was invoked with an invalid parameter list.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0063L

Logic error: MSG# xx issued by csect has no text

Reason:

Message xx does not have any text.

Action:

Make sure all message tables in their current versions are allocated to CA-L-Serv. If you have recently upgraded from a prior release, verify that the LSERVMSG message table in the LDMPARM data set was also upgraded.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0064E

Invalid line type xx on MSG statement - message yy discarded

Reason:

An invalid line type xx was specified for a multi-line message on the MSG statement.

Valid line types for multi-line messages are:

Action:

Refer to the CA-L-Serv Command Reference and the comments in the LSERVMSG message table provided in the CAI.CAIOPTN data set for a description of the syntax for the MSG statement.

LDM0065E

Syntax errors in message table - check message log

Reason:

The message table that CA-L-Serv attempted to read contains syntax errors.

Action:

This would happen after making changes to a message table (such as translating standard English messages to a different language). Check the syntax of the messages you modified. Retain the appropriate diagnostic information and call CA Support.

LDM0070E

xxxx is ambiguous - could mean yyyy or zzzz

Reason:

Abbreviated parameter xxxx is ambiguous. CA-L-Serv cannot process the command.

Action:

Reissue the command specifying one of the full-length values: yyyy or zzzz.

LDM0071E

Command xxxx not found - task may be inactive

Reason:

CA-L-Serv does not recognize command xxxx.

Action:

If the command was correctly spelled, use the DISPLAY command to verify that the target component is active: CA-L-Serv commands are only valid when the corresponding component is active.

LDM0072E

Unexpected positional operand xxxx

Reason:

Positional operand xxxx is not valid for the command.

Action:

Check the description of the command's syntax.

LDM0073E

No task named xxxx currently attached

Reason:

The corresponding CA-L-Serv component is not currently active.

Action:

Use the DISPLAY command to list the currently active components. After having determined why the target component was not active, you can issue the ATTACH command to activate it.

LDM0078E

Invalid operand for “L=”

Reason:

Incorrect routing information was specified on a message definition

Action:

Correct the message definition and use the MSGTABLE command to refresh the copy of the message table in storage.

LDM0080I

Command from CONID ucmid: command

Reason:

CA-L-Serv command command was issued from console ucmid.

Action:

No action required. This message is informational.

LDM0081I

EXEC statement parms: parameters

Reason:

The message writes the values specified on the PARM parameter of the EXEC statement of CA-L-Serv's start-up procedure.

Action:

No action required. This message is informational.

LDM0082E

Parameter syntax error in EXEC card parm field

Reason:

CA-L-Serv is terminating due to a syntax error on the PARM parameter of the EXEC statement of CA-L-Serv's start-up procedure. Messages LDM0084E and LDM0085E identify the statement that contains the error.

Action:

Check the syntax for the PARM parameter.

LDM0083E

Command syntax error in command file statement

Reason:

CA-L-Serv is terminating because a command in CA-L-Serv's parameter data set contains a syntax error. Messages LDM0084E and LDM0085E identify the command that contains the error.

Action:

Check for additional messages in CA-L-Serv's message log.

LDM0084E

Text in error follows

Reason:

CA-L-Serv is terminating due to a syntax error on the PARM parameter of the EXEC statement of CA-L-Serv's start-up procedure. Messages LDM0084E and LDM0085E identify the statement that contains the error.

Action:

Check the syntax for the PARM parameter.

LDM0085E

text

Reason:

CA-L-Serv is terminating due to a syntax error on the PARM parameter of the EXEC statement of CA-L-Serv's start-up procedure. Messages LDM0084E and LDM0085E identify the statement that contains the error.

Action:

Check the syntax for the PARM parameter.

LDM0086E

DDname LDMCMND not found. Initialization parameters not processed.

Reason:

CA-L-Serv is terminating because it cannot find or access its parameter data set.

Action:

Add a DD statement for the CA-L-Serv parameter data set in the CA-L-Serv startup procedure (LSVPROC).

LDM0087E

Member xxxx not found in LDMCMND data set

Reason:

CA-L-Serv cannot find the specified member in its parameter data set. If this member is critical, CA-L-Serv terminates.

Action:

Verify that the member you specified in CA-L-Serv's start-up procedure is a member of the PDS allocated to DDN=LDMCMND. Verify that every INCLUDE statement in this member specify actual members of the PDS.

LDM0088E

Error during open processing. Initialization parameters not processed.

Reason:

CA-L-Serv is terminating because it encountered an error when trying to open its parameter data set. If this message follows message LDM0086E, it indicates a user error. Otherwise, it indicates an internal logic error.

Action:

Examine previous messages for information on what type of error occurred. If an internal logic error produced this message, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0089I

These statements input from member xxxx

Reason:

An entry in CA-L-Serv's parameter data set is too long. The maximum length of an entry is 800 bytes; additional characters are ignored. The last LDM0090I message identifies the statement containing the error.

Action:

Correct the entry in one of these ways:

LDM0090I

statement

Reason:

An entry in CA-L-Serv's parameter data set is too long. The maximum length of an entry is 800 bytes; additional characters are ignored. The last LDM0090I message identifies the statement containing the error.

Action:

Correct the entry in one of these ways:

LDM0091E

Too many continuations - excess discarded

Reason:

An entry in CA-L-Serv's parameter data set is too long. The maximum length of an entry is 800 bytes; additional characters are ignored. The last LDM0090I message identifies the statement containing the error.

Action:

Correct the entry in one of these ways:

LDM0092I

OK

Reason:

Acknowledges successful processing of an operator's action.

Action:

No action required. This message is informational.

LDM0093E

Command xxxx is valid only during initialization - issue from LDMPARM or start-up proc

Reason:

The command can only be issued at CA-L-Serv start-up.

Action:

If the changes to CA-L-Serv's current configuration must be implemented immediately, terminate and restart CA-L-Serv. Otherwise make the necessary changes to LDMPARM or the start-up proc so that they will be implemented the next time CA-L-Serv is recycled.

LDM0094E

More input expected after text

Reason:

The command is incomplete.

Action:

Refer to the description of the command's syntax.

LDM0097E

Member name missing on INCLUDE statement

Reason:

An INCLUDE statement in LDMPARM does not specify a member name.

Action:

Check the INCLUDE statements in each LDMPARM member.

LDM0098I

Resuming input from member xxxx

Reason:

CA-L-Serv finished reading the member named on an INCLUDE statement and will begin to read the member named xxxx again.

Action:

No action required. This message is informational.

LDM0100I

CA-L-Serv initialization complete

Reason:

Signals that CA-L-Serv is ready to process requests from client applications.

Action:

No action required. This message is informational.

LDM0101E

CA-L-Serv abend code at displacement in module, PSW: word

Reason:

One of CA-L-Serv's components has abended. In most cases, CA-L-Serv's recovery routines will ensure that the region and its subtasks will remain active after performing necessary clean up.

Action:

Look up the abend code in the System Codes manual for your version of MVS. If you are unable to determine the cause of the error, gather the appropriate diagnostic information (symptom dump, abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0102I

CA-L-Serv termination request accepted

Reason:

Acknowledgment of a SHUTDOWN command. CA-L-Serv will terminate.

Action:

No action required. This message is informational.

LDM0103I

CA-L-Serv has terminated

Reason:

CA-L-Serv shutdown has completed.

Action:

No action required. This message is informational.

LDM0104E

CA-L-Serv is terminating due to bad initial parameters in LDMPARM or start-up proc

Reason:

A syntax error in the LDMPARM command members or the start-up procedure has prevented CA-L-Serv form initializing successfully. CA-L-Serv terminates.

Action:

Review CA-L-Serv's message log to identify the statement in error.

LDM0105E

CA-L-Serv abend during termination code at displacement in module, PSW: word

Reason:

An ESTAE routine within CA-L-Serv experienced an abend while trying to perform error recovery processing.

Action:

Look up the abend code in the System Codes manual appropriate for your version of MVS. If you are unable to determine the cause of the error, gather the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0106E

CA-L-Serv already active with subsystem ssname - unique subsystem name required

Reason:

A CA-L-Serv region with subsystem name ssname is already active on the system. CA-L-Serv terminates.

Action:

Determine why a second region with the same subsystem name was started on the same system.

LDM0107L

CA-L-Serv Interface error. Function: task, RC=code

Reason:

An internal error has occurred.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0110E

Release incompatibility detected. component is at level x while CA-L-Serv is at level y.

Reason:

The code executing in component and CA-L-Serv are not at the same release level and are incompatible.

Action:

Ensure that component came from the same release or PTF tape as the version of CA-L-Serv that you are running.

LDM0128L

CA-L-Serv is terminating due to bad internal defaults

Reason:

CA-L-Serv's default initialization values are in error.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0131E

GETMAIN error in module modname +displacement; R15=code

Reason:

CA-L-Serv experienced an error while trying to obtain storage.

Action:

Look up the return code in the appropriate manual for your version of MVS. You may need to increase the size of CA-L-Serv's region. If you cannot determine the cause of the error, gather the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0132E

FREEMAIN error in module modname +displacement; R15=code

Reason:

CA-L-Serv experienced an error while trying to free storage.

Action:

Look up the return code in the appropriate manual for your version of MVS. If you cannot determine the cause of the error, gather the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0133I

SVC dump not requested for CA-L-Serv abend; SVCDUMP=NO specified

Reason:

CA-L-Serv's recovery code is designed to take optional SVC dumps to assist in diagnosing potential problems. The message indicates that the SVC dump option is not active.

Action:

Look for other messages which may help determine the cause of the problem and why CA-L-Serv abended. You should probably reset the SVCDUMP option to YES to gather appropriate diagnostic data in the event of a reoccurrence.

LDM0134I

SVC dump not requested for CA-L-Serv abend; ESTAE specified no dump

Reason:

CA-L-Serv's recovery routines were unable to capture a dump.

Action:

Look for other messages which may help determine the cause of the problem and why CA-L-Serv abended.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0135E

I/O error on log data set - log processing terminated - will use system log

Reason:

One of CA-L-Serv's log data sets has been disabled due to an I/O error. CA-L-Serv will route the messages concerning this log data set to the system log until the problem is corrected.

Action:

Review CA-L-Serv's logs and the system log to determine the cause of the I/O error. For more information, see the IECxxxx messages in CA-L-Serv's job log or the system log.

LDM0141I

CA-L-Serv Sessions

Reason:

These messages display the internal sessions active for a CA-L-Serv region.

Action:

No action required. These messages are informational.

LDM0142I

Client System File SQL Commserver

Reason:

These messages display the internal sessions active for a CA-L-Serv region.

Action:

No action required. These messages are informational.

LDM0143I

client system file sql Commserver

Reason:

These messages display the internal sessions active for a CA-L-Serv region.

Action:

No action required. These messages are informational.

LDM0195I

command command is complete

Reason:

CA-L-Serv has successfully processed the command.

Action:

No action required. This message is informational.

LDM0196I

command command is complete

Reason:

CA-L-Serv has successfully processed the command.

Action:

No action required. This message is informational.

LDM0197L

xxxx command abended

Reason:

CA-L-Serv abended while processing command xxxx.

Action:

Gather the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0199E

CA-L-Serv library not APF authorized - terminating

Reason:

While trying to initialize, CA-L-Serv detected that it was not running APF authorized.

Action:

Check that the CA-L-Serv loadlib is APF authorized, making sure that the dsname and the volser in the APFlist are spelled correctly. Check the link-edit attributes of the modules in the CA-L-Serv loadlib. Most CA-L-Serv modules need to have been link-edited with an authorization code of 1—AC(1).

LDM0310I

Processing LCOMINIT for APPL=productid, QUALIFIER=sysid

Reason:

A client application is initializing a session with the communications server.

Action:

No action required. This message is informational.

LDM0311I

LCOMINIT is implicitly defining APPL=productid, QUALIFIER=sysid

Reason:

The communications server is creating internal definitions for a client application.

Action:

No action required. This message is informational.

LDM0312L

Error attempting to define APPL=productid, QUALIFIER=sysid

Reason:

The communications server encountered an error while attempting to create internal definitions for client application productid executing on system - sysid.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0313I

LCOMINIT failed for duplicate APPL=productid, QUALIFIER=sysid

Reason:

The communications server attempted to create internal definitions for client application productid that is already active on system sysid.

Action:

Look for error messages issued by the client application. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call the client application's CA Support.

LDM0314I

LCOMINIT failed - RC=code

Reason:

The communications server attempted to create internal definitions for a client application but the attempt failed.

Action:

Look for error messages issued by the client application. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call the client application's CA Support.

LDM0315I

LCOMINIT failed: insufficient storage

Reason:

CA-L-Serv was unable to acquire the storage necessary to create a new communications server application.

Action:

Look for error messages issued by the client application. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call the client application's CA Support.

LDM0316I

Processing LCOMSHUT for ASCB=address, ASID=address

Reason:

A client application terminated before ending its session with the communications server.

Action:

No action required. The communications server will perform clean up for the client application.

LDM0317I

Processing LCOMSHUT for APPL=productid, QUALIFIER=sysid

Reason:

A client application is ending its session with the communications server.

Action:

No action required. This message is informational.

LDM0318I

LCOMSHUT from APPL=productid, QUALIFIER=sysid ignored: application is not currently active

Reason:

A client application attempted to terminate a session with an application on another system but that application is not active.

Action:

No action required. This message is informational.

LDM0319I

BCA received from CommServer system sysid

Reason:

The communications server regularly broadcasts service messages to all his partners in the complex. This message is issued when the local communications server receives a broadcast message from the communications server running on system sysid.

Action:

No action required. This message is informational.

LDM0320L

BCA received from inactive or undefined CommServer system at applid

Reason:

The local communications server received a broadcast from an undefined communications server or a communications server that had been marked inactive.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0321L

Unable to acquire storage in module at + displacement, R15=code

Reason:

CA-L-Serv failed to acquire storage.

Action:

Identify the cause for the failure using the value in R15 and the relevant IBM documentation. If this does not result from a more general storage problem on the z/OS system, collect the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0324L

LCMBUF unable to locate send request block for APPL=productid, QUALIFIER=sysid

Reason:

The communications server encountered an internal logic error.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0327I

APPL=productid, QUALIFIER=sysid is drained

Reason:

The communication server session for client application productid executing on system sysid has terminated.

Action:

No action required. This message is informational.

LDM0328I

APPL=productid, QUALIFIER=sysid put on hold: exceeded HOLDBUF limit

Reason:

A client application is already using all its available transmission buffers. Incoming data is rejected until the client application receives the buffers' contents.

Action:

If this occurs on a fairly frequent basis, you may need to increase the HOLDBUF value specified when the communications server is activated. You may also need to increase the number of buffers specified through the SENDLIMIT keyword of the ATTACH command.

LDM0331L

Getmain error in module xxxx at + displacement, R15=code

Reason:

CA-L-Serv failed to acquire storage.

Action:

Identify the cause for the failure using the value in R15 and the relevant IBM documentation. After ruling out a more general storage problem on the z/OS system, collect the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0332I

APPL=productid, QUALIFIER=sysid deactivated by LCOMSHUT request

Reason:

A client application is ending its session with the communications server.

Action:

No action required. This message is informational.

LDM0333I

APPL=productid, QUALIFIER=sysid deactivated at end of memory

Reason:

The client application productid executing on system sysid has terminated.

Action:

No action required. This message is informational.

LDM0334I

Session ended between source and target

Reason:

A communications server session between source and target has terminated.

Action:

No action required. This message is informational.

LDM0337I

Broadcast queued to sysid

Reason:

The communications server regularly broadcasts service messages to all his partners in the complex. This message is issued when the local communications server queues a broadcast message bound for the communications server running on system sysid.

Action:

No action required. This message is informational.

LDM0338I

Broadcast queued to all active systems

Reason:

The communications server regularly broadcasts service messages to all his partners in the complex. This message is issued when the local communications server queues a broadcast message bound for all active systems in the complex.

Action:

No action required. This message is informational.

LDM0341I

CommServer VTAM task initializing

Reason:

The VTAM component of the communications server is initializing.

Action:

No action required. This message is informational.

LDM0342I

CommServer VTAM task terminating

Reason:

The VTAM component of the communications server is terminating.

Action:

No action required. This message is informational.

LDM0354E

Error during VTAMaction to route, CODE=code RTNCD=code FDB2=code SSEI=code SSMI=code USNSI=code CNTDC=code ROUTCDE=code

Reason:

VTAM reported a communication error on the named route. The codes reflect VTAM values, returned from the RPL.

Action:

The message names the route where the error occurred. Use the DISPLAY ACTIVE and DISPLAY ROUTES commands on both CA-L-Serv nodes involved to check the status of the Communication Server and the communications routes. Note that in many instances this message does not signal a functional problem with CA-L-Serv. It may only signal that a partner of the local communications server is shutting down, inactive or has not yet initialized.

Refer to the appropriate IBM manuals relevant to your environment for a full discussion of the VTAM action and the return codes displayed as part of the message.

LDM0355E

Error during APPCCMD RPL6REQ=code RCPRI=code RCSEC=code ROUTCDE=code

Reason:

VTAM reported a communication error within an LU6.2 session. The codes reflect VTAM values, returned from the RPL.

Action:

The message names the route where the error occurred. Use the DISPLAY ACTIVE and DISPLAY ROUTES commands on both CA-L-Serv nodes involved to check the status of the Communication Server and the communications routes. Note that in many instances this message does not signal a functional problem with CA-L-Serv. It may only signal that a partner of the local communications server is shutting down, inactive or has not yet initialized.

Refer to the appropriate IBM manuals relevant to your environment for a full discussion of the return codes displayed as part of the message.

LDM0400I

CA-L-Serv DISPLAY command

Reason:

These introductory messages are displayed in response to any successful DISPLAY command. They are also a reminder of the release and maintenance level of CA-L-Serv currently running. They are followed by messages that are specific to the requested display.

Action:

No action required. These messages are informational.

LDM0401I

release maintlevel

Reason:

These introductory messages are displayed in response to any successful DISPLAY command. They are also a reminder of the release and maintenance level of CA-L-Serv currently running. They are followed by messages that are specific to the requested display.

Action:

No action required. These messages are informational.

LDM0402I

CA-L-Serv version -

Reason:

These introductory messages are displayed in response to any successful DISPLAY command. They are also a reminder of the release and maintenance level of CA-L-Serv currently running. They are followed by messages that are specific to the requested display.

Action:

No action required. These messages are informational.

LDM0403I

CA-L-Serv initialization parameters -

LDM0010I  MEMBER=member
LDM0010I  REUSE=value
LDM0010I  SSNAME=ssname
LDM0010I  SYSNAME=sysname

Reason:

These messages display the current values of the following parameters, which are set in CA-L-Serv's start-up procedure:

MEMBER

Identifies the member that CA-L-Serv is using as its source of start-up commands.

REUSE

Indicates whether CA-L-Serv is reusing common intercepts and storage.

SSNAME

Displays the subsystem name being used by CA-L-Serv.

SYSNAME

Displays the name assigned to the local system.

Action:

No action required. These messages are informational.

LDM0404I

CA-L-Serv options -

LDM0010I  SVCDUMP=value?
LDM0010I  TRACE=value

Reason:

These messages display the current values of the following operands of the OPTIONS command:

SVCDUMP

Indicates whether CA-L-Serv generates an SVC dump if an error occurs in its address space.

TRACE

Indicates whether CA-L-Serv's trace feature is active or inactive.

Action:

No action required. These messages are informational.

LDM0410I

CA-L-Serv subsystem interface table -

Name     Status   SSCTUSE   SSCTSUS2   SSCTSSVT
ssname   status   address   address    address

Reason:

These messages display information about subsystems and are CA-L-Serv's response to the DISPLAY SSNAME command. The name, status, and associated control block addresses are shown for each subsystem. Message LDM0412I is repeated for all subsystems defined to the z/OS system.

Action:

No action required. These messages are informational.

LDM0413I

No subsystems found

Reason:

There are no messages currently defined to the z/OS system.

Action:

No action required. This message is informational.

LDM0417I

DISPLAY command is complete

Reason:

This message signals that CA-L-Serv has successfully completed the requested display.

Action:

No action required. This message is informational.

LDM0418E

Dynamic allocation of ddname dataset failed; R15=code1, error code=code2, info code=code3

Reason:

CA-L-Serv was unable to allocate data set ddname.

Action:

Look up the codes shown in this message in the section on SVC 99 return codes in the appropriate manual for your version of MVS. Possible causes may include a dsname that is misspelled, or a data set already allocated to another task or user.

LDM0420I

CA-L-Serv active tasks -

Reason:

These messages are CA-L-Serv's response to the DISPLAY TASKS command. Message LDM0421I is repeated for each active task.

Action:

No action required. These messages are informational.

LDM0421I

task

Reason:

These messages are CA-L-Serv's response to the DISPLAY TASKS command. Message LDM0421I is repeated for each active task.

Action:

No action required. These messages are informational.

LDM0422I

CA-L-Serv message tables -

Reason:

These messages show the names of CA-L-Serv's message tables, the languages they support, and the number of messages per table and language. An asterisk (*) before a language identifies the default language for a message table.

Action:

No action required. This message is informational.

LDM0423I

Table Language Msg count

Reason:

These messages show the names of CA-L-Serv's message tables, the languages they support, and the number of messages per table and language. An asterisk (*) before a language identifies the default language for a message table.

Action:

No action required. This message is informational.

LDM0424I

name language nnnnn

Reason:

These messages show the names of CA-L-Serv's message tables, the languages they support, and the number of messages per table and language. An asterisk (*) before a language identifies the default language for a message table.

Action:

No action required. This message is informational.

LDM0425I

CA-L-Serv storage usage-

Reason:

These messages display storage information for CA-L-Serv:

Buffsize

Contains the size of a storage block (in bytes).

Allocated

Contains the number of blocks allocated.

Bytes

Contains the total storage for blocks of this size.

Usage

Contains the number of times this size storage block was used.

Action:

No action required. This message is informational.

LDM0426I

Buffsize   Allocated   Bytes   Usage

Reason:

These messages display storage information for CA-L-Serv:

Buffsize

Contains the size of a storage block (in bytes).

Allocated

Contains the number of blocks allocated.

Bytes

Contains the total storage for blocks of this size.

Usage

Contains the number of times this size storage block was used.

Action:

No action required. This message is informational.

LDM0427I

nnn nnn nnn nnn

Reason:

These messages display storage information for CA-L-Serv:

Buffsize

Contains the size of a storage block (in bytes).

Allocated

Contains the number of blocks allocated.

Bytes

Contains the total storage for blocks of this size.

Usage

Contains the number of times this size storage block was used.

Action:

No action required. This message is informational.

LDM0450E

Attach failed for module xxxx

Reason:

An installation error or short-on-storage condition may have occurred.

Action:

Look for an z/OS IEAxxxxx or IEFxxxxx message or a dump and retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0451E

Task xxxx on ATTACH or DETACH command is not defined

Reason:

The task specified on the ATTACH or DETACH command is not valid.

Action:

Reissue the command specifying a valid task name.

LDM0452E

subtask is already active

Reason:

The task subtask has already been activated through a prior ATTACH command.

Action:

Review CA-L-Serv's message logs and determine why the subtask is already active.

LDM0453E

taskname is ambiguous - could mean xxxx or yyyy

Reason:

The truncation for a task name is invalid. CA-L-Serv cannot determine which of the two tasks is being referred to.

Action:

Reissue the command, specifying the full task name.

LDM0454E

task is permanent - cannot be attached or detached

Reason:

You attempted to ATTACH or DETACH a task that is part of the CA-L-Serv kernel. These tasks are automatically initialized at CA-L-Serv start-up and remain active until CA-L-Serv is shut down. They cannot be ATTACHed or DETACHed.

Action:

Use the ATTACH and DETACH commands only for relevant tasks such as the file server or the communications server.

LDM0455E

task is not currently installed

Reason:

An internal error occurred in the CA-L-Serv kernel.

Action:

Collect the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0475E

Requested task is not active

Reason:

An attempt was made to DETACH a task that is not currently active.

Action:

Determine why the task is not active. Issue the DISPLAY ACTIVE command to determine which tasks are currently active in the CA-L-Serv region. If the task should have been active, review CA-L-Serv's logs and look for prior error messages and determine why the task is no longer active.

LDM0476E

Load failed for module xxxx - command terminated

Reason:

An installation error or short-on-storage condition may have occurred.

Action:

Look for a z/OS IEAxxxxx or IEFxxxxx message or a dump and retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0477E

function abended, completion code xxxx

Reason:

The specified function has abended. CA-L-Serv requests a dump if SVCDUMP(YES) was specified. If possible, CA-L-Serv continues without the function.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0500I

File server task is now active

Reason:

The File Server has successfully completed initialization.

Action:

No action required. This message is informational.

LDM0501I

File server task is now inactive

Reason:

The File Server has terminated.

Action:

No action required. This message is informational.

LDM0502E

Allocation failed for ddname - dsname required

Reason:

An ADDFILE command for file ddname failed because the command did not specify a dsname.

Action:

Reissue the command specifying a valid dsname.

LDM0503I

ddname successfully added

Reason:

An ADDFILE command for file ddname completed successfully. The data set is now allocated to the CA-L-Serv region.

Action:

No action required. This message is informational.

LDM0504E

ddname is already allocated to dsname

Reason:

An ADDFILE command for file ddname specified a dsname that is already allocated to this same dsname.

Action:

Use the DISPLAY DATA command to list data sets currently allocated to CA-L-Serv.

Review CA-L-Serv's logs to determine why the data set is currently allocated to CA-L-Serv and if a prior REMOVEFILE command failed to de-allocate the data set.

If any operational problems are detected, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0505E

Unsupported data set organization (dsorg)

Reason:

An ADDFILE command was issued against a non-VSAM data set. CA-L-Serv does not support the file organization shown in dsorg. (This value is shown as four hexadecimal digits taken from the dynalloc control block.)

Action:

Reissue the ADDFILE command specifying a VSAM file.

LDM0506E

component is already active

Reason:

An attempt was made to activate a component of CA-L-Serv through an ATTACH command but the component is already active.

Action:

No action required. This is only CA-L-Serv's response when an attempt is made to activate a second file server or communications server in a given CA-L-Serv region.

LDM0507L

Invalid file server request - code=xxxx address=yyyy

Reason:

A file server request could not be serviced because the function code was invalid. An installation error may have occurred. Request type xxxx and address yyyy are displayed to help determine the cause of the problem.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0508E

File server request failed - code=xx RC=yy reason=zz

Reason:

The file server could not service the request because context information was missing or invalid. The values displayed as part of the message will help CA Support determine the cause of the problem.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0509E

Open failed for ddname - error=code

Reason:

An error occurred while VSAM was processing an OPEN request for the specified ddname. (Another job or task may be using this data set.) The file is marked as ERROR in the database display and cannot be used until the error is corrected.

Action:

Look up the error code in the appropriate VSAM macro reference manual and correct the error. Then use the OPENFILE command to make the file available.

LDM0510E

VSAM error for ddname code=code1 R15=code2 FDBWD=code

Reason:

An error occurred following a VSAM open for the specified ddname. Code1 represents the VSAM function, which was invoked when the error occurred while code2 and code respectively indicate the return-code and the feedback code upon returning from VSAM.

Action:

Look up the return-code and feedback code in the appropriate VSAM macro reference manual and correct the error. Then use the OPENFILE command to make the file available.

LDM0511L

Abend processing request - code=xxxx address=xxxx

Reason:

The file server experienced an abend while it serviced a request. The request is suspended and an SVC dump is requested. The message is issued while the file server is attempting to recover from the abend.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0512I

Buffer pool nn successfully built

Reason:

CA-L-Serv successfully processed a request to create shared VSAM buffer pool nn.

Action:

No action required. This message is informational.

LDM0513E

Buffer pool nn already exists

Reason:

An attempt was made to create shared buffer pool nn that had already been defined to VSAM through a prior ADDPOOL command.

Action:

Use the DISPLAY BUFFER command to list the currently defined shared buffer pools. Review CA-L-Serv's logs to determine when the buffer pool was defined.

LDM0519E

Unable to build buffer pool nn - RC=code

Reason:

A VSAM error occurred when CA-L-Serv tried to build a buffer pool.

Action:

Look up the value for code in your VSAM macro reference manual (macro BLDVRP). Usually, a shortage in storage space (RC=8) causes this problem. If so, reduce the number of buffers in the pool or increase the value for the REGION parameter in CA-L-Serv's start-up procedure.

LDM0521E

File server request failed - function=xxxx ddname=ddname return code=yyyy reason code=zzzz

Reason:

A file server request failed for ddname ddname. The function being performed by the File Server is represented by a two-digit (xx) value, which is usually of interest only for CA Support. However, values 0-5 are reserved for I/O requests and are consistent with the VSAM terminology found in the RPLREQ field of the RPL macro - 0=GET, 1=PUT and so on. A number of other function codes correspond to internal requests, which fall outside the scope of this manual.

Action:

See the information on the applicable return and reason codes.

If necessary retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0522I

File server managed databases -

Reason:

These messages display information for all managed files in response to the DISPLAY DATABASE command.

For each file, CA-L-Serv displays:

Action:

No action required. These messages are informational.

LDM0523I

Ddname Dsname/Options/Status

Reason:

These messages display information for all managed files in response to the DISPLAY DATABASE command.

For each file, CA-L-Serv displays:

Action:

No action required. These messages are informational.

LDM0524I

ddname dsname status

Reason:

These messages display information for all managed files in response to the DISPLAY DATABASE command.

For each file, CA-L-Serv displays:

Action:

No action required. These messages are informational.

LDM0525I

ddname is not a managed ddname

Reason:

A command such as REMOVEFILE or DISPLAY DATA specified ddname ddname that is not currently under CA-L-Serv's control.

Action:

Use the DISPLAY DATA command to list all data sets currently under CA-L-Serv's control. If appropriate, reissue the command specifying the correct ddname.

LDM0526I

File server options -

LDM0010I 	BUFFERSIZE=bytes
LDM0010I 	COMMSERVERSSN=ssname
LDM0010I 	MAXDORM=seconds
LDM0010I 	SERVERTYPE=type

Reason:

These messages are displayed in response to the DISPLAY TASK(FILESERVER),OPTIONS command.

One of the following values appears on SERVERTYPE:

Action:

No action required. These messages are informational.

LDM0527I

xxx is not a file group

Reason:

An attempt was made to refer to file group xxx but the file group does not exist.

Action:

Refer to the information on file groups and the commands that allow the monitoring of file groups.

LDM0528E

File server not available - try again later

Reason:

The file server is currently inactive.

Action:

Take one or more of these actions:

LDM0529I

ddname is no longer held

Reason:

A RELEASEFILE command against file ddname was successfully processed by CA-L-Serv.

Action:

No action required. The file is now available to users and jobs.

LDM0530I

ddname is now closed

Reason:

A CLOSEFILE command against file ddname was successfully processed by CA-L-Serv.

Action:

No action required. The file is unavailable to users and jobs until it is reopened by an OPENFILE command.

LDM0531I

ddname is now open and ready for use

Reason:

An OPENFILE command against file ddname was successfully processed by CA-L-Serv.

Action:

No action required. The file is now available to users and jobs.

LDM0532I

ddname has been removed

Reason:

A REMOVEFILE command against file ddname was successfully processed by CA-L-Serv.

Action:

No action required. The file is de-allocated from CA-L-Serv and is now available to other jobs.

LDM0533I

ddname is now held

Reason:

A HOLDFILE command against file ddname was successfully processed by CA-L-Serv.

Action:

No action required. The file is now unavailable to users and jobs.

LDM0534I

ddname is not a managed ddname

Reason:

A file management command, such as OPENFILE or CLOSEFILE, referred to file ddname but the file is not currently under CA-L-Serv's management.

Action:

Use the DISPLAY DATA command to list all data sets currently managed by CA-L-Serv. Determine why the ddname specified on the command does not correspond to a file under CA-L-Serv's management.

LDM0535E

Error in file ddname: Attribute xxxx must be the same for all files in a file group

Reason:

All files in a file group must share certain attributes such as logical record length, key length and key offset (for KSDS files).

Action:

Refer to the discussion of file groups and their characteristics.

LDM0536E

POOL operand required if OPTION(DEFER) is specified

Reason:

VSAM deferred writes are only available to LSR data sets. Because no buffer pool was specified on the ADDFILE command CA-L-Serv will attempt to open the data set NSR.

Refer to the CA-L-Serv sections of the Administration Guide and Reference Guide and to the IBM manual z/OS DFSMS Using Data Sets for a discussion of NSR and LSR restrictions as well as information about private and shared buffer pools.

Action:

Specify a valid buffer pool on the ADDFILE command and reissue the command. If no suitable buffer pool exists for the data set use the ADDPOOL command to define the buffer pool.

LDM0537E

Unknown buffer pool nn - probably not defined yet

Reason:

A buffer pool specified on an ADDFILE command does not exist.

Action:

Review CA-L-Serv's logs to determine why the buffer pool does not exist and whether a prior ADDPOOL command failed. If the ADDPOOL command failed determine the cause of the error and reissue the command after correcting the problem.

If the error cannot be corrected or if any operational problems are detected, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0539I

File ddname opened

Reason:

File ddname was successfully opened by the file server.

Action:

No action required. This message is informational.

LDM0545I

File ddname closed

Reason:

File ddname was successfully closed by the file server.

Action:

No action required. This message is informational.

LDM0546I

File server database statistics -

LDM0547I Ddname   PUT   SEQ GET   DIR GET   ERASE   RETRY
LDM0549I ddname    nn        nn        nn      nn      nn
LDM0550I [avg.    n.n       n.n       n.n     n.n     n.n]

Reason:

In response to the DISPLAY STATISTICS command, these messages display counts of VSAM file I/O activity, as follows:

Ddname

Contains the ddname of a managed file. If you specify a ddname on the DISPLAY command, CA-L-Serv displays information about that file only. Otherwise, it displays information about all managed files.

PUT

Contains the number of logical write requests issued for the data set.

SEQ GET

Contains the number of logical read requests issued for the data set in sequential mode.

DIR GET

Contains the number of random read requests issued for the data set.

ERASE

Contains the number of records deleted from the data set.

RETRY

Contains the number of I/O requests that had to be retried.

If you specify the SERVICE operand on the DISPLAY command, CA-L-Serv displays average service times (in milliseconds) in message LDM0550I.

Action:

No action required. These messages are informational.

LDM0552I

File server buffer pools -

LDM0553I Pool   Size   Count   BFRFND   BUFRDS   UIW   NUIW
LDM0554I nn       nn     nn        nn      nn     nn     nn

Reason:

In response to the DISPLAY BUFFER command, these messages display information about LSR buffer pools, as follows:

Pool

Contains the number assigned to a buffer pool.

Size

Contains the size (in bytes) of one set of buffers in the pool.

Count

Contains the number of buffers of a given size contained in the pool.

BFRFND

Contains the number of read requests that could be satisfied without an I/O operation because VSAM found the data in a buffer.

BUFRDS

Contains the number of times VSAM had to bring data into a buffer.

UIW

Contains the number of user-initiated write (PUT) requests.

NUIW

Contains the number of write requests initiated by VSAM buffer management. These are write operations that VSAM was forced to do because no buffers were available for reading the contents of a control interval.

Refer to the IBM manual Using Data Sets relevant to your level of z/OS for additional information on keywords BFRFND, BUFRDS, UIW, and NUIW as well as the interpretation of the figures listed under these headings.

Action:

No action required. These messages are informational.

LDM0555I

File server systems -

LDM0556I System   Type   Sends   Receives   Resp   Split
LDM0557I sysname  type     nn        nn     nn     nn

Reason:

These messages display information about all systems where the file server is running:

System

Contains the system name.

Type

Contains the type of server. Possible values are LOCAL, REMOTE, and HOST.

Sends

Contains the number of send requests issued by this server.

Receives

Contains the number of receive requests issued by this server.

Resp

Contains the average response time (in milliseconds) per receive request.

Split

Contains the number of times CA-L-Serv split large records to get them to fit in a data buffer.

Action:

No action required. These messages are informational.

LDM0558I

No external systems defined

Reason:

There are currently no other file servers active in the complex.

Action:

No action required. This message is informational.

LDM0559I

MAXDORM=nn

Reason:

The maximum default interval between deferred writes is nn seconds. See also message LDM0526I and refer to the Administration Guide and Reference Guide for additional information on the MAXDORM keyword.

Action:

No action required. These messages are informational.

LDM0560I

options

Reason:

An all-purpose message that displays information about the file server in response to commands such as DISPLAY ALL and DISPLAY DATABASE.

Action:

No action required. This message is informational.

LDM0562I

No managed ddnames

Reason:

There are no data sets currently under the control of the file server. This informational message is typical of a remote file server.

Action:

No action required. This message is informational.

LDM0563E

xx command is not supported on remote system

Reason:

The operator issued a command that is only supported on CA-L-Serv regions that run a local or a host file server. Examples of such commands are the ADDFILE and ADDPOOL commands, which cannot be issued against remote systems.

Action:

Review CA-L-Serv's logs to locate the command that caused the message to be displayed. Determine why the command was issued against a remote system.

LDM0570I

Clean-up for terminated session - ASCB=xx TCB=yy FLG/ASID=zz user=userid

Reason:

This messages indicates that the client executing in the referenced address-space (ASCB=xx, TCB=yy, FCG/ASID=zz) has terminated without ending this session with CA-L-Serv.

Action:

No action required. This message is informational.

LDM0571E

filename is managed by another CA-L-Serv - ADDFILE cancelled

Reason:

An attempt was made to place data set filename under CA-L-Serv's control, but the attempt failed because the data set was already under the control of another CA-L-Serv.

Note: This message may also be displayed because the data set is under the control of a client application such as CA Endevor Software Change Manager.

Action:

Review the system logs to determine why the data set is under the control of another CA-L-Serv or has been allocated by CA Endevor Software Change Manager users. This may occur after CA-L-Serv was shut down and restarted. Depending on the operational circumstances, you may need to terminate all jobs and users holding ENQ's with a major name of LSERVDSN before you can successfully place the data set under CA-L-Serv's control. When a number of data sets are involved, it may be preferable to terminate all jobs and users and restart CA-L-Serv than attempting to address each data set individually.

LDM0572I

No managed ddnames

Reason:

There are no data sets currently under the control of the file server. This informational message is also issued in response to a DISPLAY DATABASE command on a remote file server.

Action:

No action required. This message is informational.

LDM0573I

filename is not a managed ddname

Reason:

A file management command, such as OPENFILE or CLOSEFILE, specified file ddname but the file is not currently under CA-L-Serv's management.

Action:

Use the DISPLAY DATA command to list all data sets currently managed by CA-L-Serv. Determine why ddname filename is not currently under CA-L-Serv's management.

LDM0600I

Scheduler task is now attached

Reason:

The CA-L-Serv kernel has successfully activated the scheduler component of CA Bundl. For more information on the scheduler, refer to the appropriate CA Bundl documentation.

Action:

No action required. This message is informational.

LDM0601I

Scheduler task is now detached

Reason:

The scheduler component of CA Bundl has terminated. For more information on the scheduler component, refer to the appropriate CA Bundl documentation.

Action:

No action required. This message is informational.

LDM0602I

Scheduled events -

LDM0603I  Name   Status   Date   Time
LDM0604I  name   status   date   time

Reason:

These messages display information about scheduled events. For each event (identified by name), the current status is shown as follows:

The date and time variables indicate the next time that the event is scheduled to take place.

Note: For information on the scheduler, refer to the appropriate CA Bundl documentation.

Action:

No action required. This message is informational.

LDM0605E

Unknown schedule database ddname

Reason:

CA-L-Serv is not managing the schedule database you specified. For additional information on the scheduler, refer to the appropriate CA Bundl documentation.

Action:

Check the ddname that you specified on the ATTACH command. If it is misspelled, reissue the command. If the ddname is correct, issue an ADDFILE command for the ddname.

LDM0606E

Attach of module xxxx failed: RC=code

Reason:

An installation error or a short-on-storage condition may have occurred.

Action:

Look for a z/OS IEAxxxxx or IEFxxxxx message or a dump, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0607E

Processing of member by module failed: RC=code

Reason:

This member is not located in the data set pointed to by the //JCLLIB DD statement. The member name may have been misspelled on the CA Bundl SCH Detail Screen.

Action:

Check the spelling of the member name on the CA Bundl screen. If it is correct, check that the member is contained in the CA Bundl CNTL library.

LDM0608E

Processing of member by module cancelled

Reason:

The processing of member member was cancelled by the indicated module.

Action:

For more information on the scheduler component, refer to the appropriate CA Bundl documentation.

LDM0609E

Scheduler I/O error

Reason:

An I/O error occurred in the scheduler component of CA Bundl.

Action:

Take the appropriate action:

LDM0610I

Scheduler reload is complete

Reason:

For information on the scheduler, refer to the appropriate CA Bundl documentation.

Action:

No action required. This message is informational.

LDM0611I

No defined scheduler events

Reason:

No scheduler events are currently defined to the scheduler component of CA Bundl.

Action:

No action required. This message is informational.

LDM0612E

Start request failed - unknown event named on OPTIONS command

Reason:

The OPTIONS command specified an unknown event.

Action:

For additional information, refer to the appropriate CA Bundl documentation.

LDM0650E

Host system (sysname) already active

Reason:

A host file server is already active on system sysname.

Action:

Either attach the file server on the local system as a remote file server or detach the current host file server, then attach the local file server as the host.

LDM0651E

CommServer initialization failed RC=(xx,yy)

Reason:

The file server failed to initialize a session with the communications server. The file server will terminate.

Action:

Use the values specified for xx and yy to determine the cause of the error and the corresponding response.

If xx is 0 or 4, yy is one of the following:

If xx is anything except 0 or 4, ignore yy and look up the value for xx as follows:

LDM0652E

CommServer not active - retry scheduled

Reason:

This message is issued at one-minute intervals until the communications server has initialized.

Action:

Start the communications server on the local system. If you experience problems activating the communications server, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0653E

No host system active - retry scheduled

Reason:

A remote file server is attempting to establish communication with the host file server but the host file server is not active. The attempt will be retried at one-minute intervals until successful.

Action:

Attach the host file server. If the system that usually runs the host file server is experiencing problems, you can detach the remote file server and attach it as the host.

LDM0654E

CommServer query failed RC=(xx,yy) - active systems cannot be determined

Reason:

A remote file server attempted to locate the HOST system but the attempt was unsuccessful.

Action:

Use the values of xx and yy to determine the cause of the error and the corresponding response.

If xx is 0, yy is one of the following:

If xx is anything except 0 or 4, ignore yy and look up the value for xx as follows:

LDM0655I

CommServer session terminated - reinitialization scheduled

Reason:

The communications server has terminated the local file server's session. This message is informational.

Action:

No action is required.

LDM0656I

CommServer terminated - reinitialization scheduled

Reason:

The communications server on the local system has terminated.

Action:

No action required. This message is informational.

LDM0657I

CommServer session established as ssname (HOST | RMT ) sysname

Reason:

The file server established a session with the communications server identified by ssname. This file server is a host server (if HOST is shown) or a remote server (if RMT is shown).

Action:

No action required. This is an informational message.

LDM0658I

CommServer session established with ssname ( HOST | RMT ) sysname

Reason:

An external system (sysname) joined the configuration. The file server on that system is the host server (if HOST is shown) or a remote server (if RMT is shown). The communications server being used is further identified by ssname.

Action:

No action required. This is an informational message.

LDM0659I

CommServer session established with ssname ( HOST | RMT ) sysname ended

Reason:

An external system (sysname) left the configuration. The file server on that system is the host server (if HOST is shown) or a remote server (if RMT is shown). The communications server being used is identified by ssname.

Action:

If that system was a host system, other systems will not be able to access files until it is restarted or you designate a new host system.

LDM0660E

CommServer receive for sysname failed - RC=(xx,yy)

Reason:

The local communications server attempted to receive data from one of its partners but the receive failed.

Action:

Use the values of xx and yy to determine the cause of the error. If xx is 0, yy is one of the following:

If xx is anything except 0 or 4, ignore yy and look up the value for xx as follows:

LDM0661L

CommServer transmission error from sysname (invalid length) - A=(address)

Reason:

Accumulated length of the transmission is not valid. The communications server abends the request.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0662E

CommServer send to system failed - RC=(rc1,rc2) A=address

Reason:

The local communications server attempted to send data to one of its partners but the send failed.

Action:

Try to determine the cause of the error by looking at xx and yy. If xx is 0, yy is one of the following.

If xx is anything except 0 or 4, ignore yy and look up the value for xx as follows:

LDM0663L

CommServer transmission error from system (invalid code) - A=(address)

Reason:

The local communications server received invalid data from the communications server executing on system system.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0700I

CA-L-Serv message log - date=date - system=system

Reason:

This is the first message in CA-L-Serv's message log. It displays the date and the system's sysid.

Action:

No action required. This message is informational.

LDM0701L

MLWTO delivery error. Return code = code

Reason:

A multiple line WTO failed with return code = code.

Action:

Refer to the appropriate IBM manual for a list of possible return codes for multiple line WTOs.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0702L

Message number xxxx not found in dictionary

Reason:

CA-L-Serv did not find the message identified by xxxx in any of its message tables.

Action:

Verify that the corresponding message table is allocated to CA-L-Serv and that the message was not accidentally removed from the message table. If you have recently upgraded CA-L-Serv or any client applications, verify that the corresponding message tables were also upgraded.

LDM0710L

Abend code at offset in name during log processing

Reason:

The log server component of CA-L-Serv abended. CA-L-Serv tries to recover from the abend.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0711E

Open error on file ddname for logname

Reason:

An error occurred when CA-L-Serv's log server attempted to open log logname.

Action:

Review CA-L-Serv' logs and the system log for IECxxxx messages explaining the cause of the error.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0712E

I/O error on file ddname for logname

Reason:

An I/O error occurred when CA-L-Serv's log server attempted to write to log logname.

Action:

Review CA-L-Serv's logs and the system log for IECxxxx messages explaining the cause of the error.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0713E

Logging for logname disabled

Reason:

Log logname has been disabled. Logging for this log will be directed to the default log.

Action:

Review CA-L-Serv's logs and the system log for additional LDMxxxx and IECxxxx messages that may explain the cause of the error.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0714I

logname is defined

Reason:

An ADDLOG command was successfully processed.

Action:

No action required. This is an informational message.

LDM0715E

logname is not defined - check spelling on command

Reason:

An ADDLOG command failed because the data set whose dsname was specified on the command is not cataloged.

Action:

Review CA-L-Serv's message log and reissue the command with the correct dsname.

LDM0716I

Now recording on file xxxx for logname

Reason:

The entries for log logname will now be written to SYSOUT CLASS or data set xxxx.

Action:

No action required. This is an informational message.

LDM0717I

Logging for logname terminated. Active file was ddname

Reason:

Logging to log logname has terminated. This normally follows a successfully processed CLOSELOG command.

Action:

No action required. This is an informational message.

LDM0718E

LRECL for file ddname of logname not compatible with previous log file

Reason:

The logical record length (LRECL) of the new log file is not the same as the LRECL of the old log file. This occurs after a log switch when the logging for logname was directed to a wrap-around series of data sets through the DDNAMES or DSNAMES options of the ADDLOG command.

Action:

Define files so that they have the same LRECL value.

LDM0719I

logname has been deleted

Reason:

A REMOVELOG command issued against logname was successfully processed.

Action:

No action required. This is an informational message.

LDM0720E

Allocation failure on logname for file ddname. Allocation return codes: xx-yyyy-zzzz

Reason:

CA-L-Serv encountered a dynamic allocation error when it attempted to allocate file ddname for log logname. CA-L-Serv provides a return code in the format xx-yyyy-zzzz, where xx is the R15 return code from SVC 99; yyyy is the reason code; and zzzz is the error reason code.

Action:

Refer to the appropriate IBM publication to determine the meaning of the codes. If this is not an operational error, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0721E

File ddname dropped from file list

Reason:

CA-L-Serv could not allocate or access the indicated log file. CA-L-Serv drops the file from the list of files for that log. If other files can be accessed successfully, CA-L-Serv continues log processing with a reduced file list.

Action:

To work from a full file list, correct the problem. Then use the REMOVELOG command to delete the log definition, followed by the ADDLOG command to redefine the log file.

LDM0722E

logname unavailable. No accessible log files for this log.

Reason:

Log logname was allocated to a group of cataloged data sets through the DDNAME or DSNAMES options of the ADDLOG command. None of the data sets are accessible. This message follows messages LDM0721E and LDM0724E. This message is also issued when the ADDLOG command specifies a log name that is already allocated.

Action:

Review CA-L-Serv's logs to determine the cause of the problem. Use the REMOVELOG command to delete the log definition, followed by the ADDLOG command to redefine the log file.

LDM0723E

SYSOUT class specification for logname is not allowed under Z/OS Master Scheduler

Reason:

CA-L-Serv must run under the Job Entry Subsystem in order to direct logging to SYSOUT data sets.

Action:

Redirect the log to cataloged data sets, or run CA-L-Serv under JES. Note, that when the procname is the same as the subsystem name, the z/OS START command causes the target started task to run under the z/OS Master Scheduler rather than the Job Entry Subsystem. Under these circumstances, it is necessary to direct CA-L-Serv to execute under the Job Entry Subsystem by using the SUB=JESx keyword of the z/OS START command.

LDM0724E

File ddname of logname could not be located in system catalog

Reason:

Dynamic allocation failed for file ddname because the corresponding data set could not be located.

Action:

Verify the spelling of the data set name on the ADDLOG command.

LDM0725I

logname is now available

Reason:

The CA-L-Serv log logname is now available. This message indicates that the log server has successfully opened the corresponding file or that an OPENLOG command was successfully processed.

Action:

No action required. This is an informational message.

LDM0726E

DDname xxxx of logname is not defined in CA-L-Serv start-up proc

Reason:

An ADDLOG command was issued with the DDNAMES option. There is no corresponding DD statement for xxxx in the CA-L-Serv start-up procedure.

Action:

Add the DD statement to the CA-L-Serv procedure and recycle CA-L-Serv or issue the ADDLOG command from the console specifying the DSNAMES keyword if CA-L-Serv cannot conveniently be restarted.

LDM0727E

Logid id is not available

Reason:

The displayed log ID is already in use by a log automatically defined by CA-L-Serv.

Action:

Specify a different log id in the ADDLOG command for this log.

LDM0728E

Logid id cannot be deleted

Reason:

The displayed log ID cannot be the target of a REMOVELOG command because it defines a log that is vital to CA-L-Serv operation.

Action:

You may use the PRINTLOG command to spin off the log to a SYSOUT class where you will be able to print or purge it.

LDM0729E

JES unavailable. File filename sent to SYSLOG.

Reason:

A log directed to a SYSOUT class could not be opened because JES is not available. The messages destined for the log will be written to the system log.

Action:

Determine why the Job Entry Subsystem is not available. Review the CA-L-Serv's logs and the system log for other LDMxxxx messages or IBM messages that could help determine the cause of the problem.

LDM0730E

Positioning error for file ddname of logname

Reason:

The log server encountered an error while attempting to reposition against log logname.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0731L

optcode failure, return code was code

Reason:

CA-L-Serv was performing operation optcode when it encountered an error while writing messages to a log file.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0732E

File is not DASD. Log positioned to start of first file.

Reason:

The log server encountered an error while attempting to reposition against a log data set

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0733E

Invalid file or file combination for log

Reason:

An ADDLOG command was issued specifying two or more DDNAMES. CA-L-Serv found that at least one of the ddnames is allocated to a SYSOUT class in CA-L-Serv's start-up procedure.

Action:

Issue the ADDLOG in one of the following ways:

LDM0734E

File is not physical sequential, file ignored in file list

Reason:

CA-L-Serv found a data set with an unsupported data set organization in a group of files allocated to a log.

Action:

To work from a full file list, correct the problem by allocating a data set with the appropriate data set organization. Then use the REMOVELOG command to delete the log definition, followed by the ADDLOG command to redefine the log file.

LDM0735E

Unable to open the file, file ignored in file list

Reason:

CA-L-Serv was unable to open a data set in a file list.

Action:

To work from a full file list, review CA-L-Serv's logs and the system log looking for IECxxxx messages, which will help determine the reason why the OPEN for the data set failed.

If unable to determine the cause of the failure, collect the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0736E

File not on volume, file ignored in file list

Reason:

CA-L-Serv could not locate a log file on the volume identified by the JCL.

Action:

Determine why the log file does not reside on the specified volume. Use the ADDLOG command to specify a new log data set.

LDM0737I

WRITELOG complete

Reason:

The WRITELOG command was processed successfully.

Action:

No action required. This is an informational message.

LDM0738E

SWITCH operation inappropriate for logname

Reason:

You issued a SWITCHLOG command for the indicated logname, but one of the following problems occurred:

Action:

Use the DISPLAY LOGS command to verify that multiple data sets are defined for the log and that none of them is allocated to a SYSOUT class.

LDM0739I

SWITCH complete

Reason:

The SWITCHLOG command was processed successfully.

Action:

No action required. This is an informational message.

LDM0740E

Invalid LOGID

Reason:

The logid specified on the command is invalid.

Action:

Refer to the CA-L-Serv Command Reference for additional information concerning syntax and usage rules relative to log names.

LDM0741L

CA-L-Serv log task disabled. MSGLOG now routed to SYSLOG.

Reason:

CA-L-Serv's log server task is disabled. All messaging will now use WTO's and will be directed to the system log.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0742E

Log logname not directed to SYSOUT file

Reason:

You issued a PRINTLOG command for a log file that was not defined as a SYSOUT class.

Action:

Check the spelling of the log name on the PRINTLOG command. If the log name is spelled correctly, use the ADDLOG command to redefine the log file as a SYSOUT class.

LDM0743E

Log logname is not active

Reason:

A PRINTLOG command was issued against log logname but the log is not currently active.

Action:

Review CA‑L-Serv's logs to determine why the log is currently inactive.

LDM0744I

Log logname has been spun off

Reason:

The PRINTLOG command was processed successfully. Log logname will now be directed to a new sysout data set. The old sysout data set can now be purged or printed.

Action:

No action required. This is an informational message.

LDM0745E

No CA-L-Serv log available, forced to SYSLOG

Reason:

No logs are available to CA-L-Serv. The message will be written to the system log through WTOs.

Action:

Review the CA-L-Serv's job log and the system log to determine why no logs are available.

Collect the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0750I

CA-L-Serv log statistics -

LDM0751I  Log name   Status   Count   Time   File name
LDM0752I  log name   status      nn   time    filename

Reason:

These messages display information about CA-L-Serv's logs, as follows:

Log name

Contains the name of the log. The name TRACE refers to the trace log; the name MSGLOG refers to the message log. All other names refer to data base change logs or auxiliary message logs.

Status

Contains the current status of the log. Possible values include:

Count

Contains the number of records in the log file.

Time

Contains the time that the last record was written to the log file.

File name

Contains the data set names or sysout class assigned to the log.

Action:

No action required. These messages are informational.

LDM0755I

No logs are defined

Reason:

You issued a DISPLAY LOGS or DISPLAY ALL command but there are no logs currently defined to CA-L-Serv.

Action:

No action is required. This message is informational.

LDM0801E

Statement not recognized

Reason:

The LDMAMS utility encountered an invalid SYSIN statement.

Action:

Correct the SYSIN statement and resubmit the job.

LDM0802E

Invalid operand xxxx

Reason:

The operand specified on the LDMAMS statement is invalid.

Action:

Refer to the full description of the LDMAMS statement.

LDM0803E

Expected right parenthesis after ddname or key

Reason:

Unmatched parentheses in an LDMAMS statement.

Action:

Refer to information on the statement's syntax.

LDM0804E

CA-L-Serv not active - RC=code

Reason:

The LDMAMS utility could not establish a session with CA-L-Serv.

Action:

Verify that CA-L-Serv is active and that the job running the LDMAMS utility indicates the correct subsystem name (through the SSN$xxxx DD DUMMY statement).

If this is not an operational error, call CA Support.

LDM0805E

Infile or outfile must be allocated - add DD statement to JCL

Reason:

The LDMAMS utility needs the data set specified in the SYSIN statement with the infile or outfile keyword to be allocated in the job's JCL.

Action:

Add the DD statement to the JCL and resubmit the job.

LDM0806E

Unable to open filename

Reason:

The LDMAMS utility encountered an error when it tried to open the input or output file.

Action:

Review the job's log looking for a z/OS IEC141 message that explains the error more fully.

LDM0807E

Unable to lock infile - RC=code

Reason:

CA-L-Serv could not obtain exclusive control of the input file. A file server problem occurred.

Action:

The file may currently be accessed by online users or another LDMAMS job. You may have to reschedule the LDMAMS job at a later time.

LDM0808I

outfile has been reset

Reason:

The LDMAMS utility has successfully reset the contents of data set outfile.

Action:

No action required. This is an informational message.

LDM0809I

Unable to retrieve text for message xxxx, CA-L-Serv unavailable, RC=code

Reason:

CA-L-Serv could not find text for message xxxx in its message table. The message is discarded.

Action:

Verify that the corresponding message table is allocated to CA-L-Serv and that the message was not accidentally removed from the message table. If you have recently upgraded CA-L-Serv, verify that the CA-L-Serv message table was also upgraded.

LDM0810I

nn records copied from infile to outfile - REPRO operation complete

Reason:

The LDMAMS utility has successfully performed a REPRO operation from VSAM data set infile to sequential data set outfile copying nn records.

Action:

No action required. This is an informational message.

LDM0811E

Statement skipped due to previous error

Reason:

The LDMAMS utility detected an error in a previous SYSIN statement. The ensuing statements are ignored.

Action:

Review the LDMAMS job log and SYSPRINT for possible causes. Depending on the error, review the CA-L-Serv's logs for other messages.

LDM0812I

nn records copied from infile to outfile: nn added, nn replaced, nn skipped

Reason:

The LDMAMS utility performed a REPRO from sequential data set infile to VSAM data set outfile with the REPLACE option specified. The message displays statistics about the result of the process.

Action:

No action required. This is an informational message.

LDM0813E

Invalid key specification: quote or parenthesis at end of key is missing

Reason:

The LDMAMS utility found a syntax error in a REPRO statement specifying the FROMKEY or TOKEY keywords.

Action:

Refer to the full description of LDMAMS statements.

LDM0814E

Unable to reset ddname - RC=code

Reason:

An error occurred when CA-L-Serv tried to delete the contents of a VSAM file. The file may be in use by another task or user, or it may not be managed by CA-L-Serv.

Action:

Verify that the file is not in use by another task or user, that it is managed by CA-L-Serv and that the cluster was defined with the REUSE attribute.

LDM0815E

GET failed for ddname - RC=code

Reason:

CA-L-Serv encountered an error when it tried to copy a record from a VSAM file to a sequential file. The message may occur if someone issues a SHUTDOWN or CLOSEFILE command before the LDMAMS utility completes its operation.

Action:

Review CA-L-Serv's logs for additional messages issued at the same time. Refer to the list of CA-L-Serv's return codes at the beginning of this manual.

If this is not an operational problem, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0816E

PUT failed for ddname - RC=code

Reason:

An error occurred when CA-L-Serv tried to write a record from a sequential file to a VSAM file. The message may occur if someone issues a SHUTDOWN or CLOSEFILE command before the LDMAMS utility completes its operation.

Action:

Review CA-L-Serv's logs for additional messages issued at the same time. Refer to the list of CA-L-Serv's return codes at the beginning of this manual.

If this is not an operational problem, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0817E

RECFM=VBS not supported for ddname - FB and VB supported

Reason:

The LDMAMS utility does not support spanned record format for sequential data sets.

Action:

Reallocate the data set ddname with a record format of FB or VB and rerun the job.

LDM0818E

Unable to open ddname - RC=code

Reason:

CA-L-Serv encountered an error when it tried to open the input or output file.

Action:

Use the DISPLAY DATABASE to verify that the data set is currently under CA-L-Serv's control.

Review CA-L-Serv's logs or the system log for IECxxxx messages, which may explain the cause of the problem. Refer to the list of CA-L-Serv's return codes at the beginning of this manual.

If this is not an operational problem, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0819E

Insufficient security access to ddname

Reason:

An external security problem occurred when CA-L-Serv tried to access ddname.

Action:

Address the security problem and resubmit the job.

LDM0820E

INFILE and/or GROUP keywords are required on ARCHIVE statement

Reason:

The LDMAMS utility detected that neither the INFILE nor GROUP keyword was specified on an ARCHIVE statement.

Action:

Correct the ARCHIVE statement.

LDM0821E

Unknown file group xxxx - probably not defined yet

Reason:

The LDMAMS utility detected that file group xxxx is not currently defined to CA-L-Serv.

Action:

Define the file group to CA-L-Serv and resubmit the job.

LDM0822E

Cannot archive file xx - not part of file group yy

Reason:

INFILE and GROUP were specified on an ARCHIVE statement but file xx is not part of group yy.

Action:

Use the DISPLAY DATABASE command to display the group and specify one the files belonging to the group.

LDM0823E

No files in file group xx need to be archived

Reason:

A file in a file group must be full to be eligible for archiving. The LDMAMS utility did not find any files in file group xx that were full.

Action:

Review CA-L-Serv's logs to determine if any of the files on the file group were eligible for archiving. If this is not an operational error, call CA Support.

LDM0824I

nnn records copied from file to ddname

Reason:

An archive or repro operation copied nnn records from file to ddname.

Action:

No action required. This is an informational message.

LDM0825I

ARCHIVE operation is completed

Reason:

The LDMAMS utility successfully completed the ARCHIVE operation.

Action:

No action required. This is an informational message.

LDM0826I

File xxxx is empty - does not need to be archived

Reason:

The LDMAMS utility detected that target data set xxxx is empty and that no archiving is necessary.

Action:

No action required. This is an informational message.

LDM0827E

A nnn byte record, read in from file xxxx, exceeds the nnn byte maximum allowed for file yyyy

Reason:

A record's logical record length exceeds the OUTPUT file's maximum LRECL value.

Action:

Increase the OUTPUT file's maximum LRECL value to accommodate the largest LRECL value for any record in the source file.

LDM0828E

CA-L-Serv is not active

Reason:

The LDMAMS job was unable to establish communication with CA-L-Serv.

Action:

Verify that CA-L-Serv is active and that the //SSN$xxxx DD DUMMY statement in the LDMAMS JCL specifies the correct subsystem name.

LDM0829I

CommServer function returned RC=code Reason=code

Reason:

This message is issued when using the LDMAMS utility to verify the successful installation of the communications server. Refer to the CA-L-Serv section of the Installation Guide for a complete description of the communications server's installation verification procedure.

Action:

When the communications server IVP runs successfully, you will receive a return-code and a reason code of 0. Otherwise, Refer to the list of return and reason codes, correct the problem and rerun the communications server's IVP.

LDM0830I

Active CommServer applications:

Reason:

When running the communications server's installation verification procedure, these messages display the IDs of the applications you created to test communication routes.

Action:

No action required. These messages are informational.

LDM0831I

application qualifier

Reason:

When running the communications server's installation verification procedure, these messages display the IDs of the applications you created to test communication routes.

Action:

No action required. These messages are informational.

LDM0832I

Receive complete: APPL=application QUAL=qualifier Length=nn RC=code

Reason:

When running the communications server's IVP, this message displays basic information about the data transfer.

Action:

Refer to the Installation Guide for additional information concerning the communications server IVP.

LDM0833I

APPL=application QUAL=qualifier not active - WAIT continues

Reason:

When running the communications server's IVP, this message indicates that the receiving application is unable to see the sending partner.

Action:

Refer to the Installation Guide for additional information concerning the communications server IVP.

LDM0834I

APPL=application QUAL=qualifier not active - WAIT cancelled

Reason:

The receiving job in the communications server IVP has exceeded the time limit specified with the LIMIT parameter of the WAIT statement and did not receive any data.

Action:

Refer to the Installation Guide for additional information concerning the communications server's installation verification procedure.

LDM0850E

OPEN error for ACB(applid) ACBERFLG=code

Reason:

When running the communications server's IVP using VTAM communication, this indicates a problem with the SYS1.VTAMLST definitions necessary for two copies of CA-L-Serv to be able to communicate.

Action:

Make sure CA-L-Serv's application ID (specified on the ACBNAME operand for the ATTACH command) matches CA-L-Serv's VTAM application ID in your SYS1.VTAMLST data set.

If they do match, collect the appropriate diagnostic information (VTAM definitions and DISPLAYs, CA-L-Serv command member) and call CA Support.

LDM0851E

ACB applid is already active

Reason:

CA-L-Serv issued an OPEN against VTAM ACB applid but the ACB was already open.

Action:

Change CA-L-Serv's application ID on the ATTACH command's ACBNAME operand and in your SYS1.VTAMLST data set to point to an ACB not currently open to another task on the system.

LDM0852I

VTAM cleanup in progress for ACB applid, will retry

Reason:

The communications server will try to reestablish its VTAM session after VTAM performs cleanup processing for CA-L-Serv.

Action:

Look for VTAM messages that tell you whether the session was reestablished.

LDM0853I

Please vary applid inactive, or DETACH CommServer

Reason:

The communications server is in a suspended state because its VTAM application ID was not active when you started it.

Action:

Take one of these actions:

LDM0854I

Route established between source and target

Reason:

The communication route between source and target has been successfully established.

Action:

No action required. This is an informational message.

LDM0855E

BUFFSIZE incompatible; correct and restart

Reason:

The communication server detected a mismatch in the RECBUFFSIZE definitions.

Action:

Make the values for the ATTACH command's RECBUFFSIZE operand match on all systems and restart communications servers.

LDM0856I

Invalid logmode used from source to target: correct and restart

Reason:

An invalid BIND was passed between systems.

Action:

Check your VTAM definitions for CA-L-Serv. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0857E

OPEN error for ACB(applid ) R15=code ACBERFLG=xxxx

Reason:

A VTAM error occurred. An application ID, return code, and control block field's contents (xxxx) are shown.

Action:

Consult your VTAM manuals for an explanation of the codes.

If this is not an operational problem, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0858E

REQSESS failed; RTNCD=code, FDB2=code, SENSE=code

Reason:

A VTAM error occurred.

Action:

Consult your VTAM manuals for an explanation of the codes.

If this is not an operational problem, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM0860I

Unable to establish a route between source and target

Reason:

The communications server is not active on the target system yet.

Action:

Check that CA-L-Serv and the communications server are active on the target system.

LDM0861I

No activate was issued for resource

Reason:

The route is currently inactive.

Action:

Use the ACTIVATE resource command to activate the route on the local system.

LDM0862I

VTAM version xx, release yy.yy

Reason:

These messages identify the exact level of VTAM running on your systems. They are among the first messages written to the communications server log.

Action:

No action required. These messages are informational.

LDM0863I

VTAM component ID xxxx-xxxxx-xxx

Reason:

These messages identify the exact level of VTAM running on your systems. They are among the first messages written to the communications server log.

Action:

No action required. These messages are informational.

LDM0871I

LCMVTAM: CLSDST error: RC=code, FB=code, SENSE=code

Reason:

A VTAM macro abended. Refer to VTAM manuals for additional information concerning the return code, feedback code, and sense code.

Action:

You do not have to take an action unless you experience further problems.

LDM0872I

LCMVTAM: CLSDST or TERMSESS error: RC=code, FB=code, SENSE=code

Reason:

A VTAM macro abended. Refer to VTAM manuals for additional information concerning the return code, feedback code, and sense code.

Action:

You do not have to take an action unless you experience further problems.

LDM0873I

LCMVTAM: OPNSEC error: RC=code, FB=code, SENSE=code

Reason:

A VTAM macro abended. Refer to VTAM manuals for additional information concerning the return code, feedback code, and sense code.

Action:

You do not have to take an action unless you experience further problems.

LDM0874I

LCMVTAM: VTAM is not APPC-capable, using LU 0

Reason:

Your version of VTAM does not support LU 6.2 protocols.

Action:

Change the CONTYPE operand's value on the ATTACH commserver or ACTIVATE command from LU62 to LU 0.

LDM0875I

LU 6.2 Bind from source failed; this ACB(target ) is not APPC-capable

Reason:

The version of VTAM on the target system does not support LU 6.2 protocols.

Action:

Change the CONTYPE operand's value on the ATTACH commserver or ACTIVATE command from LU62 to LU 0 on both the source and the target systems.

LDM0880I

Activate of route xxx is complete

Reason:

This message is issued in response to a successful ACTIVATE command.

Action:

No action required. This is an informational message.

LDM0881E

route is already activated

Reason:

This message is issued in response to an ACTIVATE command: the activate failed because the route is already active.

Action:

Review CA-L-Serv's logs to determine why the route is already active.

LDM0882E

Cannot activate route xxx to local system

Reason:

The ACB specified on the ATTACH COMMSERVER command and the route specified on the ACTIVATE command are the same.

Action:

The ACB name specified on the ACTIVATE command must be different from the ACB name specified on the ATTACH COMMSERVER command.

LDM0883I

Deactivate of route xxx is complete

Reason:

This message indicates that route xxx has been deactivated.

Action:

No action required. This is an informational message.

LDM0884E

route is already deactivated

Reason:

This message is issued in response to a DEACTIVATE command: the command failed because the route is not active.

Action:

Review CA-L-Serv's logs to determine why the route is not active.

LDM0888I

Maximum number of users exceeded

Reason:

The maximum number of users of the communications server is exceeded.

Action:

Stop the communications server, and increase the value for the MAXSESSIONS operand on the server's ATTACH command.

LDM0889E

Route activation failed; activate source on system target

Reason:

The local system attempted to activate a route but the target system is not responding.

Action:

Activate a route from the target system to the source system.

LDM0900I

CommServer task is now active

Reason:

The communications server initialization has completed successfully.

Action:

No action required. This is an informational message.

LDM0901I

CommServer task is now inactive

Reason:

The communications server has terminated.

Action:

No action required. This is an informational message.

LDM0910I

CommServer Options-

LDM0010I 	ACBNAME=name
LDM0010I 	CONTYPE=protocol
LDM0010I 	HOLDBUF=nnn
LDM0010I 	LOGID=logname
LDM0010I 	RETRMAX=nnn
LDM0010I 	RETRY=nnnnn
LDM0010I 	SENDLIMIT=nnn
LDM0010I 	XCF=[YES|NO]

Reason:

These messages display operating values that you can change while the communications server is running:

ACBNAME

Displays the VTAM application ID for CA-L-Serv.

CONTYPE

Identifies the VTAM communications protocol that the server is using.

HOLDBUF

Displays the maximum number of transmission buffers per client.

LOGID

Displays the name of the auxiliary message log for the communications server.

RETRMAX

Displays the maximum number of attempts to reactivate an inactive VTAM route. The server retries indefinitely when 0 is shown.

RETRY

Sets the interval for attempts to reactivate an inactive VTAM route. The server will not try to reactivate the route when 0 is shown. The retry interval is measured in seconds.

SENDLIMIT

Displays the maximum number of pending send requests per client.

XCF

Indicates whether the XCF method of data transmission is active.

Action:

No action is required. These messages are informational.

LDM0911I

CommServer Initialization Parameters-

LDM0010I 	ACBNAME=applid
LDM0010I 	MAXSENDSIZE=nnn
LDM0010I 	MAXSESSIONS=nnn
LDM0010I 	RECBUFFSIZE=nnn
LDM0010I 	XCF=[YES|NO]

Reason:

These messages display operating values that you cannot change while the communications server is running:

ACBNAME

Displays the VTAM application ID for CA-L-Serv.

MAXSENDSIZE

Displays the maximum data size during transmission, in kilobytes.

MAXSESSIONS

Displays the maximum number of concurrent sessions with the server.

RECBUFFSIZE

Displays the size of the server's transmission buffers.

XCF

Indicates whether XCF was activated.

Action:

No action is required. These messages are informational.

LDM0912I

CommServer routes-

LDM0913I  Route   Status   Contype    Retry   RETRMAX
LDM0914I  route   status   protocol   nnnnn   nnn
LDM0917I  nodename

Reason:

These messages display information about communication routes:

Route

Contains the target system's ACB name for VTAM routes or the XCF system name for XCF routes.

Status

Is ACTIVE or INACTIVE.

Contype

Identifies the communications protocol that the server is using for this route. (For XCF routes, XCF is displayed. For VTAM routes, LU0 or LU6.2 is displayed.)

Retry

Sets the interval for attempts to reactivate this route if it becomes inactive. The server does not try to reactivate the route when 0 is shown. The retry interval is measured in seconds.

RETRMAX

Contains the maximum number of attempts to reactivate this route if it becomes inactive. The server retries indefinitely when 0 is shown.

nodename

Displays the internal node name for a client that is using the communications server.

Action:

No action is required. These messages are informational.

LDM0915I

No active routes

Reason:

One of these messages will follow LDM0912I if there were no active or inactive routes to display information about.

Action:

No action is required. These messages are informational.

LDM0916I

No inactive routes

Reason:

One of these messages will follow LDM0912I if there were no active or inactive routes to display information about.

Action:

No action is required. These messages are informational.

LDM0918I

CommServer Application Defaults

LDM0010I  DYNAMIC=value
LDM0010I  PRIORITY=value

Reason:

These messages display client application default values.

Action:

No action required. These messages are informational.

LDM0920I

CommServer applications-

LDM0921I  Application  Status   Pty   ---Sends---   --Receives-
LDM0922I  productid    status   x       x    y        x    y

Reason:

These messages display information about clients using the communications server:

Application

Contains the product ID for a client.

Status

Contains one of these values:

Pty

Contains the maximum priority for requests from the client.

H - High

N - Normal

L - Low

Sends

Contains the number of pending (x) and completed (y) send requests from this client.

Receives

Contains the number of pending (x) and completed (y) receive requests from this client.

Action:

No action is required. These messages are informational.

LDM0923I

No applications defined

Reason:

There are no clients currently in session with the communications server.

Action:

No action required. This message is informational.

LDM0935I

Retry limit (nn) exceeded for route - retry suspended

Reason:

The communications server tried nn times (the maximum number of times) to reactivate this route.

Action:

No action is required. This message is informational.

LDM1100I

(ACTIVATE/DEACTIVATE) command is not supported with ACB=NONE

Reason:

An ACTIVATE or DEACTIVATE command was issued for a VTAM route, but no ACB name was provided to enable VTAM when the communications server was started. ACTIVATE and DEACTIVATE commands are only valid for VTAM.

Action:

Refer to additional information concerning the communications server.

LDM1101E

Status change not supported for XCF route

Reason:

You cannot activate or deactivate an XCF route using these commands. ACTIVATE and DEACTIVATE commands are only valid for VTAM communication.

Action:

Refer to the description of the XCF component of the communications server.

LDM1102E

XCF communication is already active

Reason:

An attempt was made to initialize XCF communication but it is already active.

Action:

Review CA-L-Serv's logs to determine why the XCF component is already active.

LDM1103E

XCF support is not available on this level of MVS

Reason:

An attempt was made to start up the communications server using XCF, but XCF is not available on this system.

Action:

To implement XCF, you must be running MVS 4.0 at a minimum.

LDM1105E

XCF component is already active

Reason:

The XCF component of the communications server is already active.

Action:

Review CA-L-Serv's log and determine why the XCF component is already active.

LDM1106I

XCF communication is now active

Reason:

The XCF component of the communications server has initialized.

Action:

No action required. This is an informational message.

LDM1107I

XCF communication is now inactive

Reason:

The XCF component of the communications server has terminated.

Action:

No action required. This is an informational message.

LDM1110I

The communications server facilities are now active

Reason:

The communications server has initialized.

Action:

No action required. This is an informational message.

LDM1111I

The communications server facilities are now inactive

Reason:

The communications server has terminated.

Action:

No action required. This is an informational message.

LDM1112E

The communications server facilities are not active

Reason:

A command was directed towards the communications server but it is not currently active.

Action:

Review CA-L-Serv's logs to determine why the communications server is not active. If relevant use the ATTACH command to restart the communications server.

LDM1114E

XCF communication is not active

Reason:

A command was directed towards the XCF component of the communications server but it is not currently active.

Action:

Use the DISPLAY command or review CA-L-Serv's logs to determine the currently active options of the communications server. If the XCF component of the communications server needs to be activated you will have to detach the communications server and reattach it specifying the XCF=YES option.

LDM1115E

Communications server subtask loadmodule terminated abnormally - TCBCMP=completioncode

Reason:

A subtask of the communications server ended abnormally with a completion code of completioncode.

Action:

Stop the communications server with the DETACH command and restart it with the ATTACH command to revive the communications server. Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1116E

XCF initialization failed

Reason:

The communications server is terminating because the XCF component did not initialize successfully.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1118E

XCF member registration failed with return code=code, reason code=code

Reason:

The XCF component did not initialize successfully.

Action:

The nature of the problem can be determined by looking up the listed return and reason codes in IBM's z/OS MVS Programming: Sysplex Services Reference Guide under the IXCJOIN macro.

If this is not caused by an operational problem in your environment, retain the appropriate diagnostic information and call CA Support.

LDM1119E

XCF member de-registration failed with return code=code, reason code=code

Reason:

The XCF component did not terminate successfully.

Action:

The nature of the problem can be determined by looking up the listed return and reason codes in IBM's Authorized Assembler Reference Guide under the IXCLEAVE macro.

If this is not an operational problem in your environment, retain the appropriate diagnostic information and call CA Support.

LDM1120E

Unable to obtain XCF sysplex information; query failed with return code=code, reason code=code

Reason:

The XCF component did not initialize successfully.

Action:

The nature of the problem can be determined by looking up the listed return and reason codes in IBM's z/OS MVS Programming: Sysplex Services Reference Guide under the IXCQUERY macro.

If this is not an operational problem in your environment, retain the appropriate diagnostic information and call CA Support.

LDM1121E

Unable to obtain XCF group information; query failed with return code=code, reason code=code

Reason:

The XCF component did not initialize successfully.

Action:

The nature of the problem can be determined by looking up the listed return and reason codes in IBM's Authorized Assembler Reference Guide under the IXCQUERY macro.

If this is not an operational problem in your environment, retain the appropriate diagnostic information and call CA Support.

LDM1122E

VTAM route active to sysplex system sysname; XCF communication will not be used

Reason:

An attempt was made to activate an XCF communication route to the named system, but a VTAM route to that system was already active.

Action:

If you decide to use XCF communications between the two systems, attach the communications server specifying XCF=YES and delete the ACTIVATE statements from the start-up command members.

LDM1128E

XCF event processing failed with return code=code, reason code=code

Reason:

An XCF data transmission failure occurred due to an internal XCF problem. The data transmission may have been lost.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1129E

XCF event clean up failed with return code=code, reason code=code

Reason:

An XCF end-event procedure failed due to an internal XCF problem. The data transmission was successful.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1130E

Unexpected termination of communications server mode subtask

Reason:

The communications server was forced to end the specified mode of operation, but it did not shut down completely.

Action:

Stop the communications server with the DETACH command and restart it with the ATTACH command.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1131E

XCF message exit failed with abend completion code=code, reason code=code

Reason:

An abend occurred during XCF processing. If the XCF component does not recover, message LDM1135E is also issued. The data transmission may have been lost.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1132E

XCF group exit failed with abend completion code=code, reason code=code

Reason:

An abend occurred during XCF processing. If the XCF component does not recover, message LDM1135E is also issued. Status information about data transmissions may have been lost.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1133E

XCF member subtask failed with abend completion code=code, reason code=code

Reason:

An abend occurred during XCF processing. If the XCF component does not recover, message LDM1135E is also issued.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1134E

XCF processing failed with abend completion code=code, reason code=code

Reason:

An abend occurred during XCF processing. If the XCF component does not recover, message LDM1135E is also issued.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1135E

XCF terminated abnormally

Reason:

XCF terminated due to an unrecoverable abend.

Action:

Review CA-L-Serv's logs for prior messages identifying the reason for the abend.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1136E

Invalid message data received from system sysname

Reason:

A message was split into segments for transmission by the named system, but the segments were not received in the proper order.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1137E

Incomplete message data received from system sysname

Reason:

A message from system sysname was split into segments, but part of the message was lost in the transmission.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1138E

XCF send attempt to sysname failed with return code=code, reason code=code

Reason:

XCF could not send data to the named system due to an internal XCF problem.

Action:

The nature of the problem can be determined by looking up the listed return and reason codes in IBM's z/OS MVS Programming: Sysplex Services Reference Guide under the IXCMSGO macro.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1139E

Invalid message acknowledgment received from system sysname

Reason:

An XCF message acknowledgment received from the named system does not match the information for the message being sent.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1140E

Acknowledgment received from system sysname, but no send in progress to that system

Reason:

An XCF message acknowledgment was received from the named system, but no message was sent to that system.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1141E

Unable to initialize XCF - RC=code

Reason:

The XCF component of the file server failed to initialize.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1500I

File ddname (dsname) is full

Reason:

A record was not written to this file because the file is full. The file server will switch to the next file in the group.

Action:

No action required. This message is informational.

LDM1501I

JCL in member xxxx submitted to archive file ddname

Reason:

The file server detected that a file in a file group is full and submitted a job to perform the archive.

Action:

No action required. This message is informational.

LDM1503E

Command rejected. Previous control command has not yet completed.

Reason:

Processing of a file management command has not completed and is preventing the command you issued from executing.

Action:

Review the CA-L-Serv's logs looking for previous error messages for possible abends of the file server. If no abend is found and CA-L-Serv did not take an SVC dump, take a console dump of the CA-L-Serv region including private storage and all system areas.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM1504E

Cannot switch files - no empty file found - still using current file

Reason:

The file server was unable to switch to a new file in the file group because there are no empty files available.

Action:

Review the output of recent archive jobs looking for errors. You may need to run a manual archive if the automatic archive failed.

LDM1505E

File ddname is not part of file group xx

Reason:

A SWITCHFILE command was issued but the ddname specified is not part of the file group.

Action:

Use the DISPLAY DATABASE command to list the files belonging to the file group.

Refer to the description of the SWITCHFILE and DISPLAY DATABASE commands.

LDM1508E

xx is not a file group name

Reason:

A command specified file group name xx but the file group was not defined to the file server by prior ADDFILE commands.

Action:

Use the DISPLAY command to list the currently active file groups.

LDM1509I

Now recording in file group xx, file yy

Reason:

The file server detected that a file in a file group was full and has switched to the next available file in the group.

Action:

No action required. This message is informational.

LDM1510I

Current file is filename

Reason:

The message lists the currently active file in a file group.

Action:

No action required. This message is informational.

LDM1511E

All files are full

Reason:

All files in the file group are full.

Action:

Determine why all files are full. Look for possible problems with automatic archive jobs (whether they ran, whether they ran successfully). If no operational error is found, call CA Support.

LDM3901I

XCF Driver version has been initialized

Reason:

The XCF Driver has initialized.

Action:

No action required. This message is informational.

LDM3902I

XCF Driver has terminated

Reason:

The XCF Driver has terminated.

Action:

No action required. This message is informational.

LDM3950E

Cannot Initialize XCF Driver Environment

Reason:

The system does not support XCF or the XCF component is not available.

Action:

Review CA-L-Serv's logs to determine why the XCF component was unable to initialize.

Retain appropriate diagnostic information (SVC dumps, logs) and call CA Support.

LDM3951E

XCF Busy condition detected - Attempting Retry

Reason:

XCF is busy, but a retry will be attempted.

Action:

If the condition persists, call CA Support.

LDM3952E

Error Sending Message; IXCMSGO return code = code, reason code = code

Reason:

The XCF component of the communications server was unable to send a message due to an XCF problem.

Action:

Look up the return and reason codes for the IXCMSGO macro in the Authorized Assembler Reference manuals relevant to your installation.

If the condition persists, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM3953E

LXCF Query Failed; IXCQUERY return code = code, reason code = code

Reason:

The XCF component of the communications server failed to issue the IXCQUERY macro.

Action:

Look up the return code and reason code for the IXCQUERY macro in the Authorized Assembler Reference manuals relevant to your installation.

If the condition persists, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM3954E

Terminating XCF driver due to Query Failure

Reason:

XCF terminated because of a query failure.

Action:

Check the contents of message LDM3953E.

LDM3955E

Send Request to unknown XCF Member -> member

Reason:

XCF attempted to send a message to an XCF member that is no longer part of the sysplex group.

Action:

Review the system log and CA-L-Serv's logs on the target system to determine why the member is no longer active.

LDM4000I

SQL server is now active

Reason:

The SQL server has successfully initialized.

Action:

No action required. This is an informational message.

LDM4001I

Reading statement: text

Reason:

This message is used to echo SQL statements found in the file defined by the LDMSQDEF member of the LDMPARM data set to the CA-L-Serv log.

Action:

No action required. This is an informational message.

LDM4002I

SQL server has terminated

Reason:

The SQL Server has terminated as a result of a DETACH SQLSERVER command, a series of fatal errors during SQL execution, or the termination of CA-L-Serv.

Action:

No action required. This is an informational message.

LDM4003I

OK

Reason:

The SQL Server processed the command successfully.

Action:

No action required. This is an informational message.

LDM4004E

No rows match selection criteria, or table has no rows

Reason:

An LSQL SELECT statement did not find any rows matching the selection criteria.

Action:

This may be a normal condition.

LDM4005L

SQL server abend: code at displacement in module

Reason:

The SQL server abended.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4007E

File Server task is not attached - SQL not activated

Reason:

The SQL Server requires the File Server to be active; when this requirement is not met, this message is issued.

Action:

Review CA-L-Serv's logs to determine why the file server is inactive.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4008E

SQL Server no longer functional

Reason:

The SQL Server or CA-L-Serv was stopped while an SQL statement was executing. The SQL statement may or may not have executed, or it may have been partially executed.

Action:

Review the CA-L-Serv's logs looking for previous error messages and for possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4010L

Program logic error at displacement in module, R15=value

Reason:

An internal SQL server error was encountered while processing an SQL statement.

Action:

Review the CA-L-Serv's logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4013L

Stack error at displacement in module

Reason:

An internal SQL server error was encountered while processing an SQL statement.

Action:

Review the CA-L-Serv's logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4014L

Insufficient storage error at displacement in module

Reason:

The SQL server was unable to acquire the storage required to process an SQL statement.

Action:

You may need to increase the CA-L-Serv region.

If no operational problem is found, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4015L

Program logic error - bad parameter list

Reason:

An internal error was encountered while processing an SQL statement.

Action:

Review the CA-L-Serv logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4016L

Insufficient storage condition in LDMSQLPC

Reason:

The SQL server was unable to acquire the storage required to process an SQL statement.

Action:

You may need to increase the CA-L-Serv's region.

If no operational problem is found, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4017L

Program logic error - bad packet token

Reason:

An internal error was encountered while processing an SQL statement.

Action:

Review the CA-L-Serv's logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4018L

Program logic error - bad return code, but no message

Reason:

An internal error was encountered while processing an SQL statement.

Action:

Review the CA-L-Serv's logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4019L

Compiler program logic error

Reason:

Internal error while processing an SQL statement.

Action:

Review the CA-L-Serv logs looking for prior error messages and possible abends of the SQL server.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4020E

SQL statement contains no text

Reason:

This message is issued when the LSQL command is entered without any accompanying arguments.

Action:

Refer to the Reference Guide for additional information concerning the LSQL command.

LDM4022E

Only nnn rows searched, as directed on OPTIONS SCANLIMIT command

Reason:

The SQL server has scanned the maximum number of records defined by the SCANLIMIT parameter of the ATTACH SQLSERVER command.

Action:

If necessary, increase the SCANLIMIT value.

LDM4023E

Unable to automatically expand rows with primary keys

Reason:

For tables defined with leading NULL bytes, a new column could not be added because there was not enough room in the leading SQL NULL bytes to contain the new column's NULL bit.

Action:

Review the SQL statements in the Reference Guide for additional information.

LDM4024E

Update access conflict for table tablename to file filename

Reason:

An SQL statement could not update or delete rows for a table because there were other operations in progress against the same table (for this same statement). This can occur when the SQL statement references the same table more than once (e.g., as the main table as well as the table in a subquery or join operation). This type of conflict can occur for two different tables if the two tables are contained in the same VSAM file. This restriction prevents VSAM Control Interval lockouts.

Action:

Reformulate the SQL statement to avoid this deadlock. Usually, this requires using two different SQL statements.

LDM4025I

Row updated

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4026I

nnn rows updated

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4027I

Row deleted

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4028I

nnn rows deleted

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4033I

Row inserted

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4034I

nnn rows inserted

Reason:

These messages acknowledge the various types of updates performed against an SQL table.

Action:

No action required. These messages are informational.

LDM4034L

Column missing, or COL# column is damaged - table inaccessible

Reason:

The SQL server was unable to access the column referenced by COL# or the column is missing.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4035L

Column xxxx contains invalid data type - table damaged and inaccessible

Reason:

The SQL server was unable to access the column referenced by xxxx because the corresponding table specifies an invalid data type for the column.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4036L

Table dictionary row missing or damaged

Reason:

In the TABLE data dictionary table, the row that describes a relational table is missing or damaged. The SQL server marks that table as damaged so that it is no longer accessible.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4040E

Table access is now disabled

Reason:

This message always follows other error messages that indicate reporting a problem with the dictionary structure for the table. This message signals that access to the table is no longer allowed.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4041I

SQL table xxxx is now available

Reason:

This message is issued during SQL initialization to signal that the identified table is now ready for access.

Action:

No action required. This message is informational.

LDM4042L

Table ID xxxx is invalid - table inaccessible

Reason:

The table id xxxx is invalid. The SQL server will fail requests attempting to access the table.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4044E

Table had n1 rows, now has n2 - TABLE data dictionary table updated

Reason:

The number of rows read in a table does not match the number of rows specified for that table. (The ROW COUNT column of the TABLE data dictionary table indicates how many rows are specified for that table.) The SQL server automatically updates the ROW COUNT column to reflect the number of rows read in.

Action:

This message usually appears after other messages report that certain data rows were discarded. If this is not the case, retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4050I

SQL facilities are now available

Reason:

This message is issued when the SQL server has completed initialization and is ready to process SQL queries.

Action:

No action required. This message is informational.

LDM4052E

SQL initialization unable to proceed

Reason:

The SQL server is unable to initialize and terminates.

Action:

Review the CA-L-Serv logs looking for previous error messages to determine why the SQL server is unable to initialize.

Gather the appropriate diagnostic information, and then call CA Support.

LDM4053L

Logic error during SQL initialization

Reason:

The SQL server encountered an error and did not initialize successfully.

Action:

Gather the appropriate diagnostic information, and then call CA Support.

LDM4054L

SQL initialization abend: code at displacement in module

Reason:

The SQL server abended and did not initialize successfully.

Action:

Gather the appropriate diagnostic information, and then call CA Support.

LDM4055E

SQL initialization failed; SQL facilities are not available

Reason:

The SQL server encountered an error and did not initialize successfully.

Action:

Gather the appropriate diagnostic information, and then call CA Support.

LDM4056E

DATABASE clause missing from CREATE TABLE statement

Reason:

A CREATE TABLE statement does not indicate the data set against which the table is to be mapped.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4057E

Error for table xxxx

Reason:

The CREATE TABLE statement for table xxxx is in error.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4058E

DATABASE clause in CREATE TABLE statement contains an error

Reason:

Parameters in the DATABASE clause of the CREATE TABLE statement are invalid. This message is followed by additional messages indicating the problem.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4059E

VSAM key is at offset xxxx; CREATE TABLE statement points at offset yyyy

Reason:

The CREATE statement and the offset value specified when the VSAM data set was defined are inconsistent: the relational table's primary key must include the VSAM file key.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4060E

VSAM key length (nn) is too long; maximum length is 100 bytes

Reason:

The length specified for a primary key exceeds the maximum length of 100 bytes.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4061E

Primary key size (nn1) is larger than the VSAM key size (nn2)

Reason:

The length of a primary key cannot exceed the length specified when the VSAM data set was created.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4062E

SQL row size (nn1) exceeds maximum VSAM recsize (nn2)

Reason:

The total row size nn1 adds up to more than the maximum record length specified when the VSAM data set was created.

Action:

Refer to the description of the CREATE TABLE statement.

LDM4063E

Database damage detected on tablename

Reason:

This message is issued when a VSAM record does not match its corresponding SQL table. This can occur when a table is associated with the wrong file, or when a CREATE TABLE statement was incorrectly formulated.

Action:

Review the CREATE TABLE statement.

LDM4064E

Row should be n bytes in length, not m

Reason:

This message is issued when a VSAM record does not match its corresponding SQL table. This can occur when a table is associated with the wrong file, or when a CREATE TABLE statement was incorrectly formulated.

Action:

Review the CREATE TABLE statement.

LDM4065E

Unable to open file filename

Reason:

The SQL Server cannot open the VSAM file filename. The most common cause of this is the absence of a file definition for the file, as established with the ADDFILE command.

Action:

Review the file server log to determine possible errors concerning the file. Issue a DISPLAY DATABASE command to list the current status of the file.

LDM4072I

Above statement unsupported in this venue

Reason:

This message is issued if any statement other than a CREATE TABLE or DROP TABLE appears in the LDMSQDEF file at startup.

Action:

Remove improper statements from LDMSQDEF file.

LDM4073L

Unable to retrieve statement summary - RC=code

Reason:

The SQL server encountered an internal logic error.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4074E

Insufficient security access to database xxxx for this request

Reason:

A statement could not be executed because the requestor is not authorized at the necessary level.

Action:

If you need more authorization, contact your security administrator.

LDM4075E

Unable to retrieve database identification - RC=code

Reason:

This message is issued by the LSQL command after the command failed to verify the file underlying an SQL table. The code is the CA-L-Serv return code.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4080I

SQL Statistics

LDM4081I 	Statement   Count   DB Activity   Count
LDM4082I 	statement   nn1      type          nn2
LDM4083I 	
LDM4084I 	Last Row    Table     Row (Key)    Time
LDM4090I 	Selected    name      name         time
LDM4091I 	Fetched     name      name         time
LDM4092I 	Inserted    name      name         time
LDM4093I 	Updated     name      name         time
LDM4094I 	Deleted     name      name         time
LDM4083I 	
LDM4086I 	Compilations:  nn     Avg Service Time: nn
LDM4087I 	Execution:     nn                       nn
LDM4083I 	
LDM4088I 	Errors:  Compilation   Execution   Logic
LDM4089I 	           nn           nn          nn

Reason:

These messages display information about the SQL server's SQL activities, as follows:

Action:

No action is required. These messages are informational.

LDM4101E

Error near text: Invalid delimiter xx

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and reference the information concerning the statement's syntax.

LDM4102E

Error near text: Character xx has no function in SQL

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and reference additional information concerning the statement's syntax.

LDM4103E

Error near text: Non-printable hex character found

Reason:

The SQL server detected a syntax error.

Action:

Use SPF EDIT in HEX mode to find the character then respecify the statement.

LDM4104E

Error near text: Unpaired left parenthesis

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message.

LDM4105E

Error near text: Unpaired right parenthesis

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message.

LDM4106E

Error near text: Cannot include more than 3 levels of parentheses

Reason:

The statement contains more than the maximum level of parentheses allowed.

Action:

Refer to additional information concerning the statement's syntax.

LDM4107E

Error near text: Unpaired apostrophe

Reason:

The SQL server found an unpaired apostrophe.

Action:

Refer to additional information concerning the statement's syntax.

LDM4108E

Error near text: Word xxxx is reserved or is used for an unsupported function

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4109E

Error near text: Statement has too many objects - shorten statement

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4110E

Error near text: Improperly qualified name: xxxx

Reason:

A column name or table name specification is invalid. Each table or column name level must be no more than 18 characters long.

Action:

Refer to additional information concerning the statement's syntax and specifications.

LDM4111E

Error near text: "word" appears out of context

Reason:

Word appears in the wrong place or does not belong in the SQL statement.

Action:

Refer to additional information concerning the statement's syntax and specifications.

LDM4112E

Error near text: Table or column name xxxx too long (18 characters maximum)

Reason:

The table name or column name specified in the statement exceeds the maximum length of eighteen characters.

Action:

Refer to additional information concerning the syntax of SQL statements.

LDM4113E

Error near text: Host variable name xxxx too long (32 characters maximum)

Reason:

The host variable name specified in the statement exceeds the maximum length of thirty-two characters.

Action:

Refer to additional information concerning naming conventions for host variables.

LDM4114E

Error near text: Invalid numeric string - may have started SQL word with number

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4115E

Error near text: Invalid hexadecimal value

Reason:

You must use the syntax X'nnnn' for the hexadecimal string, where nnnn contains hexadecimal digits 0-9 or A-F.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4116E

Error near text: "word" must be followed by parenthetical expression

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4130E

Error near text: Table name tablename has not been defined

Reason:

A column name was specified in the tablename.columnname format, but tablename is not otherwise defined as a table within the statement.

Action:

Refer to CA-L-Serv's logs to determine why the table was not defined.

LDM4131E

Error near text: Too many table references

Reason:

The number of base tables specified exceeds the maximum supported. The maximum number of tables that can be specified is 8.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4140E

Error near text: Define column xxxx before referencing it as primary key

Reason:

The statement refers to column xxxx as the primary key, but the column has not yet been defined.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4141E

Error near text: Bad primary key definition; non-adjacent columns or columns referenced out of order

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and additional information concerning the statement's syntax.

LDM4142E

Error near text:xxxx” not expected here

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4143E

Error near text: Too many subqueries

Reason:

The number of subqueries specified exceeds the maximum supported. The maximum number of subqueries that can be specified is 7. (The number of subqueries allowed can be less than 7 if the statement contains joins.)

Action:

Refer to additional information concerning the statement's syntax.

LDM4144E

text: Column xxxx is not a grouping column

Reason:

In a SELECT statement containing a GROUP BY clause, a column name was requested in the selection list but not in the GROUP BY column list. Only values in the GROUP BY column list can be referenced.

Action:

Review the information in the message and refer to additional information concerning the utilization of the GROUP BY clause.

LDM4145E

text: Grouping column xxxx was specified twice

Reason:

A column was mentioned more than once in the GROUP BY clause.

Action:

Review the information in the message to determine the error and refer to additional information concerning the syntax of the GROUP BY clause.

LDM4146E

text: No grouping columns present

Reason:

The GROUP BY clause was not followed by at least one grouping column name.

Action:

Refer to additional information concerning the utilization of the GROUP BY clause.

LDM4147E

text: GROUP BY is missing

Reason:

A HAVING clause was encountered on a SELECT statement but there was no corresponding GROUP BY clause. A GROUP BY clause must follow the HAVING clause on a SELECT statement.

Action:

Refer to additional information concerning the utilization of the GROUP BY and the HAVING clause.

LDM4150E

Error near text: Statement ended due to incomplete SQL syntax - may be misplaced semicolon

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4151E

Error near text: Statement too large to compile

Reason:

The SQL statement exceeds the maximum size which can be compiled.

Action:

Refer to additional information concerning SQL server restrictions.

LDM4152E

Error near text: Column/aggregate value mixture is not allowed.

Reason:

The SQL server detected a syntax error. In a SELECT statement selection list, you cannot specify one or more column names (perhaps within a function) along with one or more aggregate value functions such as COUNT, MIN, or SUM.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax and usage rules.

LDM4153E

Error near text: Expected character but got value.

Reason:

The SQL server detected a syntax error.

Action:

Provide a character value at the indicated point.

LDM4154E

Error near text: Invalid LIKE predicate matching pattern

Reason:

The matching pattern specified with a LIKE predicate is invalid. This message can occur when you specify something like the following:
. . . LIKE  'abcX'  ESCAPE  'X'

An error occurred because there were no additional characters after the escape character 'X' in the matching pattern.

Action:

Refer to additional information concerning the LIKE predicate.

LDM4155E

Error near text: Expected a single character but got value

Reason:

There are occasions in the SQL syntax where only a single 1-byte character string can be specified, such as the following:

LIKE '...' ESCAPE  'XY'

With ESCAPE, you can specify only a single character.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4156E

Error near text: Invalid argument for function

Reason:

An argument for the identified function is incorrectly specified.

Action:

Review the information in the message and refer to additional information about specifying the function.

LDM4157E

Error near text: Invalid argument: argument - expected integer value

Reason:

The function being enacted requires an integer argument but received some other value type.

Action:

Review the information in the message and refer to additional information concerning the function and SQL value types.

LDM4158E

Error near text: Invalid argument: argument - expected character value

Reason:

The function being enacted requires a character string argument but received some other value type.

Action:

Review the information in the message and refer to additional information concerning the function and SQL value types.

LDM4160E

Error near text: Invalid table name xxxx

Reason:

Table names must contain from 1 to 18 alphanumeric characters, starting with an alphabetic character. Underscore characters can also be used in table names.

Action:

Refer to additional information concerning SQL syntax rules.

LDM4161E

Error near text: Invalid column name xxxx

Reason:

Column names must contain from 1 to 18 alphanumeric characters, starting with an alphabetic character. Underscore characters can also be used in column names.

Action:

Review the information in the message and refer to additional information concerning SQL syntax rules.

LDM4162E

Error near text: Column definition missing - may be missing parentheses

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and refer to additional information concerning the statement's syntax.

LDM4163E

Error near text: Data type required in column definition

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and refer to additional information concerning the statement's syntax.

LDM4164E

Error near text: Invalid data type xxxx in column definition

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and refer to additional information concerning the statement's syntax.

LDM4165E

Error near text: Column name missing or incomplete

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and refer to additional information concerning the statement's syntax.

LDM4167E

Error near text: PRIMARY KEY specification conflict

Reason:

You cannot specify PRIMARY KEY within a column definition and after all columns are defined. Choose one way or the other.

Action:

Refer to additional information concerning PRIMARY KEY specification.

LDM4168E

Error near text: Extraneous input

Reason:

The SQL server detected a syntax error.

Action:

Review the information contained in the message and refer to additional information concerning the statement's syntax.

LDM4169E

Error near text: Value missing for DEFAULT clause

Reason:

The DEFAULT clause does not introduce a value.

Action:

Review the information contained in the message and refer to additional information concerning the DEFAULT clause.

LDM4170E

Error near text: Value xxxx on DEFAULT clause is invalid

Reason:

The value specified in the DEFAULT clause is invalid.

Action:

Refer to additional information concerning the DEFAULT clause.

LDM4171E

Error near text:nn “ exceeds maximum value allowed for this data type

Reason:

The value nn exceeds the storage capacity defined for a column. If the column's data type is INTEGER, the maximum value is 2147483647. If the data type is SMALLINT, the maximum value is 32767.

Action:

Refer to additional information concerning maximum values supported for each data type.

LDM4172E

Error near text: Invalid syntax for CHAR or HEX data type

Reason:

The SQL server detected a syntax error.

Action:

Use the syntax CHAR(n) or HEX(n), where n is a numeric string.

Review the information contained in the message and refer to additional information concerning the DEFAULT clause.

LDM4173E

Error near text: Two columns with name xxxx

Reason:

The SQL server encountered duplicate column names.

Action:

Review the SQL log to identify the process leading up to the duplicate definition.

LDM4174E

Error near text: VALUES clause missing in column definition

Reason:

The statement requires a VALUES clause.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4175E

Error near text: List on VALUES keyword is missing or invalid

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4176E

Error near text: List missing for VALUES keyword

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4177E

Error near text: Invalid value specification: argument.

Reason:

A value was specified that was not of a valid format for the function being enacted.

Action:

Refer to additional information concerning the statement's syntax.

LDM4178E

Error near text: Number of columns and column values unequal

Reason:

The SQL server detected a discrepancy between the number of columns in the table and the values specified in the statement.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4179E

Error near text: Column name missing

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4180E

Error near text: Invalid syntax for assigning value to column

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4181E

Error near text: SET clause missing

Reason:

The SQL server detected a syntax error.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4182E

Error near text: Predicate incomplete or invalid

Reason:

The SQL server detected an invalid or incomplete predicate.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4183E

Error near text: Feature not supported by CA-L-Serv

Reason:

The feature is not supported by CA-L-Serv SQL.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4184E

Error near text: WHERE clause required

Reason:

A WHERE clause is required for this statement.

Action:

Review the information in the message and refer to additional information concerning the statement's syntax.

LDM4185E

Error near text: Unknown expression in WHERE clause

Reason:

The WHERE clause contains an unknown expression.

Action:

Review the information in the message and refer to additional information concerning the syntax of WHERE clauses.

LDM4186E

Error near text: Cannot include more than 3 levels of parentheses in search criteria

Reason:

The search criteria contain more than three levels of parentheses.

Action:

Refer to additional information concerning the specification of search criteria.

LDM4187E

Error near text: Search criteria missing or invalid on WHERE clause

Reason:

The WHERE clause does not contain search criteria or the search criteria specified are invalid.

Action:

Refer to additional information concerning the specification of search criteria.

LDM4188E

Error near text: Location of term xxxx invalid

Reason:

The SQL server detected a syntax error.

Action:

Review the text of the message and refer to additional information concerning the statement's syntax.

LDM4189E

text: Float point columns not permitted in the primary key

Reason:

Because of the imprecision of floating point numbers, columns of data type FLOAT, DOUBLE PRECISION, and REAL cannot be primary keys.

Action:

Refer to additional information concerning the specification of primary keys.

LDM4190E

Error near text: Invalid host variable name xxxx - may be colon out of context

Reason:

The host variable name specified in the statement is invalid.

Action:

Refer to additional information concerning the specification of host variables.

LDM4191E

Error near text: FROM clause on SELECT or DELETE statement is missing or invalid

Reason:

A FROM clause specified after a SELECT or DELETE verb is missing or the clause is invalid.

Action:

Review the text of the message and refer to additional information concerning the specification of FROM clauses.

LDM4192E

Error near text: Add host variables to statement - more column values than host variables

Reason:

The SQL server detected a logic error in an SQL statement. The numbers of host variables and column values are inconsistent.

Action:

Correct the inconsistency.

LDM4193E

Error near text: More host variables in statement than columns of data

Reason:

The SQL server detected a logic error in an SQL statement. The numbers of host variables and columns are inconsistent.

Action:

Correct the inconsistency.

LDM4194E

Error near text: DECLARE statement contains syntax error

Reason:

The SQL server detected a syntax error in a DECLARE statement.

Action:

Refer to additional information concerning the DECLARE statement.

LDM4195E

Error near text: Invalid cursor name xxxx

Reason:

The SQL server detected an invalid cursor name.

Action:

Refer to additional information concerning the specification of cursors.

LDM4196E

Error near text: SELECT clause required

Reason:

The SQL server detected that an SELECT clause is missing.

Action:

Refer to additional information concerning usage rules for SELECT clauses.

LDM4197E

Error near text: INTO verb missing from SELECT clause

Reason:

The SQL server detected a syntax error

Action:

Review the text of the message and refer to additional information concerning statement's syntax.

LDM4198E

Error near text: Numeric expressions not allowed in an IN predicate

Reason:

An IN predicate specified a numeric expression.

Action:

Review the text of the message and refer to additional information concerning statement's syntax.

LDM4199E

Error near text: Argument list for IN predicate missing or invalid

Reason:

The IN predicate does not specify an argument list or the argument list specified is invalid.

Action:

Review the text of the message and refer to additional information concerning statement's syntax.

LDM4200E

Error near text: Too many columns defined for table - 250 columns per table maximum

Reason:

The SQL server detected that the maximum number of columns for a table was exceeded.

Action:

Review the text of the message additional information concerning table definitions.

LDM4201E

Error near text: Columns cannot contain more than 32,000 bytes total

Reason:

The SQL server detected that the maximum size of a column for a table was exceeded.

Action:

Review the text of the message and refer to additional information concerning column definitions.

LDM4202E

Error near text: Column cannot contain null value

Reason:

The column definition is not consistent with the null value specified.

Action:

Review the text of the message and refer to additional information concerning data types and column definitions.

LDM4203E

Primary key size exceeds maximum of 100 bytes

Reason:

The primary key definition exceeds the maximum of 100 bytes.

Action:

Refer to additional information concerning primary key definitions.

LDM4204E

Error near text: ALTER TABLE statement has syntax error

Reason:

The SQL server detected a syntax error in an ALTER TABLE statement.

Action:

Review the text of the message and refer to additional information concerning the syntax of the ALTER TABLE statement.

LDM4205E

Error near text: Invalid syntax in DATABASE clause

Reason:

The syntax of the DATABASE clause is invalid.

Action:

Review the text of the message and refer to additional information concerning the DATABASE clause.

LDM4206E

Error near text: Host variable xxxx has already been used to define a column name

Reason:

The host variable already refers to another column.

Action:

Review the text of the message and refer to additional information concerning host variables.

LDM4207E

Error near text: Invalid DECIMAL column type specification

Reason:

The DECIMAL(nnn) data type was incorrectly formulated on the CREATE TABLE or ALTER TABLE statement.

Action:

Refer to additional information concerning data types and column definitions.

LDM4208E

Error near text: Incomplete or erroneous ORDER BY specification

Reason:

The ORDER BY clause was incorrectly formulated.

Action:

Refer to additional information concerning the ORDER BY clause.

LDM4209E

Error near text: Numeric value value exceeds maximum allowed for ORDER BY specifications

Reason:

The ORDER BY clause allows the specification of a relative selection list number (value). For example, 4 would identify the 4th item in the selection list. This message is issued when the value specified is zero or negative, or is larger than the number of items in the selection list.

Action:

Review the text of the message and refer to additional information concerning the ORDER BY clause.

LDM4210E

Error near text: Too many names/integers specified with ORDER BY specification

Reason:

The maximum number (255) of ORDER BY items has been exceeded.

Action:

Refer to additional information concerning restrictions with the ORDER BY clause.

LDM4211E

Error near text: Duplicate correlation name: aliasname.

Reason:

The same correlation name (that is, alias name) was defined for more than one table. Each correlation name must be matched to exactly one table.

Action:

Review the text of the message and refer to additional information concerning correlation names.

LDM4212E

Error near text: value is below minimum value allowed for this data type.

Reason:

On the CREATE TABLE statement, a column specification was below the minimum required value.

Action:

Check the minimum and maximum values for each data type.

LDM4213E

Error near text: Invalid Date/Time Specification: value

Reason:

A value specified for a DATE, TIME, or TIMESTAMP value is invalid. The format expected for the various types are as follows:

Type

Format

Example

DATE

YYYY-MM-DD

1993-04-30

TIME

HH:MM:SS

15:23:32

TIMESTAMP

YYYY-MM-DD HH:MM:SS

1993-04-30 15:23:32

Action:

Refer to additional information concerning DATE, TIME, and TIMESTAMP specifications.

LDM4300E

xxxx is not a valid SQL verb

Reason:

The xxxx literal is not a valid SQL verb.

Action:

Review the text of the message and refer to a list of valid SQL verbs.

LDM4301E

xxxx is a reserved keyword for the yyyy verb

Reason:

The xxxx keyword is reserved and has been used out of context.

Action:

Review the text of the message and refer to additional information concerning the xxxx keyword.

LDM4302E

zzzz required after this SQL verb

Reason:

The SQL verb must be followed by zzzz.

Action:

Refer to additional information concerning the statement's syntax.

LDM4303E

Cannot use cursor operation from your environment

Reason:

Cursors can only be used from environments that support variables such as REXX and CLIST.

Action:

Refer to additional information concerning cursors.

LDM4305E

Cannot use host variable (xxxx) in a statement invoked from your environment

Reason:

Cursors can only be used from environments that support variables such as Rexx and Clist.

Action:

Refer to additional information concerning cursors.

LDM4306E

Primary key required in table definition

Reason:

An attempt was made to define a table without a primary key.

Action:

Refer to additional information concerning primary keys.

LDM4380L

SQL internal invocation error. Statement in error follows.

Reason:

An internal logic error occurred during SQL initialization.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4381L

Column columnname of row rowkey in the tablename table is bad

Reason:

During SQL initialization, a problem was detected with the dictionary row that describes the identified column. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4382L

Column dictionary structure for table tablename has failed validation

Reason:

During SQL initialization, a problem was detected with the dictionary row that describes the identified table. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4383L

Table ID id of table tablename is not valid

Reason:

During SQL initialization, a problem was detected with the dictionary row that describes the identified table. The content of the ID column in the TABLE row was not valid. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4384L

Table tablename has a table ID of xxx but that ID is already in use - table inaccessible

Reason:

During SQL initialization, a problem was detected with the dictionary row that describes the identified table. The ID column of the identified table was previously encountered in the ID column of a different TABLE row. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4385L

The default row for table tablename cannot be found - table inaccessible

Reason:

During SQL initialization, a problem was detected with the DEFAULT dictionary row associated with the identified table. The DEFAULT row could not be found. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4386L

Unable to read in TABLE row due to length error - unidentified table is inaccessible

Reason:

During SQL initialization, a problem was detected with the dictionary row that describes the identified table. The length of the TABLE row that was read from the database is too short. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4387L

Unable to read in TABLE row for the COLUMN table

Reason:

During SQL initialization, a problem was detected during initial processing of the SQL dictionary. The table is unavailable for use. This message usually indicates database damage.

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4388I

SQL Dictionary Tables have been created

Reason:

During SQL initialization, the SQL dictionary was found to be empty. The necessary SQL dictionary rows were created and written to the database.

Action:

No action is required. This message is informational.

LDM4401E

CREATE TABLE statement failed - table xxxx already exists

Reason:

An attempt was made to create table xxxx but the table already exists.

Action:

Review CA-L-Serv's SQL log to determine why the table already exists.

LDM4402E

Row nn already exists in table xxxx

Reason:

An attempt was made to add a row in table xxxx but the row already exists.

Action:

Review the sequence of events or the logic of the REXX EXEC or CLIST leading up to the error.

LDM4403E

Definition for column xxxx in table yyyy does not allow null value

Reason:

Null values are not allowed for this column.

Action:

Refer to additional information concerning data types and column definitions.

LDM4404E

Insert to table xxxx failed; column yyyy was not set or was set to null

Reason:

An insertion against table xxxx failed.

Action:

Review the text of the message and refer to additional information concerning data types and column definitions.

LDM4405E

Table xxxx does not exist

Reason:

An attempt was made to reference table xxxx but it does not exist.

Action:

Review the CA-L-Serv SQL message log looking for error messages which may help determine why the table does not exist.

LDM4406E

Table yyyy does not have a column xxxx

Reason:

An attempt was made to reference column xxxx in table yyyy but the column does not exist.

Action:

Review the logic leading up to the error. Use the SQL log to determine if any changes were recently made to the structure of the table.

LDM4407E

text data conversion error. Table: xxx, column: yyyy

Reason:

An expression contains an improper data type or comparison. For example, you may be trying to update a numeric column with character data.

Action:

Refer to additional information concerning data types and column definitions.

LDM4408E

Text in error: text

Reason:

An expression contains an improper data type or comparison. For example, you may be trying to update a numeric column with character data.

Action:

Refer to additional information concerning data types and column definitions.

LDM4409E

Text in error (via variable xxxx): text

Reason:

An expression contains an improper data type or comparison. For example, you may be trying to update a numeric column with character data.

Action:

Refer to additional information concerning data types and column definitions.

LDM4410E

Variable xxxx has null value - cannot have null value for primary key column

Reason:

Null values are not allowed for primary keys.

Action:

Refer to additional information concerning primary keys.

LDM4411E

Cannot use numeric data in this column

Reason:

An attempt was made to store numeric data in this column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning data types and column definitions.

LDM4412E

Cannot use character data in this column

Reason:

An attempt was made to store character data in this column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning data types and column definitions.

LDM4413E

Cannot use hexadecimal data in this column

Reason:

An attempt was made to store hexadecimal data in this column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning data types and column definitions.

LDM4414E

Update error. Table: xxxx, column: yyyy

Reason:

An attempt was made to update a column in a table but the attempt failed.

Action:

Review the CA-L-Serv SQL log and message log for additional messages concerning the problem.

LDM4415E

Primary key column cannot be updated

Reason:

You cannot change a primary key column through an UPDATE statement.

Action:

To change this column value, extract the value from every other column in that row and then delete the row. Then, add a new row, using the PRIMARY KEY column value and the values you extracted for other columns.

LDM4416E

Too many tables defined - maximum of 1,000 tables is supported

Reason:

An attempt was made to create more than 1,000 tables. This exceeds the maximum supported by CA-L-Serv.

Action:

Refer to additional restrictions.

LDM4417E

More values on INSERT statement than columns in table xxxx

Reason:

An attempt was made to insert a number of values greater than the number of columns defined in table xxxx.

Action:

Review the CA-L-Serv SQL log and message log to determine the process leading up to the error.

LDM4418E

Host variable xxxx has null value - cannot use null value for a table or column name

Reason:

An attempt was made to refer to a table or column with a null value.

Action:

Reference the description of the statement.

LDM4419E

name, supplied via host variable xxxx, is too large - 18 bytes maximum

Reason:

The host variable xxxx does not contain a valid name. The maximum length allowed is 18 bytes.

Action:

Reference a description of CA-L-Serv's SQL syntactic requirements.

LDM4420E

Search condition evaluation error

Reason:

A comparison was attempted on columns with different data types.

Action:

Refer to additional information concerning search conditions and data types.

LDM4421E

Cannot compare different types of data

Reason:

A comparison was attempted on columns with different data types.

Action:

Refer to additional information concerning search conditions and data types.

LDM4422E

Value 1: xxxx Value 2: yyyy

Reason:

A comparison was attempted on columns with different data types.

Action:

Refer to additional information concerning search conditions and data types.

LDM4423E

''text'', supplied via host variable xxxx, is not a valid name

Reason:

A table or column name, supplied from a host variable, was not valid.

Action:

Refer to a description of syntax and usage rules and restrictions concerning table names.

LDM4424E

xxxx function argument nn (value) is invalid.

Reason:

The function argument is invalid.

Action:

Refer to a description of the function's syntax.

LDM4425E

Wrong type value encountered during expression evaluation.

Reason:

Evaluation of an expression failed because it does not follow SQL syntax rules. A numeric or a character value was expected but value was specified instead.

Action:

Refer to a description of SQL syntax and data types.

LDM4426E

Expected a numeric value but encountered: value

Reason:

Evaluation of an expression failed because it does not follow SQL syntax rules. A numeric or a character value was expected but value was specified instead.

Action:

Refer to a description of SQL syntax and data types.

LDM4427E

Expected a character value but encountered: value

Reason:

Evaluation of an expression failed because it does not follow SQL syntax rules. A numeric or a character value was expected but value was specified instead.

Action:

Refer to a description of SQL syntax and data types.

LDM4428E

No default definition for table xxxx

Reason:

No default definition was specified for table xxxx.

Action:

Refer to additional information concerning table creation and default definitions.

LDM4430E

Cursor name is not active

Reason:

The statement refers to cursor name but the cursor is not active.

Action:

Refer to additional information concerning the utilization of cursors.

LDM4431E

More columns than host variables for FETCH statement

Reason:

Because you may not want all of the values selected by a FETCH statement, this message is only a warning. The &SQLCODE variable is not affected.

Action:

Refer to a description of the statement.

LDM4432E

Columns not used: columnlist

Reason:

Because you may not want all of the values selected by a FETCH statement, this message is only a warning. The &SQLCODE variable is not affected.

Action:

Refer to a description of the statement.

LDM4433E

More host variables than columns for FETCH statement

Reason:

This message is only a warning about a potential error. The &SQLCODE variable is not affected.

Action:

Refer to a description of the statement.

LDM4434E

Variables not set: varlist

Reason:

This message is only a warning about a potential error. The &SQLCODE variable is not affected.

Action:

Refer to a description of the statement.

LDM4435E

Invalid table reference for cursor operation xxxx

Reason:

An attempt was made to reference a table with cursor xxxx but the operation is invalid.

Action:

Refer to a description of the statements and cursor utilization.

LDM4436E

Table yyyy referenced on DECLARE statement; table zzzz referenced on UPDATE or DELETE statement

Reason:

An attempt was made to reference a table with cursor xxxx but the operation is invalid.

Action:

Refer to a description of the statements and cursor utilization.

LDM4437E

Update failed - row already deleted

Reason:

An attempt was made to delete a row but the row is already deleted.

Action:

If executing a CLIST or REXX EXEC, see the SQL log to determine the process leading to the error.

LDM4438E

Cannot insert data in table - value for column xxxx is missing

Reason:

An attempt was made to insert data in a table but no value was specified for column xxxx.

Action:

Specify a value for all columns defined by the CREATE TABLE statement.

LDM4439E

Conflicting references to colname in the search condition

Reason:

The search criteria you provided cannot possibly exist. (For example, you specified COL1='ABC' AND COL1>'ABC'.)

Action:

Refer to additional information on the utilization of search conditions.

LDM4440E

Column columnname is inappropriate as an argument for the functionname function.

Reason:

You used the wrong data type for the specified column.

Action:

Refer to a description of functions and data types.

LDM4441L

Decimal scaling error encountered.

Reason:

During arithmetic operations on the SQL statement, an illegal decimal scaling value was obtained from the SQL dictionary.

Action:

For assistance, contact CA Support at http://ca.com/support.

LDM4442L

Decimal overflow

Reason:

During arithmetic operations on the SQL statement, the summation of a numeric value exceeded the largest value that can be supported (1015).

Action:

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4443E

LIKE predicate expects a character string argument.

Reason:

The LIKE predicate can only introduce a character string.

Action:

Refer to a description of the LIKE predicate.

LDM4444E

Invalid decimal value encountered.

Reason:

Decimal columns in one or more rows contain invalid packed decimal numbers.

Action:

Refer to a description of restrictions concerning the decimal data type.

LDM4445E

Table xxxx does not exist or is inaccessible

Reason:

An attempt was made to access table xxxx but the table does not exist or is inaccessible.

Action:

Review the CA-L-Serv message log to determine why the table cannot currently be accessed.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4447E

Expression evaluation data conversion error.

Reason:

The SQL server could not convert a value. This message is followed by additional messages (LDM4407E, LDM4408E, and so on) that provide more details.

Action:

Refer to additional information concerning the rules of data conversion.

LDM4450E

Table xxxx damage detected during SQL initialization - table inaccessible

Reason:

The SQL server detected a damaged table.

Action:

Review the output of previous CA-L-Serv executions to determine how the table was damaged. You will have to DROP the current table definition and recreate it before you can access the data.

Retain the appropriate diagnostic information (abend dumps, SVC dumps, system logs, and supporting data) and call CA Support.

LDM4452E

ALTER TABLE statement failed - column xxxx already exists

Reason:

An attempt was made to add column xxxx to a table but the attempt failed because the column already exists.

Action:

Review the CA-L-Serv SQL log to determine the cause of the problem.

LDM4453E

Too many columns defined for table xxxx - 250 columns per table maximum

Reason:

The maximum number of columns allowed for a table was exceeded.

Action:

Refer to a description of SQL table's restrictions.

LDM4454E

ALTER TABLE operation not permitted for table tablename - increase in rows would exceed the maximum allowed

Reason:

An attempt was made to add columns to table tablename but the result of the operation would cause the maximum number of rows to be exceeded.

Action:

Refer to a description of SQL table's restrictions.

LDM4455E

Subquery execution selected more than one row.

Reason:

A subquery (for example, a SELECT statement inside of another SQL statement) returned more than one value when the situation allowed only a single value to be returned.

Action:

Reformulate the subquery to return only the single value desired.

LDM4456E

No rows inserted. Query returned no rows

Reason:

A subquery returned no rows, therefore, no rows were inserted.

Action:

Refer to a description of subqueries.

LDM4457I

nnn rows inserted

Reason:

This information describes the number of rows inserted using a query form of the SQL INSERT statement.

Action:

No action is required. This is an informational message.

LDM4458E

nnn rows not inserted due to duplicate key

Reason:

During an attempt to add multiple rows to a table using an INSERT statement with a subquery, one or more rows (nnn) were not inserted due to duplicate keys.

Action:

Review the SQL log to determine what leads up to the error. Depending on the application's logic this may be a normal condition.

LDM4460E

Date type value inappropriate for this column

Reason:

An attempt was made to use a date type value for the column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning the date data type.

LDM4461E

Time type value inappropriate for this column

Reason:

An attempt was made to use a time type value for the column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning the time data type.

LDM4462E

Timestamp type value inappropriate for this column

Reason:

An attempt was made to use a timestamp type value for the column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning the timestamp data type.

LDM4463E

Numeric value specified (nnnn) too large for this column type

Reason:

The value specified is too large to fit in the column specified. For SMALLINT columns, the maximum value is 32767. For INTEGER columns, the maximum is 2147483647. For DECIMAL columns, the maximum depends on the precision and scale that were specified when the column was created. For floating point columns, the maximum value is 1E60.

Action:

Refer to additional information on data type restrictions.

LDM4464E

Invalid numeric value specified

Reason:

The numeric value specified through a host variable was incorrectly formulated. This message is followed by message LDM4409E, which displays the contents of the host variable.

Action:

Refer to additional information concerning the formulation of numeric values.

LDM4465E

Invalid hexadecimal value specified

Reason:

An attempt was made to use a date type value for the column but this is inconsistent with the column's definition.

Action:

Refer to additional information concerning the formulation of hexadecimal values.

LDM4466E

Invalid datetime value specified

Reason:

The datetime value specified through a host variable was incorrectly formulated. The expected format is similar to the literal but without the literal introducer and apostrophes. For example, a date would be entered as 1994-04-30.

Action:

Refer to additional information concerning the formulation of datetime values.

LDM4475E

Column column is not in the selection list

Reason:

This message is issued when a column name (column) specified in the ORDER BY clause was not also mentioned in the selection list.

Action:

Refer to additional information concerning ORDER BY clauses.

LDM4476E

Text-in-error is an invalid ordering specification

Reason:

A relative selection list number specified in the ORDER BY clause is invalid.

Action:

Refer to additional information concerning ORDER BY clauses.

LDM4477E

Warning: The Row Match Limit, set at nnn, has been exceeded

Reason:

The Row Match Limit is set by the CA-L-Serv OPTIONS command.

Action:

You may choose to issue an OPTIONS TASK(SQL),MATCHLIMIT= command to increase the Row Match Limit.

LDM4478E

Premature End-Of-File has been forced

Reason:

The Row Match limit, which controls the number of base I/O operations that are permitted per SQL statement, has been exceeded. SQL statement execution proceeds by prematurely pretending that all the rows in the table being scanned have been read, when in fact they have not. This can result in an incomplete operation.

Action:

You may choose to issue an OPTIONS TASK(SQL),MATCHLIMIT= command to increase the Row Match Limit.

LDM4479E

Primary key columns can not be dropped

Reason:

Primary key columns cannot be removed using the ALTER TABLE statement.

Action:

To rebuild a table with a new primary key definition, you must define the new table using the CREATE TABLE statement, copy the rows from the old table to the new table using the INSERT statement, and drop the original table using the DROP TABLE statement.

LDM4500I

SQL Server Options-

LDM4501I  AUDIT=msgtype
LDM4501I  HOSTVARPFX=x
LDM4501I  LOGID=id
LDM4501I  MATCHLIMIT=nnn
LDM4501I  OPERATORPFX=x
LDM4501I  SCANLIMIT=nnn

Reason:

These messages display current operating values for the SQL server and tell you the following:

AUDIT

Identifies the type of messages being logged. (The SQL server may be logging error messages, SQL statements read in, or both.)

HOSTVARPFX

Displays the prefix character used to identify host variables in SQL statements.

LOGID

Identifies the log used to log SQL messages.

MATCHLIMIT

Displays the maximum number of rows that can be returned for an SQL statement. If there is no limit, 0 is shown.

OPERATORPFX

Displays the prefix character used with special relational operators in an SQL statement.

SCANLIMIT

Displays the maximum number of rows that can be searched through an SQL statement. If there is no limit, 0 is shown.

Action:

No action is required. These messages are informational.

LDM4501I

AUDIT=msgtype
HOSTVARPFX=x
LOGID=id
MATCHLIMIT=nnn
OPERATORPFX=x
SCANLIMIT=nnn

Reason:

These messages display current operating values for the SQL server and tell you the following:

AUDIT

The type of messages being logged. (The SQL server may be logging error messages, SQL statements read in, or both.)

HOSTVARPFX

The prefix character used to identify host variables in SQL statements.

LOGID

The log used to log SQL messages.

MATCHLIMIT

The maximum number of rows that can be returned for an SQL statement. If there is no limit, 0 is shown.

OPERATORPFX

The prefix character used with special relational operators in an SQL statement.

SCANLIMIT

The maximum number of rows that can be searched through an SQL statement. If there is no limit, 0 is shown.

Action:

No action is required. These messages are informational.

LDM4510I

SQL Table List-

LDM4511I  Key
LDM4512I  Table name   File     Prefix   Status
LDM4513I  name1        ddname   prefix   status

Reason:

These messages display summary information about the tables used by the SQL server. Information shown includes:

Table name

Contains the table's name (as specified on the CREATE TABLE statement).

File

Contains the ddname of the file where the table is stored.

Prefix

Contains the prefix of records in this table. The prefix is usually of interest when more than one SQL table is mapped to a single VSAM file. (This prefix becomes the first two bytes of the VSAM key field.)

Status

Contains the table's status (ACTIVE or INACTIVE).

Action:

No action is required. These messages are informational.

LDM4520I

The table does not exist. Table name xxxxxxxxxxxx

Reason:

The table referenced on the previous command does not exist.

Action:

Check the spelling of the table name specified. If correct, review CA-L-Serv's logs for references to the table and any associated messages.

LDM4521I

Detailed information for table xxxx

LDM4522I  File name. . . . . . . . . . . . . .xxxx
LDM4523I  Key prefix  . . . . . . . . . . . . x
LDM4524I  Internal ID   . . . . . . . . . . . nnnn
LDM4525I  Status. . . . . . . . . . . . . . . xxxx
LDM4526I  SQL row size. . . . . . . . . . . . nnn
LDM4527I  SQL primary key size . . . . . . . .nnn
LDM4528I  VSAM key length . . . . . . . . . . nnn
LDM4529I  Offset into SQL row
LDM4530I  of the primary key column   . . . . nnn
LDM4531I  Offset into the VSAM record
LDM4532I  of the first SQL column   . . . . . nnn
LDM4533I  of the physical key. . . . . . . . .nnn
LDM4534I  I/O activity count. . . . . . . . . nnn

Reason:

The messages LDM45211 to LDM45341 display detailed information about a table used by the SQL server. Information shown includes:

File name

Displays the ddname of the file where the table is stored.

Key prefix

Displays the prefix for records in this table. This prefix is used to separate the records in the VSAM file into multiple tables.

Internal ID

Displays the ID that SQL uses for this table.

Status

Displays the table's status (ACTIVE or INACTIVE).

SQL row size

Displays the length of each row in a table (in bytes).

SQL primary key size

Displays the length of the primary key for a row (in bytes).

VSAM key length

Displays the length of the VSAM key for a row (in bytes).

Offset into SQL row of the primary key column

Displays the leftmost byte of the first column of the SQL primary key.

Offset into the VSAM record of the first SQL column

Locates the first SQL column in the VSAM record.

Offset into VSAM record of the physical key

Locates the primary key in the VSAM record.

I/O activity count

Displays the number of I/O requests SQL made for the file containing this table.

Action:

No action is required. These messages are informational.

LDM4558E

nnn rows not inserted due to duplicate key.

Reason:

A subquery, used as a source of column information for an INSERT statement, returned one or more rows that were not inserted. The key formed from the information provided by the subquery for these rows was found to already exist in the database.

Action:

Review the SQL log to determine the process leading up to the error.

LDM4560E

Date type value inappropriate for this column.

Reason:

An attempt was made to assign a value to a column that had some other incompatible data type. (These messages appear after LDM4407E.)

Action:

Refer to additional information concerning these data types.

LDM4561E

Time type value inappropriate for this column.

Reason:

An attempt was made to assign a value to a column that had some other incompatible data type. (These messages appear after LDM4407E.)

Action:

Refer to additional information concerning these data types.

LDM4562E

Timestamp type value inappropriate for this column.

Reason:

An attempt was made to assign a value to a column that had some other incompatible data type. (These messages appear after LDM4407E.)

Action:

Refer to additional information concerning these data types.