Number of questions: 58
Time allowed in minutes: 90
Required passing score: 65%
Languages: English
Recommended Prerequisites
Working knowledge of DB2 z/OS in a system administration capacity
Support of DB2 on a z/OS environment
Knowledge of z/OS architecture
Knowledge of Subsystem Parameters (DSNZPARMs)
Knowledge of DB2 data sharing environment
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments.
Section 1 – Installation and Migration (20%)
Given a scenario, demonstrate knowledge of the installation/migration plan process
Ability to identify additional environments necessary (WLM, Unix system services, XML schema support, RACF or equivalent, SMS)
Given a scenario, describe how to execute the installation/migration plan
Evaluate appropriate subsystem parameter (DSNZPARM) settings
Evaluate appropriate migration to extended RBA/LRSN tasks
Section 2 – Security and Auditing (12%)
Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources (implementing external security only)
Knowledge of various System authorities
Support for distributed identities, connection level security enforcement
Program authorization and masking including enhancements
Describe auditing techniques (policies)
Describe role-based security and the advantage of deploying it (trusted context)
Section 3 – System Operation and Maintenance (17%)
Describe how to use and manage DB2 components and processes (adminitrative task scheduler) (REPAIR, STOSPACE, DSNJU003, DSN1COMP)
Demonstrate knowledge of DB2 commands
Given a scenario, describe how to monitor and control DB2 threads
Knowledge of DB2 data sharing system operation and maintenance
Knowledge of distributed functionality
Section 4 – Backup and Recovery (17%)
Demonstrate knowledge of advanced backup and recovery (system level, data set level, undo, redo, backup, flash copy, DSS, HSM, DSNJU004, DSN1COPY, DSN1LOGP, DSN1PRNT, Extended RBA, etc.)
Given a scenario, describe how to recover from system failures (restart, conditional restart)
Describe the process for disaster recovery
Describe DB2 data sharing recovery scenarios
Knowledge of consideration/impact of extended and non-extended RBA/LRSN tasks
Section 5 – Performance and Tuning (22%)
Given a scenario, analyze performance
Demonstrate knowledge of how buffer pools and system parameters (DSNZPARMs) can affect performance – concurrency
Demonstrate knowledge of persistance threads (bind parameters, reallocate, protected threads)
Demonstrate knowledge of statistics, tools, and traces used for monitoring (trace definitions)
Given a scenario, describe techniques to achieve efficient use of memory (flash memory, large buffer pools) Statement Cache (Dynamic, Static, EDM Pool)
Demonstrate knowledge of workload manager (WLM) settings for DB2
Knowledge of RUNSTATS (autonomic, manual, RTS, and feedback)
Knowledge of Reorg in the context of system tuning and performance (system level settings, subsystem parameters, reduction of indirect references)
Knowledge of specialty engines and how they affect performance (ziips)
Section 6 – Troubleshooting (13%)
Given a scenario, describe which documentation can be used to solve a problem
Demonstrate knowledge of DB2 commands and traces for troubleshooting
Describe how to identify distributed threads
Demonstrate knowledge of diagnostic utilities (REPAIR, DSNJU003, DSN1CHKR)
Given a scenario, identify and resolve DB2 data sharing problems
IBM Certified System Administrator – DB2 11 for z/OS
Job Role Description / Target Audience
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, tune and secure DB2 for z/OS environments.
Recommended Prerequisite Skills
Working knowledge of DB2 z/OS in a system administration capacity
Support of DB2 on a z/OS environment
Knowledge of z/OS architecture
Knowledge of Subsystem Parameters (DSNZPARMs)
Knowledge of DB2 data sharing environment
QUESTION 1
In complex DB2 recovery scenarios, it is important to understand the scope of which objects
require recovery.
Which DB2 utility provides a list of the names of all table spaces in the table space set that is
specified and a list of all the tables in those table spaces?
A. CHECK
B. REPORT
C. QUIESCE
D. RECOVER
Answer: D
Reference:https://www-
01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_re
portsyntax.dita
QUESTION 2
The -ALTER UTILITY command changes the values of certain parameters of a utility.
Which two utilities can this command be issued against?
A. COPY
B. REORG
C. MODIFY
D. REBUILD
E. RECOVER
Answer: B,D
Reference:https://www-
01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.admin/src/tpc/db2z_
monitronlineutilities.dita
QUESTION 3
You execute the following SQL against the CDB (Communications Database) of your DB2
subsystem:
INSERT INTO SYSIBM.IPNAMES
(UNKNAME.SECURITY_OUT.USERNAMES,IBMREQD.IPADDR) VALUES (‘REMOTEDB’. ‘P\ ‘O’.
‘N’, *123.34.45.56′);
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES (‘REMOTEDB’,
‘123.34.45.56’, *N’);
INSERT INTO SYSIBM.IPLIST (LINKNAMEJPADDRJBMREQD) VALUES C REMOTEDB’,
‘123.34.45.57’, ‘N’);
INSERT INTO SYSIBM.USERNAMES
(TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORD,IBMREQD) VALUES (T, ‘USER1’.
‘USER2\ “, ,PWD2,1 *N’);
INSERT INTO SYSIBM.USERNAMES
(TYPE,AUTHID.LINKNAME,NEWAUTHID.PASSWORDJBMREQD) VALUES (‘O’, ‘USER1’.
‘USER3′, *’, ‘PWD3’, ‘N’);
There is no trusted connection to REMOTEDB. USER1 issues a query addressing remote data
source REMOTEDB on your DB2 subsystem.
Which authorization id will be used on the remote data source REMOTEDB?
A. USER1
B. USER2
C. USER3
D. USER4
Answer: A
Explanation:
QUESTION 4
Which combination of subsystem parameter values will enable connection pooling for idle
distributed database access threads?
A. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT = MAXDBAT.
B. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT < MAXDBAT.
C. Specify subsystem parameter CMTSTAT = ACTIVE and set CONDBAT > MAXDBAT.
D. Specify subsystem parameter CMTSTAT = INACTIVE and set CONDBAT >MAXDBAT.
Answer: C
Reference:https://db2onlinehandbook.com/?p=1263
QUESTION 5
You wish to set the threshold at which data in the class castout queue is cast out to disk for group
buffer pool GBP10. You want the threshold to be 1000 pages.
Which parameter setting in the command -ALTER GBPOOL(GBP10) will accomplish this?
A. GBPOOLT(10)
B. CLASST(0.1000)
C. CLASST(10.1000)
D. GBPCHKPT(1000)
Answer: A
Explanation:
Click here to view complete Q&A of C2090-317 exam
Certkingdom Review
Best IBM C2090-317 Certification, IBM C2090-317 Training at certkingdom.com