Home > Ask the Data Center Experts > CICS Questions & Answers > Getting BLOBs from DB2
Ask The Data Center Expert: Questions & Answers
EMAIL THIS

Getting BLOBs from DB2

Robert Crawford EXPERT RESPONSE FROM: Robert Crawford

Pose a Question
Other Data Center Categories
Meet all Data Center Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 25 November 2003
We are using CICS WebSupport to get BLOBs from DB2 or tape and show the picture in a browser. The performance is great and the availability is very high but we are hitting two problems from the same origin. Our current max picture is 3Mb and we have a need to go to 50Mb. DB2 is able to handle this using BLOB LOCATORS. I can pass this locator to CICS WS, but with the CREATE DOCUMENT I need to reference a WS-field.

My questions are:

1. Can I use "outside CICS pointers" instead of WS fields in CICS WS CREATE DOCUMENT?

2. If I cannot use pointers, how do I use a CICS GETMAIN in relation to CICS WS. And, how do I bypass the 16Mb COBOL working storage limit?

All this to minimize the storage required to run CICS. Currently we use 280M with a 3Mb DOCUMENT field. If we would go to a 15 Mb DOCUMENT field we would need 1,4Gb. TIA.

>
EXPERT RESPONSE
I suggest that you alter your logic and use XC DOC INSERT to add in this BLOB into the document. This can cope with a full words worth of data. However I cannot say how much internal CICS storage will be used by this operation. If you have got back a pointer from the DB2 operation, then you can just use it in the command and all should be well (please get rid of the DB2 area as soon as possible, if it's that large!).

I confess to being slightly surprised that you want to use CICS to service such a large item but it should work OK. Raise an APAR if it doesn't but do ensure that the CICS storage definitions in the SIT are big enough to cope.

Robert Harris
Inventor
CICS Technical Strategist -- CICS expert at Search390.com

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
CICS
Which MQ Queue is related with which CICS transaction?
Can a program use IXLLIST macros in CICS?
VSAM files in CICS -- Batch report help
Reading VSAM data from different LPARs
Finding executed statements in CICS
Submitting a batch job from CICS
Automating FTP transfers to AIX
FTP a dataset from MVS to Linux
Mainframe FTP - A simple check
Failed arithmetic operations on CICS programs written in C

CICS Newsletter
Run CICS in batch to beat a shrinking batch window
Ensuring CICS security with the Web Services Security standard
Use DFHLS2WS to expose CICS applications as a Web service
Using IBM IPCS to battle software bugs
CICS and Web services: Ready to go
Using External Call Interface (EXCI) to access CICS
Using CICS event monitoring points (EMPs) for tuning and debugging
Implementing CICS managed data tables
Taking advantage of the CICS workload dispatch ratio
CICS 3270 bridge tutorial, part 3: How to start and end a conversation

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Building Green Data Centers
HomeNewsTopicsITKnowledge ExchangeTipsBlogsMultimediaWhite PapersEvents
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts