Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query on BLSR

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Nileshkul

New User


Joined: 09 May 2016
Posts: 9
Location: India

PostPosted: Sat Aug 13, 2016 5:18 am    Post subject: Query on BLSR
Reply with quote

Please help with a query on BLSR:
I have a 20 threads for a job running paralally. A VSAM file which has 20 copies used by 20 threads. That means each thread has dedicated copy file of VSAM.
NOW the same VSAM is using BLSR in all threads which I doubt why. Because each thread has it's own copy, there us no sharing of vsam copy file across threads or any other job. Will BLSR degrade performance in this case, Please suggest.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Sat Aug 13, 2016 8:05 am    Post subject:
Reply with quote

BLSR improves performances for random access of VSAM data sets (you do NOT have a "VSAM file" -- you have a VSAM data set; the only "files" on z/OS are on tape or in Unix System Services and neither of these can be VSAM). If the data set is being read sequentially, then BLSR won't improve performance (and may make it worse). Notice that the number of threads does NOT factor into whether or not BLSR can improve performance -- only the amount of sequential versus random processing.
Back to top
View user's profile Send private message
Nileshkul

New User


Joined: 09 May 2016
Posts: 9
Location: India

PostPosted: Sun Aug 14, 2016 12:48 am    Post subject: Thanks
Reply with quote

Got it now, thanks
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts SQL Query optimization. arunsoods DB2 12 Sun Sep 04, 2016 6:27 am
No new posts Require help in DB2 Query Shruti Takkar DB2 3 Wed Aug 03, 2016 10:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us