A fix is available
APAR status
Closed as program error.
Error description
This unload utility would failed with -452 when the file name contain $ DSNU283I _DB2D 189 14:52:32.41 DSNUULVA - LOB ERROR SQLCODE = -452 SQLERRM = /u/DB2D/LOBWORK/TWFRLM$1/DEJJNZZG 1 SQLSTATE= 428A1 SQLERRP = DSNOLFRV
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of File * * Reference Variables (FRV). * **************************************************************** * PROBLEM DESCRIPTION: An SQLCODE -452 is issued from DSNOLFRV * * location 330 when the HFS file name in * * a File Reference Variable contains * * special characters '$' or ' '(white * * space). These characters are allowed * * for valid HFS file names in a File * * Reference Variable. * **************************************************************** * RECOMMENDATION: * **************************************************************** An SQLCODE -452 is issued from DSNOLFRV, location 330, when the HFS file name in a File Reference Variable contains special characters '$' or ' '(white space). These characters are allowed in forming a valid HFS file name in the File Reference Variable. The following example illustrates the problem. 1. Create a Table with a LOB column and populate the table. CREATE TABLE T1 (C1 INT, C2 CLOB(1K)); INSERT ITNO T1 VALUES(1, CAST('AAA' AS CLOB)) FOR 100 ROWS; 2. UNLOAD the Table to a File Reference Variable that contains a special character '$' in the HFS file name TEMPLATE LOBT DSN /U/DB2D/LOBWORK/LOB$TS DSNTYPE(HFS) UNLOAD DATA FROM TABLE T1 (C1 INT, C2 VARCHAR(255) CLOBF LOBT) 3. An SQLCODE -452 will result as mentioned above. Please note. When the HFS file name contains a ' '(white space), an SQLCODE452 will also be issued from DSNOLFRV location 330.
Problem conclusion
The code in DB2 has been modified to allow the special characters '$' and ' ' (white space) for a File Reference Variable. As a result, an SQLCODE -452 will not be issued when unloading a LOB with a file name that contains either of these characters. Additional Keywords: SQLCODE452 SQLLOB
Temporary fix
Comments
APAR Information
APAR number
PM43689
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-07-14
Closed date
2011-08-31
Last modified date
2011-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK71487 UK71488
Modules/Macros
DSNOLFRV
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 October 2011