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


Create a junction in Windows 7 using the MKLINK command.

mklink /j source-path target-path

Example: create a junction named C:\Volatile to the S:\Volatile folder.

mklink /j C:\Volatile S:\Volatile