SQL to retrieve DB2 subsystem information – update for DB2 10 z/OS
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 |
-- V8: SELECT GETVARIABLE('SYSIBM.DATA_SHARING_GROUP_NAME'), GETVARIABLE('SYSIBM.PACKAGE_NAME'), GETVARIABLE('SYSIBM.PACKAGE_SCHEMA'), GETVARIABLE('SYSIBM.PACKAGE_VERSION'), GETVARIABLE('SYSIBM.PLAN_NAME'), GETVARIABLE('SYSIBM.SECLABEL'), GETVARIABLE('SYSIBM.SYSTEM_NAME'), GETVARIABLE('SYSIBM.SYSTEM_ASCII_CCSID'), GETVARIABLE('SYSIBM.SYSTEM_EBCDIC_CCSID'), GETVARIABLE('SYSIBM.SYSTEM_UNICODE_CCSID'), GETVARIABLE('SYSIBM.VERSION') FROM SYSIBM.SYSDUMMY1; -- -- V9: SELECT GETVARIABLE('SYSIBM.APPLICATION_ENCODING_SCHEME'), GETVARIABLE('SYSIBM.COBOL_STRING_DELIMITER'), GETVARIABLE('SYSIBM.DATA_SHARING_GROUP_NAME'), GETVARIABLE('SYSIBM.DATE_FORMAT'), GETVARIABLE('SYSIBM.DATE_LENGTH'), GETVARIABLE('SYSIBM.DECIMAL_ARITHMETIC'), GETVARIABLE('SYSIBM.DECIMAL_POINT'), GETVARIABLE('SYSIBM.DEFAULT_DECFLOAT_ROUND_MODE'), -- GETVARIABLE('SYSIBM.DEFAULT_DEFAULT_SSID'), GETVARIABLE('SYSIBM.DEFAULT_LANGUAGE'), GETVARIABLE('SYSIBM.DEFAULT_LOCALE_LC_CTYPE'), GETVARIABLE('SYSIBM.DISTRIBUTED_SQL_STRING_DELIMITER'), GETVARIABLE('SYSIBM.DSNHDECP_NAME'), GETVARIABLE('SYSIBM.DYNAMIC_RULES'), GETVARIABLE('SYSIBM.ENCODING_SCHEME'), GETVARIABLE('SYSIBM.MIXED_DATA'), GETVARIABLE('SYSIBM.NEWFUN'), GETVARIABLE('SYSIBM.PACKAGE_NAME'), GETVARIABLE('SYSIBM.PACKAGE_SCHEMA'), GETVARIABLE('SYSIBM.PACKAGE_VERSION'), GETVARIABLE('SYSIBM.PAD_NUL_TERMINATED'), GETVARIABLE('SYSIBM.PLAN_NAME'), GETVARIABLE('SYSIBM.SECLABEL'), GETVARIABLE('SYSIBM.SQL_STRING_DELIMITER'), GETVARIABLE('SYSIBM.SSID'), GETVARIABLE('SYSIBM.STANDARD_SQL'), GETVARIABLE('SYSIBM.SYSTEM_NAME'), GETVARIABLE('SYSIBM.SYSTEM_ASCII_CCSID'), GETVARIABLE('SYSIBM.SYSTEM_EBCDIC_CCSID'), GETVARIABLE('SYSIBM.SYSTEM_UNICODE_CCSID'), GETVARIABLE('SYSIBM.TIME_FORMAT'), GETVARIABLE('SYSIBM.TIME_LENGTH'), GETVARIABLE('SYSIBM.VERSION') FROM SYSIBM.SYSDUMMY1; -- -- V10: Get Session variables: SELECT GETVARIABLE('SYSIBM.APPLICATION_ENCODING_SCHEME') AS APPLICATION_ENCODING_SCHEME, GETVARIABLE('SYSIBM.COBOL_STRING_DELIMITER') AS COBOL_STRING_DELIMITER, GETVARIABLE('SYSIBM.DATA_SHARING_GROUP_NAME') AS DATA_SHARING_GROUP_NAME, GETVARIABLE('SYSIBM.DATE_FORMAT') AS DATE_FORMAT, GETVARIABLE('SYSIBM.DATE_LENGTH') AS DATE_LENGTH, GETVARIABLE('SYSIBM.DECIMAL_ARITHMETIC') AS DECIMAL_ARITHMETIC, GETVARIABLE('SYSIBM.DECIMAL_POINT') AS DECIMAL_POINT, GETVARIABLE('SYSIBM.DEFAULT_DECFLOAT_ROUND_MODE') AS DEFAULT_DECFLOAT_ROUND_MODE, -- GETVARIABLE('SYSIBM.DEFAULT_DEFAULT_SSID') AS DEFAULT_DEFAULT_SSID, GETVARIABLE('SYSIBM.DEFAULT_LANGUAGE') AS DEFAULT_LANGUAGE, GETVARIABLE('SYSIBM.DEFAULT_LOCALE_LC_CTYPE') AS DEFAULT_LOCALE_LC_CTYPE, GETVARIABLE('SYSIBM.DISTRIBUTED_SQL_STRING_DELIMITER') AS DISTRIBUTED_SQL_STRING_DELIMITER, GETVARIABLE('SYSIBM.DSNHDECP_NAME') AS DSNHDECP_NAME, GETVARIABLE('SYSIBM.DYNAMIC_RULES') AS DYNAMIC_RULES, GETVARIABLE('SYSIBM.ENCODING_SCHEME') AS ENCODING_SCHEME, GETVARIABLE('SYSIBM.MIXED_DATA') AS MIXED_DATA, GETVARIABLE('SYSIBM.NEWFUN') AS NEWFUN, GETVARIABLE('SYSIBM.PACKAGE_NAME') AS PACKAGE_NAME, GETVARIABLE('SYSIBM.PACKAGE_SCHEMA') AS PACKAGE_SCHEMA, GETVARIABLE('SYSIBM.PACKAGE_VERSION') AS PACKAGE_VERSION, GETVARIABLE('SYSIBM.PAD_NUL_TERMINATED') AS PAD_NUL_TERMINATED, GETVARIABLE('SYSIBM.PLAN_NAME') AS PLAN_NAME, GETVARIABLE('SYSIBM.SECLABEL') AS SECLABEL, GETVARIABLE('SYSIBM.SQL_STRING_DELIMITER') AS SQL_STRING_DELIMITER, GETVARIABLE('SYSIBM.SSID') AS SSID, GETVARIABLE('SYSIBM.STANDARD_SQL') AS STANDARD_SQL, GETVARIABLE('SYSIBM.SYSTEM_NAME') AS SYSTEM_NAME, GETVARIABLE('SYSIBM.SYSTEM_ASCII_CCSID') AS SYSTEM_ASCII_CCSID, GETVARIABLE('SYSIBM.SYSTEM_EBCDIC_CCSID') AS SYSTEM_EBCDIC_CCSID, GETVARIABLE('SYSIBM.SYSTEM_UNICODE_CCSID') AS SYSTEM_UNICODE_CCSID, GETVARIABLE('SYSIBM.TIME_FORMAT') AS TIME_FORMAT, GETVARIABLE('SYSIBM.TIME_LENGTH') AS TIME_LENGTH, GETVARIABLE('SYSIBM.VERSION') AS VERSION, CASE WHEN SUBSTR(GETVARIABLE('SYSIBM.VERSION') ,8,1) IN ('0','1') THEN 'CM8/CM8*/ENFM8/ENFM8*' WHEN SUBSTR(GETVARIABLE('SYSIBM.VERSION') ,8,1) IN ('2','3') THEN 'CM9/CM9*/ENFM9/ENFM9/' WHEN SUBSTR(GETVARIABLE('SYSIBM.VERSION') ,8,1) IN ('5') THEN 'NFM10/' ELSE 'FUTURE USE' END AS MODIFCATION_LEVEL FROM SYSIBM.SYSDUMMY1; |