C9050-548 IBM Certified Database Administrator – IBM IMS

Number of questions: 66
Number of questions to pass: 40
Time allowed: 90 mins
Status: Live

If you are knowledgeable with IBM IMS and are capable of performing the intermediate to advanced skills required in the day-to-day administration of IMS databases, you may benefit from this certification role.

Section 1 – Physical Design 24%
Demonstrate knowledge of hierarchical sequence
Demonstrate knowledge of data storage and retrieval options
Demonstrate knowledge of phyical design parameters
Demonstrate knowledge of VSAM and OSAM access methods
Demonstrate knowledge of database indexes
Demonstrate knowledge of buffer pools

Section 2 – DBRC 12%
Demonstrate knowledge of database registration
Demonstrate knowledge of DBRC management
Demonstrate knowledge of log archiving
Demonstrate knowledge of RECON datasets content
Demonstrate knowledge of definition of HALDB and non-recoverable databases

Section 3 – Utilities 10%
Demonstrate knowledge of on-line and off-line reorg
Demonstrate knowledge of recovery of IMS databases
Demonstrate knowledge of rebuilding indexes
Demonstrate knowledge of reorganization of databases including those with logical relations and indexes
Demonstrate knowledge of generation utilities

Section 4 – DL1 11%
Demonstrate knowledge of DFSDDLT0
Knowledge of command/database laguages
Knowledge of command codes
Demonstrate knowledge of application checkpointing
Demonstrate knowledge of contents of the PCB mask and I/O areas
Knowledge of metadata usage

Section 5 – Backup and Recovery 15%
Demonstrate knowledge of database backup options
Demonstrate knowledge of logging and log data sets
Demonstrate knowledge of database recovery
Demonstrate knowledge of log utilities and change acum for recovery

Section 6 – Operations 11%
Demonstrate knowledge of database commands
Demonstrate knowledge of database management
Demonstrate knowledge of fault tolerance
Demonstrate knowledge of physical design change implementation
Knowledge of DRD

Section 7 – Sysplex 6%
Knowledge of IMS database operation for implementation in a sysplex configuration
Demonstrate knowledge of coupling facility structures
Demonstrate knowledge of change accumulation
Demonstrate knowledge of lock management considerations

Section 8 – Troubleshooting 6%
Demonstrate ability to maneuver IMS documentation
Knowledge of problem determination tools
Demonstrate knowledge of contention issues
Demonstrate knowledge of performance tuning issues and resolutions

The sample test is designed to give the candidate an idea of the content and format of the questions that will be on the certification exam. Performance on the sample test is NOT an indicator of performance on the certification exam. This should not be considered an assessment too

Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.

Please note that all courses listed in this section are also offered as Instructor-Led Online (ILO) courses. The course number is slightly different – For example, course CM20 would be CMW20 for the ILO version.

Web Resource

IMS InfoCenter
Welcome to the IBM® Information Management Software for z/OS® Solutions Information Center, where you can find all the information that you need to install, configure, maintain, and use the following IBM products for managing your information on z/OS: DB2® for z/OS, IBM DB2 Tools, DB2 QMF™, IMS™, IBM IMS Tools, IMS Enterprise Suite, InfoSphere™ IMS Replication for z/OS, InfoSphere Warehouse, InfoSphere Replication Server for z/OS, and InfoSphere Data Event Publisher for z/OS.

PartnerWorld Code: 08007401
Replaces PW Code: Not Applicable

Status: Live
If you are knowledgeable with IBM IMS and are capable of performing the intermediate to advanced skills required in the day-to-day administration of IMS databases, you may benefit from this certification role.
Recommended Prerequisite Skills

IMS database organization
Basic functional components (DLI and DBRC)
Mainframe skills (JCL, VSAM, and z/OS general knowledge)
Data area definitions (Cobol copybook and PL/1 declaratives)
Basic programming knowledge
Basic assembler knowledge
Basic macro knowledge
Database concepts including Backup and Recovery processes and utilities

QUESTION: No : 1
How can you verify that a DB2 installation was successful?

A. Verification is performed by running the VERIFY INSTALL command.
B. Verification is completed by the DBA using the database verification toolkit.
C. Verification is automatically performed by the AUTQ_CONFIGURE feature.
D. Verification can be done by successfully creating a SAMPLE database and running SQL commands to
retrieve sample data.

Answer: D

QUESTION: No : 2
What does the table partitioning feature in DB2 allow you to do?

A. Table partitioning allows you to make smaller tables automatically from large tables, therebyincreasing
the performance of your DB2 database.
B. Table partitioning allows you to create very large tables that are divided across multiplestorage objects
and attach/detach large quantities of data quickly.
C. Table partitioning allows you to create result set tables from a join query, which automaticallysplits the
data into smaller chucks, thereby increasing the performance of your DB2 database.
D. Table partitioning is not a feature in DB2.

Answer: B

QUESTION: No : 3
Which of the following is required when implementing the IMS Data Capture Exit?

A. Modify PSBs.
B. Modify DBDs.
C. Change online and batch applications.
D. Start an MVS address space to catch the changes.

Answer: B

QUESTION: No : 4
What is the purpose of the XQuery builder tool included in DB2?

A. The XQuery builder tool allows you to query and retrieve data from external XML documents.
B. The XQuery builder tool builds well-formed XML documents that can be stored in a hierarchical form
within columns of a table.
C. The XQuery builder tool allows you to create queries against XML data.
D. The XQuery builder tool does not exist in DB2.

Answer: C

QUESTION: No : 5
What is the output of the Call Image Capture utility (DFSDLTRO)?

A. Trace of module entry/exit during call.
B. Database records retrieved by the program.
C. DFSDDLT0 control statements written to the log.
D. Call counts by type written in x’45’ statistics log records.

Answer: C

Click here to view complete Q&A of C9050-548 exam
Certkingdom Review, Certkingdom PDF Torrents