Hi all..., Nowadays many of the companies asking for
IMS/DB , actually i hav learned mainframes but i dont have
any knowledge on IMS/DB. it will be a great help if any one
suggest me whr i can learn it ( in any institute).
Answer Posted / sap
IMS is a hiberarchical database managerment system.
It mainly contains two components, IMS DB and IMS TM.
From the function of the two componets, we can understand
as this:
IMS DB: Hiberarchical database. (Using DL/I manipulate
data.)
DB2/ORICALE/MySql : Relational database.( Using SQL
manipulate data.)
IMS TM is similar to CICS (Customer Information Control
System), which is used to deal with transaction.(
Transaction is devided into several types, we can
understand it is a interactive conversion. We draw money
from ATM can be a transaction.)
IMS has a long history, but he is still energiable. At the
same time, IMS has the two components of itself, can
realize the information managerment completely, which
increase the capability. In addition, the maintance cost is
very low.
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What information does a psb contain?
Explain the maximum number of segment types allowed for a single database?
What is meant by mpp mode?
What is psbgen process?
Explain dbdgen process?
What is acbgen process?
Portfolio analysis application is an example of?
What are the advantages of a hierarchical database?
What is the advantage of creating the acbs well ahead of time?
how to create a changeman read only audit and update only audit Specifications for the Read only Audit 1) Read HFFD database unqualified. 2) Read FDRT, FDDM, FDAP segments. If FDAP-APP-STS is ‘2’ read the FDAV segment and get the FDAV segment which has FDAV-APV-OPTION as ‘X’ If FDAP-APP-STS is ‘5’ read the HFAC database. Read the ACRT segment qualified based on the key obtained from the FDAP segment from HFFD database. Conditions for writing into output file: a. App Type should be NEWR b. App Status should be 1, 2 & 5. c. Write 50 records per app status. For e.g. first 50 records for App status 1, 2 & 5 each The output file should contain the following fields from the database FDRT-COMP-CTRY-CODE X(03). FDRT-CUST-ID-NUM X(10) FDDM-DEM-SEQ-NUM X(01) FDAP-APP-SEQ X(02) FDAP-JNT-IND X(01) FDAP-APP-STS X(01) FDAV-APV-OPTION X(01) FDAV-APV-DT X(06) FDAV-APV-AMT X(07) ACRT-ACCT-NUM X(06) ACRT-SEG-BUS-TYPE X(02) ACRT-NM1-LAST X(19) ACRT-NM1-SS X(09) ACRT-NM1-1ST X(12) ACRT-NM1-INIT X(01) ACRT-NM1-SFX X(03) ACRT-NM1-TITLE X(02) PSB – DVAN2BMP In case you get a GE for any of the conditions, write to output file along with the details of the database segment which was not found. We need to complete this whole process by tomorrow. Run the audit in DLI mode. 2) Sort the output file created in step 1 on Cust ID, Dem Seq & App Seq. Specifications for the Update Audit 3) Take the output of step 2 as input for an update audit. Details are as follows: Read each record & check the app status. If app status is less than 2 then update the FDAP-NEW- MONEY-ENT to $25000.00 PSB - AUDBMPJ The job would be a BMP job. The test job would be run in IMSE region. Note - The proc (which will be called by the job) and the job should also be present in the change-man package itself. You’ll have a test job in your PDS along with overrides to execute the program in test regions. The job would be a DLI job. The test job would be run in IMSE region. It’ll have the following steps. 1) Delete-define output and error files. 2) Use a copybook for the output layout.
Explain psbgen process?
What is the maximum of key fields and search fields allowed in a segment?
What is a segment in ims?
What do you mean by hierarchical database?
Explain the maximum number of pcbs allowed in a psb?