DBA Interview Questions and Answers – DB2 Security Management

DBA Interview Questions and Answers for a DB2 on Linux , Unix and Windows DBA focusing on DB2 Security Management Read the DB2 Security Notes for checklists on DB2 Authentication Types,Authorities,DB2 Privileges,Object Privileges,GRANT & REVOKE usages What is the purpose of Authorities ? Authorities express a set of rights to perform high level Administrative functions Which file contains the sysmaint_group parameter ? DB2 Database Manager Configuration file. To view the parameter values is the command : Get dbm cfg To update the sysmaint_group value. Use the command: Update dbm cfg using symaint_group Name at least 2 authorities and privileges... Read more →

Linux GET command returning a web page by default

I typed the Linux Command GET DBM CFG into my Putty console – rather than db2 GET DBM CFG and web page code was returned . That’s interesting! The GET program is used to send requests to www servers. There are various switches , such as : -b This URI will be used as the base URI for resolving all relative URIs given as argument. The interesting discovery is that by issuing a command such as : # GET DB2 , it will default by requesting the default page of db2.org , or if requesting # GET SQL , it... Read more →

DBA Interview Question and Answers for DB2

Welcome to a series of posts on DBA Interview Questions and Answers for a DB2 on Linux , Unix and Windows Assist me by commenting , supplying feedback and making suggestions on DBA Interview Question and Answers for DB2 DB2 DBA Interview Questions and Answers – Server Operations Future Posts DB2 DBA Interview Questions and Answers – Data Management DB2 DBA Interview Questions and Answers – DB2 monitoring DB2 DBA Interview Questions and Answers – DB2 utilities and maintenance DB2 DBA Interview Questions and Answers – DB2 High Availability and DR DB2 DBA Interview Questions and Answers – DB2 Security... Read more →

DBA Interview Questions and Answers – DB2 Server Operations

DBA Interview Questions and Answers for a DB2 on Linux , Unix and Windows DBA focusing on Server Operations Describe the DB2 Database Configuration Parameter – SORTHEAP ? Defines the maximum number of memory pages used for private sorts or the maximum number of shared memory pages to be used for shared ports. In a private sort , the agent private memory is affected. If it’s a shared sort then the database shared memory is influenced. An example of using SORTHEAP, is if an application creates regular large sorts Can memory information be obtained by the GET DB CFG FOR... Read more →

DB2 table reorg and table truncate

I received a db2 Tivoli monitoring message , warning of disk space issues. TRV_DB2_UsedSpace_Minor db2inst1:myserver:UD Fri May 13 16:57:21 2011 Description I executed a Linux find command find /db2inst1 -type f -ls | sort -k 7 -r -n | head -10 The 10 biggest files in the directory /db2inst1 This pointed to the Datawarehouse 21141913600 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00132.DAT 18296864768 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00293.DAT 18238668800 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00231.DAT 8841330688 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00293.INX 5305532416 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00299.DAT 4767088640 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00301.DAT 4516478976 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00301.INX 4393009152 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00299.INX 3483893760 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00287.DAT 3235643392 /dbinst1/db2inst1/NODE0000/SQL00002/itmreg8k/SQL00012.DAT To be on the safe side I checked out the growth stats of the other databases – growth rates . They looked OK db2 "CALL GET_DBSIZE_INFO... Read more →