i try to run in batch mode the create repository
I found a lot of these error
I replaced the real instance owner id with DB2_INSTANCE_OWNER
CREATE OR REPLACE VIEW BOTTLE_LOCK_WAIT AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleLockWait") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_LOCK_WAIT". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_LOG_SPACE AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleLogSpace") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_LOG_SPACE". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_MEMORY AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleMemory") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_MEMORY". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_NUM_LOCKS AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleNumLocks") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_NUM_LOCKS". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_QUERY_COST AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleQueryCost") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_QUERY_COST". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_ROWS_MOD AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleRowsMod") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_ROWS_MOD". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_ROWS_READ AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleRowsRead") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_ROWS_READ". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_ROWS_RETURNED AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleRowsReturned") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_ROWS_RETURNED". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_SORT_OVERFLOWS AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleSortOverflows") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object:
"IBMCONSOLE.BOTTLE_SORT_OVERFLOWS". SQLSTATE=42501
CREATE OR REPLACE VIEW BOTTLE_SORTS AS WITH ALL_DELTA AS ( SELECT LAG(DBCONN_INT) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_DBCONN_INT, DBCONN_INT, LAG(COLLECTED) OVER (ORDER BY DBCONN_INT, COLLECTED) AS PREV_COLLECTED, COLLECTED, APPLICATION_HANDLE, UOW_ID, RESOURCE_VALUE, AVG_WO_MAX, APPLICATION_NAME, SESSION_AUTH_ID, WORKLOAD_NAME FROM "bottleSorts") SELECT AD.DBCONN_INT, DB.DBCONN_ID AS DBCONN_ID, AD.PREV_COLLECTED, AD.COLLECTED, (CAST(((( JULIAN_DAY(AD.COLLECTED) - JULIAN_DAY(AD.PREV_COLLECTED)) * BIGINT(86400)) + (( EXTRACT(HOUR FROM AD.COLLECTED) - EXTRACT(HOUR FROM AD.PREV_COLLECTED)) * 60 * BIGINT(60)) + (( EXTRACT(MINUTE FROM AD.COLLECTED) - EXTRACT(MINUTE FROM AD.PREV_COLLECTED)) * BIGINT(60)) ) AS BIGINT) * 1000) + CAST((( EXTRACT(SECOND FROM AD.COLLECTED) - EXTRACT(SECOND FROM AD.PREV_COLLECTED)) * BIGINT(1000)) AS BIGINT) AS DELTA_MSEC, AD.APPLICATION_HANDLE, AD.UOW_ID, AD.RESOURCE_VALUE, AD.AVG_WO_MAX, AD.APPLICATION_NAME, AD.SESSION_AUTH_ID, AD.WORKLOAD_NAME FROM ALL_DELTA AD JOIN RTMON_MAP_DBCONN DB ON AD.DBCONN_INT = DB.DBCONN_INT WHERE AD.PREV_DBCONN_INT = AD.DBCONN_INT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "DB2_INSTANCE_OWNER". Operation: "REPLACE VIEW". Object: "IBMCONSOLE.BOTTLE_SORTS".
SQLSTATE=42501
------------------------------
Roberto Mandolini
Value Transformation Services an IBM subsidiary
Roberto.Mandolini_V-TServices@it.ibm.comRome - ITALY
------------------------------
Original Message:
Sent: Thu June 25, 2020 03:20 AM
From: Roberto Mandolini
Subject: Error setting up db repository for DMC v3.1.2
I'm setting new repository for DMC 3.1.2 (totally new installation)
I received this error
Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements.
test connections work fine
I used this grants option before run the option of setting repository
GRANT CONNECT ON DATABASE TO USER MY_USER;
GRANT SQLADM ON DATABASE TO USER MY_USER;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO USER MY_USER;
GRANT CREATETAB ON DATABASE TO USER MY_USER;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO USER MY_USER;
GRANT IMPLICIT_SCHEMA ON DATABASE TO USER MY_USER;
GRANT USE OF TABLESPACE USERSPACE1 TO USER MY_USER;
GRANT CREATEIN,ALTERIN,DROPIN ON SCHEMA SYSTOOLS TO USER MY_USER;
GRANT EXECUTE ON PROCEDURE SYSIBM.SQLCAMESSAGECCSID TO USER MY_USER;
CREATE BUFFERPOOL BP4CONSOLE PAGESIZE 32K;
CREATE TABLESPACE TS4CONSOLE PAGESIZE 32K BUFFERPOOL BP4CONSOLE;
GRANT USE OF TABLESPACE TS4CONSOLE TO USER MY_USER;
CREATE TEMPORARY TABLESPACE TS4CONSOLE_TEMP PAGESIZE 32K BUFFERPOOL BP4CONSOLE;
I replaced the real user with my_user
Ho i can fix this error?
Thanks in advance fro support
------------------------------
Roberto Mandolini
Value Transformation Services an IBM subsidiary
Roberto.Mandolini_V-TServices@it.ibm.com
Rome - ITALY
------------------------------
#Db2