May 21, 2013

Using File Reference Variables

DB2 10 for z/OS introduced support for reading and writing LOB and/or XML data to files using file reference variables. File reference variables allow large LOB or XML values to be inserted from or selected into files rather than host variables. This saves memory because applications aren't holding large XML or LOB values.

A related benefit of using file reference variables is that you avoid storing large XML/LOB values in host application working storage. The data bypasses the application storage and travels directly to the client file system and database server.  And by keeping the data out of the application storage, you avoid any limitations the application host language may place on working storage sizes. These languages supports file reference variables: C, C++, COBOL, PL/I, Assembler, REXX and Java. 

Do you have an application that takes advantage of DB2 10 for z/OS file reference variables? Please take a moment and post a comment about your experience.