A fix is available
APAR status
Closed as program error.
Error description
This APAR addresses the following issues: 1. The Space paddings for CHAR column and CHAR FOR SBCS DATA column are different. The CHAR column is not padded with single-byte spaces, but the CHAR FOR SBCS DATA column is padded with single-byte spaces. 2. Missing SHIFT-IN in Mixed CHAR column in the result set for accelerator tables. 3. "ACI server error for DB2 subsystem xxxx" occurs when an SQL statement that satisfies the following conditions is executed: -The SQL statement is for a virtual table for a DB2 table, thus DVS connection is used. -JDBC Driver is used. -A WHERE clause is specified. -A GRAPHIC column is referred to in the WHERE clause. -The equality operator is used in the WHERE clause. 4. MapReduce from tape VBS files may drop records. 5. ABEND X'0C3' AT FTNXRW/OPBRXM+X'000088A4' running load job. 6. Oracle SEF SQL Rule and JDBC Driver update. 7. Support for Virtual Parallel Data (VPD). 8. Support for CCSID 28709. 9. Fix management of memory block in SQL Engine that leads to orphaned storage 10. Abend 0C4 when refreshing maps
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator * * Loader for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR addresses the following * * issues: * * 1. The Space paddings for CHAR column * * and CHAR FOR SBCS DATA column are * * different. The CHAR column is not * * padded with single-byte spaces, but * * the CHAR FOR SBCS DATA column is * * padded with single-byte spaces. * * 2. Missing SHIFT-IN in Mixed CHAR * * column in the result set for * * accelerator tables. * * 3. "ACI server error for DB2 subsystem * * xxxx" occurs when an SQL statement * * that satisfies the following * * conditions is executed: * * -The SQL statement is for a virtual * * table for a DB2 table, thus DVS * * connection is used. * * -JDBC Driver is used. * * -A WHERE clause is specified. * * -A GRAPHIC column is referred to * * in the WHERE clause. * * -The equality operator is used in * * the WHERE clause. * * 4. MapReduce from tape VBS files may * * drop records. * * 5. ABEND X'0C3' AT * * FTNXRW/OPBRXM+X'000088A4' running * * load job. * * 6. Oracle SEF SQL Rule and JDBC Driver * * update. * * 7. Support for Virtual Parallel Data * * (VPD). * * 8. Support for CCSID 28709. * * 9. Fix management of memory block in * * SQL Engine that leads to orphaned * * storage * * 10. Abend 0C4 when refreshing maps * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI70677
Reported component name
IDAA LOADER DAT
Reported component ID
5639OLE01
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-10-13
Closed date
2017-04-19
Last modified date
2017-05-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI46555
Modules/Macros
HALE210J HLV$GB00 HLV$GDBD HLV$G200 HLV$G210 HLV$G220 HLV$G300 HLV$G400 HLV$G401 HLV$G500 HLV$G900 HLV$HE0A HLV$HE0B HLV$HE0C HLV$HE0D HLV$HE0E HLV$HE0F HLV$HE0G HLV$HE0H HLV$HE0I HLV$HE00 HLV$HE01 HLV$HE02 HLV$HE03 HLV$HE04 HLV$HE05 HLV$HE06 HLV$HE07 HLV$HE08 HLV$HE09 HLV$H400 HLV$H500 HLV$IAB1 HLV$IAG0 HLV$IAG1 HLV$IAG2 HLV$IAG3 HLV$IAG4 HLV$IAM0 HLV$IAM1 HLV$IA10 HLV$IA11 HLV$IA12 HLV$IA20 HLV$IA21 HLV$IA22 HLV$IA90 HLV$IA91 HLV$IA92 HLV$I010 HLV$I011 HLV$I020 HLV$I021 HLV$I030 HLV$I031 HLV$I040 HLV$I041 HLV$I200 HLV$I201 HLV$JE00 HLV$JE01 HLV$KA50 HLV$KA51 HLV$KA52 HLV$KA53 HLV$KA54 HLV$KA55 HLV$KD10 HLV$KD11 HLV$KD12 HLV$KFC0 HLV$KFC1 HLV$KFC2 HLV$K000 HLV$K620 HLV$K621 HLV$K622 HLV$K623 HLV$K624 HLV$K850 HLV$K851 HLV$K852 HLV$K853 HLV$K854 HLV$K855 HLV$K856 HLV$K857 HLV$K858 HLV$L910 HLV$L911 HLV$L912 HLV$L913 HLV$L914 HLV$MEE0 HLV$MEH0 HLV$MEP0 HLV$MEP1 HLV$ME10 HLV$ME11 HLV$N4A0 HLV$N4A1 HLV$PDBD HLV$0B0E HLV$0B0M HLV$0E0E HLV$0E0M HLV$0F0E HLV$0F0M HLV$020E HLV$020M HLV$021E HLV$021M HLV$022E HLV$022M HLV$030E HLV$030M HLV$040E HLV$040M HLV$050E HLV$050M HLV$090E HLV$090M HLV$1E0E HLV$1E0M HLV$140E HLV$140M HLV$150E HLV$150M HLV$2ABE HLV$2ABM HLV$2AGE HLV$2AGM HLV$2AME HLV$2AMM HLV$2A1E HLV$2A1M HLV$2A2E HLV$2A2M HLV$2A3E HLV$2A3M HLV$2A6E HLV$2A6M HLV$2A9E HLV$2A9M HLV$201E HLV$201M HLV$202E HLV$202M HLV$203E HLV$203M HLV$204E HLV$204M HLV$220E HLV$220M HLV$4A4E HLV$4A4M HLV$4A5E HLV$4A5M HLV$4A7E HLV$4A7M HLV$4B1E HLV$4B1M HLV$4D1E HLV$4D1M HLV$4FCE HLV$4FCM HLV$400E HLV$400M HLV$461E HLV$461M HLV$462E HLV$462M HLV$483E HLV$483M HLV$485E HLV$485M HLV$491E HLV$491M HLV$591E HLV$591M HLV$6EDE HLV$6EDM HLV$6EPE HLV$6EPM HLV$640E HLV$640M HLV$641E HLV$641M HLV$650E HLV$650M HLV$74AE HLV$74AM HLV$789E HLV$789M HLV#ARCN HLV#BCOM HLV#BDIR HLV#BRGN HLV#CPOL HLV#DBDI HLV#DBRC HLV#FSCD HLV#GMSG HLV#IDEF HLV#IMSR HLV#JESI HLV#MSG0 HLV#ODIR HLV#ORGN HLV#RACB HLV#TRAC HLV#XACB HLVABIGG HLVADASG HLVADB2G HLVADDBG HLVADRBG HLVAIFXG HLVALUWG HLVALUWI HLVAMSSG HLVAODBG HLVAORAG HLVAQMFG HLVA2VTD HLVA2VTR HLVCBIIM HLVCCMAL HLVCCMSL HLVCCUHL HLVCDBIF HLVCDBST HLVCDCCB HLVCDRCK HLVCDREX HLVCDSAL HLVCDSFR HLVCDSHM HLVCDSOP HLVCDSRD HLVCD2CL HLVCD2SS HLVCEVIF HLVCFICB HLVCFIIC HLVCFRBR HLVCFRCU HLVCGBLV HLVCGSIO HLVCGTBD HLVCGTMM HLVCIDCL HLVCIMCL HLVCIMDB HLVCINIC HLVCINWK HLVCISBR HLVCISCL HLVCLDSG HLVCMDK7 HLVCMDSG HLVCMRFU HLVCMSDA HLVCMSMQ HLVCMTCL HLVCNSNR HLVCOPDM HLVCOPFB HLVCPDRU HLVCPREV HLVCPRSE HLVCRQIF HLVCSCHD HLVCSDBD HLVCSEND HLVCSQCL HLVCSQDT HLVCSQMM HLVCSQOP HLVCSQTB HLVCSVCL HLVCTGOP HLVCTSAL HLVCTSOP HLVCTSRD HLVCTVAL HLVCTVCL HLVCTVOP HLVCTVRD HLVCTVTK HLVCTZOP HLVCTZRD HLVCVPAL HLVCVPCL HLVCVPEV HLVCWUID HLVCXMEN HLVCZFIO HLVDBRCT HLVDFDIV HLVDYNAL HLVFDBRC HLVFDJCL HLVFDMDA HLVGNMP1 HLVIMSA1 HLVIMSB1 HLVIMSC1 HLVIMSDB HLVIMSD1 HLVIMSE1 HLVIMSOF HLVIMS91 HLVIR4AT HLVIR4ED HLVIR4SQ HLVLTENU HLVMBTPA HLVMGENU HLVMODST HLVMTMTC HLVMTMT6 HLVOACDA HLVOAOPR HLVOAPDR HLVOATFU HLVOAUCK HLVOAUMG HLVOBOFU HLVOBOSU HLVOBRID HLVOBRIM HLVOBRIS HLVOBRSQ HLVOBRSR HLVOBRTV HLVOBRXM HLVOCLUP HLVOCOSB HLVOCOSE HLVOCOSF HLVOCOSK HLVODARU HLVODBTP HLVODFRU HLVODMMG HLVODMWR HLVOFUGN HLVOHOPA HLVOIMCP HLVOINAS HLVOINSQ HLVOIOMG HLVOIO31 HLVOKYAD HLVOKYAN HLVOKYBD HLVOKYBN HLVOKY9D HLVOKY9N HLVOLGUX HLVOLIAD HLVOLIAN HLVOLIBD HLVOLIBN HLVOLINK HLVOLI9D HLVOLI9N HLVOMASM HLVOMAXM HLVOMLGN HLVOMPTP HLVOPAFU HLVOPAGN HLVOPCSX HLVOPMM HLVOPMS HLVOPTGN HLVORXDM HLVOSCFU HLVOSDRU HLVOSGMG HLVOSLOG HLVOSMGR HLVOSTGN HLVOSVTP HLVOTBEV HLVOTBMG HLVOTBRU HLVOVPMG HLVOVTGN HLVO31AD HLVO31AN HLVO31BD HLVO31BN HLVO319D HLVO319N HLVPB HLVRAVTC HLVRAVTR HLVSBIGC HLVSDDBC HLVSDRBC HLVSEQIN HLVSEQOU HLVSFPAR HLVSIFXC HLVSIN00 HLVSLUWC HLVSMFT4 HLVSMFT5 HLVSMSSC HLVSORAC HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQL9D HLVSQL9N HLVSQMFC HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ29D HLVSQ29N HLVTGL3 HLVTSVTR
Fix information
Fixed component name
IDAA LOADER DAT
Fixed component ID
5639OLE01
Applicable component levels
R210 PSY UI46555
UP17/04/28 P F704
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQN5S","label":"Db2 Analystics Accelerator Loader Data Map"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 May 2017