Skip to content

"July 28th 2022: dx_get_db_env doesn't generate commands for DB2 dSources/VDBs" #211

@carloscuellar87d

Description

@carloscuellar87d

** Expected Behavior**
dx_get_db_env -d -backup generated a set of scripts to recreate dsources and vdbs.

** Actual Behavior**
dx_get_db_env -d -backup generated a set of scripts to recreate dsources and vdbs but commands for DB2 dsources and vdbs do not match with the required parameters.

Example of command generated for db2 dsource:
dx_ctl_dsource -d dxcarlosnw.dcol2.delphix.com -action create -group "DB2 dSources" -creategroup -dsourcename "C76D105A" -type vFiles -sourcename "C76D105A" -sourceinst "auto1051 - 10.5.0.9 - db2aese" -sourceenv "cardb2stg" -source_os_user "auto1051

dx_provision_vdb -d dxcarlosnw.dcol2.delphix.com -type vFiles -group "DB2 vDBs" -creategroup -sourcename "C76D105A" -srcgroup "DB2 dSources" -targetname "DB2VDB22" -dbname "" -environment "cardb2tgt22" -envinst "auto1051 - 10.5.0.9 - db2aese" -envUser "auto1051" -hooks ./DB2VDB2.dbhooks

Steps To Reproduce the Problem
1.- Run dx_get_db_env -d -backup
2.- Review backup_metadata_dsource.txt and backup_metadata_vdb.txt and check db2 commands.

Screenshots
Error for vdbs command:
Problem with starting job
Error: databaseAliasName->The field "databaseAliasName" is required.
Job wasn't defined. If there is no error on the screen, try with -debug flag to find a root cause.

Error for dsource:
Source database C76D105A not found
There were problems with dSource action. No job defined.

This is because DB2 dsources first need to create a sourceconfig object.

Version
Tested this with 2.4.14 and Delphix engine 6.0.13

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions