Mainframe IMS With DBA Very Urgent Requirement
Raj R
Title: Mainframe IMS With DBA
Location: Remote
Must Have: DBA
- Database Administration
· Knowledge of IMS database organization using access methods of VSAM and OSAM
· Full function database organization types
· HSAM, HISAM, SHISAM, HDAM, HIDAM, INDEX, GSAM
· Definition and use of LOGICAL databases
· HALDB (partitioned): PHDAM, PHIDAM, ILDS, PSINDEX, etc.
· Fast Path databases (DEDBs)
- Database Design and related utilities
· DBD source coding and DBDGEN
· PSBGEN source coding and PSBGEN
· How databases are processed using secondary indexes (PROCSEQ=)
· Correct usage of PROCOPT= to minimize database locking
· ACBGEN
· Online Change
· IMS commands related to ACB and FORMAT changes
· Coding and usage of IMS reorganization utilities (including IBM, BMC, CA), including: unload, prefix resolution, reload, prefix update, secondary index build, image copy, and pointer checker
· Support planned (disaster recovery) and unplanned (emergency) database recovery activities
· Knowledge of log archive and change accumulation utilities
· How to perform a log archive on demand
· Knowledge of IMS DB recovery utility
· How to use DBRC to generate JCL for forward recovery and point-in-time database recovery.
· Database monitoring
· Space management
· Database dataset space reporting for proactive outage avoidance.
· How to immediately fix an out of space condition for a VSAM database dataset
· Identification and resolution of performance issues
· Online tracing - Usage of IMS TRACE commands and associated utilities for spot monitoring of online program/transaction activity
· Extracting information from IMS logs using DFSERA10 and related utilities DFSUTR20 and DFSUTR30
· Use of DFSDDLT0 utility to access data
· Program/transaction monitoring – Familiarity with usage of IBM’s IMS performance Analyzer product is a plus
· Using DBRC to monitor database activity