Home Explore Help
Register Sign In
GlobalCube
/
analytics
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 0a263e0aff
Branches Tags
analytics
/
configuration
/
schemas
/
logging
/
db2
/
LS_dbUpgrade102_002-to-102_003_db2.sql

LS_dbUpgrade102_002-to-102_003_db2.sql 789 B
History Raw

1234567891011121314151617181920 
  1. -- Licensed Materials - Property of IBM
    2. 

  2. -- IBM Cognos Products: ccllogging
    3. 

  3. -- (C) Copyright IBM Corp. 2013
    4. 

  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 
    5. 

  5. 

  6. alter table COGIPF_PARAMETER add COGIPF_LOCALTIMESTAMP timestamp with default NULL
    7. 

  7. 

  8. Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')
    9. 

  9. 

  10. alter table COGIPF_PARAMETER add COGIPF_SESSIONID varchar (255) default ''
    11. 

  11. 

  12. Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')
    13. 

  13. 

  14. alter table COGIPF_PARAMETER add COGIPF_SUBREQUESTID varchar (255) default ''
    15. 

  15. 

  16. Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')
    17. 

  17. 

  18. alter table COGIPF_PARAMETER add COGIPF_PARAMETER_VALUE_BLOB clob(1G) with default NULL
    19. 

  19. 

  20. Call Sysproc.admin_cmd('REORG table COGIPF_PARAMETER')
    21.