A fix is available
APAR status
Closed as program error.
Error description
When using File Manager/Db2 to view/edit a remote Db2 table with a CLOB column, the following message is received: SQLCODE = -398, ERROR: A Locator was requested for host variable number 1 but the variable is not a LOB.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All FM/Db2 users * **************************************************************** * PROBLEM DESCRIPTION: When accessing a remote Db2 table that * * contains a CLOB Db2 column, SQL code * * -398 is displayed. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** FM/Db2 when initializing the LOB locator field for a remote Db2 table is using a method that causes SQL errors when processing a remote Db2 table
Problem conclusion
FM/Db2 was modified to use the Db2 Scalar functions BLOB, CLOB and DBCLOB to initialize the LOB locator fields.
Temporary fix
Comments
APAR Information
APAR number
PH40677
Reported component name
FILE MANAGER Z/
Reported component ID
5655Q4200
Reported release
E12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-09-16
Closed date
2021-12-07
Last modified date
2022-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN0LVL FMN0LVLJ FMN0LVLK FMN0MENU FMN0MJPN FMN0MKOR FMN1ASMX FMN1DLI FMN1END FMN1LVL FMN1LVLJ FMN1LVLK FMN1MENU FMN1MJPN FMN1MKOR FMN1POPT FMN2D2I8 FMN2D2IA FMN2D2IB FMN2D2IC FMN2D2JA FMN2D2JB FMN2D2JC FMN2DATA FMN2LVL FMN2LVLJ FMN2LVLK FMN2RLIB FMN4POPT FMNASMBX FMNASMBY FMNASMX FMNBA15 FMNBIDXM FMNCBLX FMNCGEN FMNCHMAC FMNCHNG FMNCLFMC FMNCLNED FMNCLONE FMNCNVDS FMNELIBD FMNEPROC FMNESRCH FMNFC1ST FMNFMLST FMNFTDSP FMNFTFCH FMNGDSM FMNGDSME FMNGDSMV FMNGTRC FMNIA01 FMNIA19 FMNIA33 FMNIB35 FMNIDX FMNIDXEM FMNIDXLS FMNINDEX FMNMAIN FMNMAINZ FMNMOD1 FMNMOD16 FMNMOD2 FMNMOD2B FMNMOD2S FMNMOD6Z FMNMODC FMNMODD FMNMODO FMNMODPB FMNMODT FMNODIRS FMNPANL FMNPCRDL FMNPCRZL FMNRCRDL FMNRCRM1 FMNRCRM2 FMNRCRM3 FMNRCRZL FMNREFEM FMNRUNPR FMNRXCOM FMNRXEX FMNRXFUN FMNRXINI FMNRXIO FMNSETUP FMNSMF FMNSMFZ FMNSPWB FMNSRCH FMNSRCHB FMNSRCHE FMNSRCHK FMNSRCHL FMNSRCHM FMNSRCHT FMNSRCHX FMNSREF FMNVGENM FMNVMAC FMNVMACM FMNVMACR FMNVWGEN FMNWD1ST FMNXIDXM
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655Q4200
Applicable component levels
RE10 PSY UI78425
UP21/12/10 P F112
RE11 PSY UI78426
UP21/12/10 P F112
RE12 PSY UI78428
UP21/12/10 P F112
RE13 PSY UI78429
UP21/12/10 P F112
RE14 PSY UI78431
UP21/12/10 P F112
RE15 PSY UI78432
UP21/12/10 P F112
RE1A PSY UI78427
UP21/12/10 P F112
RE1B PSY UI78430
UP21/12/10 P F112
RE1C PSY UI78433
UP21/12/10 P F112
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.
[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E12"}]
Document Information
Modified date:
05 January 2022