Delphix Products

When you run Hooks with DB2 are the Environment Variables set?

I can find documentation for this for Oracle and a blog post about SQL Server, but nothing about DB2.

Thanks
Jim
#Virtualization

Hi Jim,

It looks like there is a limitation.  In our docs, about DB2 Hook notes:

https://docs.delphix.com/docs/delphix-administration/db2-environments-and-data-sources/customizing-db2-management-with-hook-operations/db2-hook-operation-notes

--------------------------------------

DB2 Environment Variables

Operations that run user-provided scripts have access to environment variables. For operations associated with specific dSources or virtual databases (VDBs), the Delphix Engine will always set environment variables so that the user-provided operations can use them to access the dSource or VDB.

dSource Environment VariablesEnvironment VariableDescription

DLPX_DATA_DIRECTORY

Path where staging database is mounted

VDB Environment VariablesEnvironment VariableDescription

DLPX_DATA_DIRECTORY

Path where virtual database is mounted
-----------------------------------------------

I am going to check with our DB2 team to make sure this is true and post the reply back to you.

Cheers,
-Paul

When I run "env" as a hook I don't see either of that variable set, it would be helpful to be able to have things like VDB name, instance, etc. available in those hooks.

This discussion generated the following official knowledge article: https://support.delphix.com/Delphix_Virtualization_Engine/Other_Database_Types/DB2_Hooks_and_Environment_Variables_(KBA4047)