Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Redirect
visiblefalse
locationTECHNOS:SQL Analyzer - To do transition from the CAST AIP Db2 Analyzer to the SQL Analyzer extension


Panel

On this page:

Table of Contents
maxLevel1

Target audience:

Users of the SQL Analyzer extension.

...

This step explains how to generate the DDL from the DB2 database that will be fed into the CAST Delivery Manager Tool for analysis with the SQL Analyzer extension.  

Info
  • See also SQL Analyzer - generate DDL for a DB2 database for more information.
  • Note that the db2look tool is only available with an installation of a DB2 UDB instance. If you are using a DB2 z/OS instance, CAST recommends the use of the RC/Migrator tool which is part of the CA Database Management Solution for DB2 for Z/OS, Version 19. There are no instructions provided for this.

db2look command line

The tool used to achieve this is the the db2look tool provided  provided with the DB2 UDB server (see the full documentation for the tool here: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002051.html).

Info
See also SQL Analyzer - generate DDL for a DB2 database for more information.

db2look command line

 This example will generate an .SQL file containing the DDL for the CASTPUBS schema on the TEST database accessed with the db2admin/db2admin credentials:

...