How to deal with error message DB01410E - DATA SET NAME WRONG CXXNAME
search cancel

How to deal with error message DB01410E - DATA SET NAME WRONG CXXNAME

book

Article ID: 47062

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/Introduction

 When creating and initializing application files used in Datacom/AD, you might receive the following error message:

DB01410E - DATA SET NAME WRONG CXXNAME

This is a simple message to understand, and relates to one of the features in Datacom/AD to help protect user data.

 

 

Resolution

Here is the reason description of the DB01410E message (you can find the whole message in the Datacom Messages on DocOps.ca.com):

Reason:

The data set name for the DDNAME should contain the CXXNAME, that is, the DBSIDPR module in use should specify that the CXXNAME is within the data set name for every database index and data area. However, an edit-check discovered an error in which a data set name did not contain the correct name.

Note: This edit check ensures that the data set is being used by the correct Datacom instance as part of the protection preventing, for example, a test MUF accidentally pointing to a production data set that could occur if production data sets or different production MUFs were to use each other’s data sets.

In the message text:

>>x is the DDNAME for the data set in error.

y is the CXXNAME that is in use and that is required to be in each index and data area data set name.

z is the data set name for the DDNAME that does not contain the CXXNAME.

Instructions: 

As part of the data protection functionality of Datacom/AD, you should have an entry in the DBSIDPR module called FORCE_DSN_CXXNAME=. If the value is YES (the default), when a database file is opened, the DSN is checked to be sure it belongs to this MUF, and if not, prevents accessing a database file that could be for another MUF. This will help prevent corruption of data resulting from using a mismatched database file and MUF.

This DB01410E message is produced when trying to allocate or open a database file, and the error means that the CXXNAME= value (from DBSIDPR) is needed as one of the nodes in the DSN of all database files.

There are two ways to resolve this error:

  1. Rename the application database file so that it contains the CXXNAME value as one of its nodes (recommended); or
  2. Change the value of FORCE_DSN_CXXNAME= to NO and reassemble the DBSIDPR module. Although we don't recommend turning off these data protection features, once you reassemble the DBSIDPR module, you can use your preferred filename. However, the possibility of errors or corrupt data is increased if a wrong database file was connected and opened by this MUF.

Either option is acceptable if you understand the risks associated with turning off this functionality.

 

 

 

Additional Information

For more information about the DBSIDPR settings, please review the “Modifying DBSIDPR Parameters” section of the documentation.