DB2 System Properties

tech — tags: — rohand @ August 18, 2009 5:16 PM

These calls will retrieve DB2 system properties.

SELECT *
FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS Instance_Info
GO
SELECT *
FROM TABLE(SYSPROC.ENV_GET_PROD_INFO()) AS Product_Info
GO
SELECT *
FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS System_Info
GO

©2010 appytizers. All rights reserved.