-- Licensed Materials - Property of IBM -- -- BI and PM: CM -- -- (C) Copyright IBM Corp. 2008, 2019 -- -- US Government Users Restricted Rights - Use, duplication or disclosure -- restricted by GSA ADP Schedule Contract with IBM Corp. -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved. -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated). --This script creates the tablespaces for -- IBM DB2 for z/OS -- -- Modifications: -- -- 1) Changed CMSCRIPT_DATABASE to the desired database name. -- 2) Changed CMSCRIPT_USERNAME to the desired user name. -- 3) Replace CMSCRIPT_CS_ID with a unique content store ID, no more than two character long, with literal first character -- 4) Replace CMSCRIPT_TABLESPACE with a name of the tablespace, allocated for base tables ------------------------------------------------------------------------ --*GRANT of Tablespaces' USE RIGHTS -- ------------------------------------------------------------------------ GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCMSCRIPT_TABLESPACE TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML001 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML002 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML003 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML004 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML005 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML006 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML007 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML008 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML009 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML010 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML011 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML012 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML013 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML014 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML015 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML016 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML017 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML018 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML019 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML020 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML021 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML022 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML023 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML024 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML025 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML026 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML027 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML028 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML029 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML030 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML031 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML032 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML033 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML034 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML035 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML036 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML037 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML038 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML039 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML040 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML041 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML042 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML043 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML044 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML045 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML046 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML047 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML048 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML049 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML050 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML051 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML052 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML053 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML054 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML055 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML056 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML057 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML058 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML059 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML060 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML061 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML062 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML063 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML064 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML065 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML066 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML067 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML068 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML069 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML070 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML071 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML072 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML073 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML074 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML075 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML076 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML077 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML078 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML079 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML080 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML081 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML082 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML083 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML084 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML085 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML086 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML087 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML088 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML089 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML090 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML091 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML092 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML093 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML094 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML095 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML096 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML097 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML098 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML099 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML100 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML102 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML103 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML104 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML105 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML106 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML107 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML108 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML109 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML110 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML111 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML112 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML113 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML114 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML115 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML116 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML117 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML118 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML119 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML120 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML121 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML122 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML123 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML124 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML125 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML126 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML127 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML128 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML129 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML130 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML131 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML132 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML133 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML134 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML135 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML136 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML137 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML138 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML139 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML140 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML141 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML142 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML143 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML144 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML145 TO CMSCRIPT_USERNAME; GRANT USE OF TABLESPACE CMSCRIPT_DATABASE.CMSCRIPT_CS_IDCML146 TO CMSCRIPT_USERNAME; commit;