VSAM
This IBM Utility is used to perform many actions on a VSAM file include create them
What is IDCAMS?
1978 - We Are the Champions
Who is Queen?
This release introduced Unicode
What is V7?
Cairo
What is Egypt?
This is the release that the IMS catalog was first introduced
What is V12.1? (V12 is acceptable)
This command is used to load data into a VSAM Dataset
What is REPRO?
1971 - Signs
Who is the Five Man Electrical Band?
This release introduced Data Sharing
What is V4?
Mogadishu
What is Somolia?
IMS was created to inventory the large bill of materials for this major effort
Three access modes are available for KSDS datasets - Sequential, Random and this mode
What is Dynamic?
1976 - Play that Funky Music
Who is Wild Cherry?
This release was codenamed Sequoia?
What is V11?
Nairobi
What is Kenya?
This release was when HALDBs were first introduced
What is V7?
This command is used to check the structural integrity of a key-sequenced data set cluster
What is EXAMINE?
1978 - The Wreck of the Edmund Fitzgerald
Who is Gordan Lightfoot?
This release introduced online schema changes
What is V8?
Monrovia
What is Liberia?
IMS was designed by IBM in partnership with Rockwell and this company in 1966
What is Caterpillar?
The four different types of VSAM datasets are Entry Sequenced Datasets (ESDS), Key Sequenced Datasets (KSDS), Relative Record Dataset (RRDS) and this type which is most often used by DB2
What is Linear Dataset (LDS)?
1973 - Frankenstein
Who is the Edgar Winter Group?
This release introduced declarative RI constraints
What is V2.1?
Rabat
What is Morocco?
The two types of Fast Path Databases are Data Entry Databases (DEDBs) and this type
What are Main Storage Databases (MSDBs)?