Where would you find information about the type of database
authority held by the user?
- 2 Answers
- 4744 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sreesh
The informartion can be obtained from catalog table
SYSIB.SYSDBAUTH.
Following authories are kept on DB level in SYSIB.SYSDBAUTH.
1) CREATETABAUTH
2) CREATETSAUTH
3) DBADMAUTH
4) DBCTRLAUTH
5) DBMAINTAUTH
6) ISPLAYDBAUTH
7) LOADAUTH
8) REORGAUTH
9) RECOVERDBAUTH
10)REPAIRAUTH
11)STARTDBAUTH
12)STATSAUTH
13)STOPAUTH
| Is This Answer Correct ? | 1 Yes | 0 No |
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
How do you select a row using indexes in db2?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
What is a result table?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Explain in brief how does db2 determine what lock-size to use?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Before you give the explain statement, what are the prerogatives?
What are the various isolation levels possible?
How can you classify the locks in db2?
What is a bind in db2?
COBOL 
