PJ39890: SUPPORT CREATING SQW EXECUTION SCHEMA WITHOUT DBADM AUTHORITY

IBM ISW-InterimFix-SQW_9.7.3.v20120719

APAR status

• Closed as program error.

Error description

• For usual usage, users executing the dataflow always have DBADM
  authorization, they can create schema IWSCHEMA${RESERVED/RUN_ID}
  successfully.  However, sometimes user is revoked the DBADM
  priviledge for security cosideration. For such scenario, our
  flow can't be executed as it will first try to create temporary
  schema.
  But in theory, the schema can be created by,
  1. db2 set schema
  2. db2 create table
  So we need to support such customer's scenario by continuing
  flow execution even failed to create temporary schema
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users without DBADM AUTHORITY can not execute the data flow  *
  * successfully                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * For usual usage, users executing the dataflow always have    *
  * DBADM                                                        *
  * authorization, they can create temporary schema              *
  * successfully.                                                *
  * However, sometimes user is revoked the DBADM                 *
  * priviledge for security cosideration. For such scenario, our *
  * flow can't be executed as it will first try to create        *
  * temporary                                                    *
  * schema.                                                      *
  * But in theory, the schema can be created by,                 *
  * 1. db2 set schema                                            *
  * 2. db2 create table                                          *
  * So we need to support such customer's scenario by continuing *
  * flow execution even failed to create temporary schema        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to InfoSphere Warehouse 9.7.7 or later release       *
  ****************************************************************
  

Problem conclusion

• Applying SQW_9.7.3.v20120118, the flow can be executed
  successfully. And this error will recorded as warning mesage in
  log files.
  

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:

Fix information

• Fixed component name

  DWE SQL WHSE TO

• Fixed component ID

  5724DWESQ

Applicable component levels

• R973 PSY

     UP