| View previous topic :: View next topic |
| Author |
Message |
Vidhyadhar
Beginner
Joined: 19 Oct 2004
Posts: 1
Topics: 1
|
 Posted: Tue Oct 19, 2004 8:31 am Post subject: Regarding Keyed read (qualified IMS DB calls) |
 |
|
Hi all,
Can anyone please provide me an approximate retrievel time for a full qualified IMS DB call. I need this information to design an application program to read a IMS DB with large number of records.(whether to go for IMS DB qualified call or dump the IMS DB into an FLAT FILE and convert into an VSAM file...this sort of decision has to be taken)
thanks in advance!! |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue Oct 19, 2004 11:00 am Post subject: |
|
|
Vidhyadhar,
You cannot really relate retireval times of shop to another. Every shop is different and the databases are different. The simplest way is to run a test your self
code a sql statement for timestamp before and after the ims call and subtract the time difference. This will just give you the elapsed time for the Ims call.
| Code: |
EXEC SQL
SET :WS-BEFORE-TIMESTAMP = CURRENT TIMESTAMP
END-EXEC
CALL 'CBLTDLI' USING FUNC-GN
IMSDB-PCB1
DB-SEGMENT
QSSA-FORDB.
EXEC SQL
SET :WS-AFTER-TIMESTAMP = CURRENT TIMESTAMP
END-EXEC
|
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
