IBM DB2 mainframe system table name conversions

IBM DB2 mainframe consolidated databases only support column names and other identifiers of 18 characters or less. The following table identifies how system table names for DB2 mainframe consolidated databases are mapped to system table names for all other consolidated database types.

If the system table name does not appear in the table below, no conversion is required.

System table name	System table name for DB2 mainframe consolidated databases
ml_active_remote_id	ml_active_rid
ml_connection_script	ml_conn_script
ml_passthrough	ml_pt
ml_passthrough_repair	ml_pt_repair
ml_passthrough_script	ml_pt_script
ml_passthrough_status	ml_pt_status
ml_scripts_modified	ml_script_modified

Discuss this page in DocCommentXchange.
Send feedback about this page using email.