JR31027: DB2LOOK DOES NOT GENERATE COLUMN LEVEL DDL WHEN USING THE -T OPTION.

APAR status

• Closed as program error.

Error description

• As of current in V82, V91 and V95. db2look has an option of -t
  which generates ddls at the table level.  But -t option does not
  generate ddls of the column level changes. To Generate ddl at
  the column, now ddl for the whole database has to be genrated.
  For Ex.
  db2 "create table sample(id int, name varchar(20), place
  varchar(20))"
  DB20000I  The SQL command completed successfully.
  db2 "grant update(name) on table "rajarase"."sample" to user
  "sahanant""      ---> column level grant
  DB20000I  The SQL command completed successfully.
  db2 "create sam123(number int, color varchar(20))"
  DB20000I  The SQL command completed successfully.
  db2 "grant update on table "rajarase"."sam123" to user
  "sahanant"                  --> table level grant
  DB20000I  The SQL command completed successfully.
  ...............
  db2look -d test -a -t sam123 -x
  GRANT UPDATE ON TABLE "RAJARASE"."SAM123" TO USER "SAHANANT" ;
  --> it has generated table level grant
  COMMIT WORK;
  CONNECT RESET;
  TERMINATE;
  .................
  now try with -e and -x option
  
  (rajarase@achilles) /home/rajarase $ db2look -d test -e -x
  --------------------------------------------
  -- Authorization Statements on Column
  --------------------------------------------
  GRANT UPDATE (NAME) ON "RAJARASE"."SAMPLE" TO USER "SAHANANT";
  --> generated the same grant statement
  COMMIT WORK;
  CONNECT RESET;
  TERMINATE;
  

Local fix

• As per current functionality, generate the DDL for the whole
  database to generate ddls at the column level.
  

Problem summary

• DB2LOOK DOES NOT GENERATE COLUMN LEVEL DDL WHEN USING THE -T
  OPTION.
  

Problem conclusion

• V81 FP18
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  JR31063 JR31064

Fix information

• Fixed component name

  DB2 UDB WSUE WI

• Fixed component ID

  5765F4301

Applicable component levels

• R820 PSY

     UP