COBOL : Comparing SQL pre-compiler data names and DB2 ddl using PBA(Bind Analyzer)

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

PBA(Bind Analyzer for Db2) was implemented recently. In the Endeavor environment, COBOL programs are promoted and most of them have DB2 SQL statements. There is a need to compare and synchronize the db2 data names and their characteristics as they are produced by DB2 pre-compiler with the DB2 DDL information (SYSIBM.SYSCOLUMNS). Can the above comparison be executed using the bind analyzer for DB2 ?

 

 

Environment

Release : 20.0

Resolution

PBA does not currently have a capability to compare the DBRM host variables to the column definition in the catalog. However, PBA does have the ability to compare the precompile DBRM with the bound package DBRM in the Db2 catalog to detect any differences in the SQL and/or host variable information. That is the extent of the catalog comparison reporting that is currently supported.