LS_dbUpgrade0_015-to-0_016_db2.sql 1.1 KB

12345678910111213141516171819202122232425262728
  1. -- Licensed Materials - Property of IBM
  2. -- IBM Cognos Products: ccllogging
  3. -- (C) Copyright IBM Corp. 2005, 2010
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. create table COGIPF_MIGRATION (
  6. COGIPF_HOST_IPADDR varchar (15),
  7. COGIPF_HOST_PORT integer,
  8. COGIPF_PROC_ID integer,
  9. COGIPF_LOCALTIMESTAMP timestamp,
  10. COGIPF_TIMEZONE_OFFSET integer,
  11. COGIPF_SESSIONID varchar (255),
  12. COGIPF_REQUESTID varchar (255) not null,
  13. COGIPF_STEPID varchar (255),
  14. COGIPF_SUBREQUESTID varchar (255),
  15. COGIPF_THREADID varchar (255),
  16. COGIPF_COMPONENTID varchar (64),
  17. COGIPF_BUILDNUMBER integer,
  18. COGIPF_LOG_LEVEL integer,
  19. COGIPF_OPERATION varchar (128),
  20. COGIPF_TARGET_TYPE varchar (255),
  21. COGIPF_TARGET_PATH varchar (1024),
  22. COGIPF_TARGET_NAME varchar (512),
  23. COGIPF_STATUS varchar (255),
  24. COGIPF_DETAILS varchar (2000),
  25. COGIPF_PACKAGE varchar (1024),
  26. COGIPF_MODEL varchar (512)
  27. )