Operating Environment › About History Records › Step 4. Modify the XCOM Default Global Table

Step 4. Modify the XCOM Default Global Table

You need to modify the XCOM default global table to include certain parameters.

To modify the XCOM default global table

Add the following parameters:

SYSNAME and SYSID

Eight- and four-character values that uniquely identify a CA XCOM Data Transport system.

These are needed because history records can be accumulated from many different systems and system types. The values of these parameters are initially set during installation of CA XCOM but can be changed at any time.

XCOMHIST

The name that CA XCOM Data Transport will use to connect to ODBC.

XCOMHIST_TBL

The name of the table that was created.

The default value is xcom_history_tbl.

XCOMHIST_FILE

The name of the file that will contain SQL insert statements that could not be executed due to inaccessibility to the ODBC server. These records are also written if an attempt to insert the record fails.

The records may be used to insert history records directly into the database.

mysql-> use xcomhist

mysql-> source /xcomhist/history_records (pointed to by XCOMHIST_FILE)

XCOMHIST_SPLIT_FILE=Y/N

Specifies whether to split the INSERT statements created when ODBC fails into 72-byte segments. IBM’s SPUFI, a DB2 utility, takes only 80-byte records (72 usable) as input, whereas MySQL takes as input the complete statement and does not handle 72-byte checks; DB2 does not handle complete statements (unless they are less than 72 bytes).

XCOMHIST_BACKSLASH=Y/N

Inserts to the named table include the name of the local file on the PC. Files are typically named c:\folder\folder\file.

MySQL interprets \\ sequences as a single backslash character both in the actual insert and in the statement created when an insert fails. IBM treats the characters differently. If your target system is DB2 then XCOM_BACKSLASH=Y creates file names as c:\folder\folder\file.

If N is specified then XCOM creates the path as c:\\folder\\folder\\file. Note that when the data is actually inserts into the table, the \\ is interpreted as a single slash.

XCOMHIST_USER

Names the user ID that is used to establish a connection to the database.

XCOMHIST_PASSWORD[.ENCRYPTED]

Specifies the password of XCOMHIST_USER that is used to establish a connection to the database.

XCOMHIST_OWNER

The ID of the creator of the History Table. This value can be omitted if the owner is XCOMHIST_USER.