-
US Citizen
-
Green Card
-
EAD (OPT/CPT/GC/H4)
-
H1B Work Permit
-
UG :- - Not Required
-
PG :- - Not Required
-
No of position :- ( 1 )
-
Post :- 19th Aug 2022
- 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