faq

> Describe the DB2 Database Configuration Parameter – SORTHEAP ?

A)  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 mydb SHOW DETAIL command?

A) Yes . View and Configure information for :

a)Self Tuning Memory (SELF_TUNING_MEM) – Indicates whether the memory tuner is ON or OFF

b)Size of database shared memory (DATABASE_MEMORY) – Details the shared memory amount reserved for the database shared memory region

c)Database Memory Threshold (DB_MEM_THRESH)  - Defines how the database manager manages excess unused database shared memory

> What authority should a user have to QUIESCE a DB2 database?

A) A login account must have either SYSADM or DB2ADM to QUIESCE a database. When the database is in a QUIESCE state –
the users with at least one of these criteria can access the database : SYSADM , SYSCTRL,SYSMAINT,DBADMN.  
The QUIESCE command allows administrative tasks to complete. When the administrative tasks are complete use UNQUIESCE to active the database

> To perform an operation against a different instance – which variable value do you change?

A) The environment variable “set DB2INSTANCE = [target_instance_name]”  allows you to perform a task on another Instance . The alternative is to ATTACH to another instance.

The DBINSTANCE variable can also be set at the session level


> Which DB2 configuration is used to set the maximum number of applications that can execute concurrently?
A) MAXCAGENTS. The parameter assists in managing the load on the system during high     concurrent application requests. The parameter is useful in managing in a shared     environment with limited memory and high levels of connections.

> To force an application to wait indefinitely to obtain a table lock , which database configuration parameter is used?

A) LOCKTIMEOUT. Assign a value to LOCKTIMEOUT , to detail the number of seconds an     application will wait to obtain a lock.

    To set LOCKTIMEOUT for an indefinite wait use  “-1” . The application will wait until a       lock is granted or a deadlock is present

 In contrast , assigning  “0”  , an application will not wait for locks.



>  To allow the DB2 Discovery utility  to see a database , what changes must be made?

A)  DAS server must be running and the DISCOVER configuration for DAS must be set to      KNOWN or SEARCH.

     When the DAS server is created the “discover” setting defaults to “search”

>  Where are changes made by Self-Tuning memory recorded?
A)  Memory tuning log files. By default they are stored in the stmmlog subdirectory.

     The log files display a summary of the resource demands for each memory consumer      for each tuning interval,

>  Which command starts an instance?

A)   The current DB2 Database Manager instance background processes can be started  by :       1) db2start or 2)START DATABASE MANAGER.

     To access a database , first start DB2 at the server level then connect to the database

>  What is the purpose of Authorities ?
A)  Authorities express a set of rights to perform high level Administrative functions

>  Which file contains the sysmaint_group parameter ?

A)   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  <my_group>


>  Which privilege grants a use all privileges on a VIEW?

A)  The CONTROL view privilege .Also allows all privileges (except CONTROL) to be      granted


>  Which privileges are required by a user to execute a stored procedure querying a        table?

A)   EXECUTE privilege on the stored procedure ; SELECT privilege on the table

>  Name two database objects where SELECT privilege is managed?

A)  Possible objects include : VIEWS,TABLES


>  Can I load a file of extension WSF ?   

 A ) NO. WSF with Import only.

>  Diff between import and load ?

   A) Load is faster than Import because Load does`t do logging .

> What is the difference between creating buffer pool with immediate option and default option ? 

  A) 

>If application team is contacting you telling the application is running very slow , what all things you will check out ?
 A)

•  Check for any transactions that are in lock wait state, list in doubt transactions.
•  Table DB snap shop, Application snapshot,sql snap shopt , cpu utilization,check is there any stale connection
• check if any background process is running there using list utilities
• Check the number of active connections to the DB server
• Force the application/transactions which are in lock wait state.