1021
z/OS Server / Migrating to 8.5 or above? What's the DB2 SCCSID?
« on: November 15, 2012, 12:49:00 PM »
This is in the CMOD 8.5 readme:
https://www-304.ibm.com/support/docview.wss?uid=swg27020591
------------------------------------------------------------------------
* New program ARSMIG85 for linefeed translation
When using OnDemand for z/OS V8.5.0 to access a pre-8.5 OnDemand
database and the ARS_ORIGINAL_CODEPAGE value matches the database
codepage (e.g. ARS_ORIGINAL_CODEPAGE matches the DB2 SCCSID), a new
program, ARSMIG85, must be run to translate EBCDIC newlines to EBCDIC |
linefeeds. |
If the ARS_ORIGINAL_CODEPAGE does not match the DB2 SCCSID, do not run |
the ARSMIG85 program.
How do you know what the DB2 SCCSID is? You can ask your DBA, or you can run this:
SELECT SBCS_CCSID, MIXED_CCSID, DBCS_CCSID
FROM SYSIBM.SYSDATABASE
WHERE NAME = 'ARS850DB' <<<=====REPLACE WITH YOUR DATABASE NAME
When I ran this on my DB2 V9 system I received the following:
+--------------------------------------------------+
| SBCS_CCSID | MIXED_CCSID | DBCS_CCSID |
+--------------------------------------------------+
| 37 | 0 | 0 |
+--------------------------------------------------+
https://www-304.ibm.com/support/docview.wss?uid=swg27020591
------------------------------------------------------------------------
* New program ARSMIG85 for linefeed translation
When using OnDemand for z/OS V8.5.0 to access a pre-8.5 OnDemand
database and the ARS_ORIGINAL_CODEPAGE value matches the database
codepage (e.g. ARS_ORIGINAL_CODEPAGE matches the DB2 SCCSID), a new
program, ARSMIG85, must be run to translate EBCDIC newlines to EBCDIC |
linefeeds. |
If the ARS_ORIGINAL_CODEPAGE does not match the DB2 SCCSID, do not run |
the ARSMIG85 program.
How do you know what the DB2 SCCSID is? You can ask your DBA, or you can run this:
SELECT SBCS_CCSID, MIXED_CCSID, DBCS_CCSID
FROM SYSIBM.SYSDATABASE
WHERE NAME = 'ARS850DB' <<<=====REPLACE WITH YOUR DATABASE NAME
When I ran this on my DB2 V9 system I received the following:
+--------------------------------------------------+
| SBCS_CCSID | MIXED_CCSID | DBCS_CCSID |
+--------------------------------------------------+
| 37 | 0 | 0 |
+--------------------------------------------------+