repotools -createTables SQL error DB2 zOS
![]()
Andy Phillipson (104●3●14●18)
| asked Jul 13 '12, 9:36 p.m.
JAZZ DEVELOPER edited Jul 13 '12, 9:36 p.m.
I'm attempting to create the tables for the JTS database by running "repotools-jts -createTables" per Creating DB2 for z/OS database tables remotely. I completed all the pre-reqs (though not ruling out that I could have made a mistake someplace). This command fails (see log output below). What could be wrong?
Application server: Windows Server 2008 Database: DB2 on z/OS v10.1 RTC 4.0 Log output from repotools: 2012-07-13 18:48:29,998 Repo Tools 2012-07-13 18:48:29,998 java.version=1.6.0 2012-07-13 18:48:29,998 java.runtime.version=pwa6460sr10fp1-20120321_01 (SR10 FP1) |
4 answers
![]()
This Wiki article suggests you can in step 6
https://jazz.net/wiki/bin/view/Main/ReducedDB2Privileges |
![]()
Trying the obvious first ........ I just googled sqlcode=-164 and it says the following
authorization-id
DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION
qualifier-name
Where authid would be "JAZZPROD" and qualifier name would be "JPJTS_COMMON_SNAPSHOT.
Details can be found here. Hopefully this gives you something to go on
|
![]()
I was just off doing the same... thanks! Question though...
We don't want to allow the db user (JAZZPROD) to have SYSADM or DBADM permissions permanently. Can we safely provide the perms, execute repotools, and remove these perms? or does the db user require these perms for long-term runtime operations (aside from db upgrades etc)? |
![]()
Someone more intimate with the database aspect of the products will have to answer that question specifically.
However.... reaching way back into my dark distant past ..... can't you have a user that has been granted the correct authority at the tablespace level (create table etc etc). I think things has change a bit since I use to dabble in the DB2 admin side of things and perhaps there are different level... maybe there is a schema level you can grant authority at or something like that. ..... ANyway, this may give you something to play around with while you wait for an answer to your question about removing DBADM after repotool execution.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.