APAR status
Closed as program error.
Error description
New functions for Spatial support DB2 z/OS: DB2GSE.ST_Is3D DB2GSE.ST_IsMeasured DB2GSE.ST_IsValid DB2GSE.ST_WKTToSQL DB2GSE.ST_WKBToSQL DB2GSE.ST_GeomFromText DB2GSE.ST_GeomFromWKB DB2GSE.ST_Perimeter (DCR DM1667)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of Spatial * * support. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides the support for new * * functions and a new option for Spatial * * Stored Procedure DSN5SCLP. * * * * 1-- New functions. * * * * DB2GSE.ST_Is3D * * DB2GSE.ST_IsMeasured * * DB2GSE.ST_IsValid * * DB2GSE.ST_WKTToSQL * * DB2GSE.ST_WKBToSQL * * DB2GSE.ST_GeomFromText * * DB2GSE.ST_GeomFromWKB * * DB2GSE.ST_Perimeter * * * * 2-- The new option for DSN5SCLP to * * print the report of the Spatial * * functions that are installed on the * * system. * * * **************************************************************** * RECOMMENDATION: All DB2 10 for z/OS users of Spatial support * * need to apply this APAR, follow the ++HOLD * * instruction to enable Spatial function * * before using the new features. * **************************************************************** This APAR provides the support for new functions and a new option for Spatial Stored Procedure DSN5SCLP. The new functions are as follows. DB2GSE.ST_Is3D DB2GSE.ST_IsMeasured DB2GSE.ST_IsValid DB2GSE.ST_WKTToSQL DB2GSE.ST_WKBToSQL DB2GSE.ST_GeomFromText DB2GSE.ST_GeomFromWKB DB2GSE.ST_Perimeter The new option for the DSN5SCLP Stored Procedure will allow one to print a report of the Spatial functions that are installed on the system. For more information about the new functions and how to use the 'function_level' option with DSN5SCLP, the user should reference the "IBM Spatial Support for DB2 10 for z/OS" publication. The new user should follow the instructions contained in the same publication to enable Spatial functionality. Existing Spatial users will need to submit the DSN5SBND job to rebind the Spatial packages. Then, after refreshing the DB2 subsystem, the users need to use DSN5SCLP command and option 'v10' to enable the new Spatial functions. **Please note** ST_Distance: After the user applies APAR PM92224, the results that are returned by the ST_Distance function might be different than before the APAR was applied, unless the function uses point data exclusively. ST_Buffer: After the user applies APAR PM92224, the results that are returned by the ST_Buffer function might be different than before the APAR was applied.
Problem conclusion
This apar is providing the necessary support for the new functions and a new option for the DSN5SCLP Spatial stored procedure. The following text is being included as to how to use the new DSN5SCLP option which will be documented in the "IBM Spatial Support for DB2 10 for z/OS" publication. --------------------------------------------------------------- New option for DSN5SCLP: function_level 1- function_level Use the function_level command to check out the spatial functions installed on the subsystem Authorization The user ID under which the command is invoked must have DBADM authority Command syntax DSN5SCLP /function_level SUBSYSTEM -REPORT filename Parameter descriptions All parameters are case-sensitive unless otherwise indicated filename = 'the absolute file name' ; the report will be written to that file in USS. filename = 'D' will write the report to data set point by DD name FUNCLVL. Example 1: The following example shows how you can use the function_level command to know the spatial functions installed on the DB2 subsystem; the report file is written to a file named /tmp/functionlevel.txt DSN5SCLP /function_level DALLAS -REPORT /tmp/functionlevel.txt Example 2: The following example shows how you can use the function_level command to check out the spatial functions installed on the DB2 subsystem. The report file is written to dataset pointed by a DD name FUNCLVL. You need to allocate a sequential, fixed-blocked 80 record format dataset. Add a DD name FUNCLVL point to the dataset to the job that invoke DSN5SCLP. Assume you allocate dataset 'USER.SPATIAL.REPORT' Then add a DD to job that invoked DSN5SCLP: //FUNCLVL DD DSN=USER.SPATIAL.REPORT, DISP=SHR Invoke DSN5SCLP with the option REPORT = D DSN5SCLP /function_level DALLAS -REPORT D --------------------------------------------------------------- Additional Keywords: SQLSPATIAL
Temporary fix
Comments
APAR Information
APAR number
PM92224
Reported component name
DB2 SPATIAL SUP
Reported component ID
5655R1402
Reported release
210
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2013-07-01
Closed date
2013-09-27
Last modified date
2014-01-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK98018
Modules/Macros
DSN@SPC1 DSN@SPX1 DSN@SP00 DSN@SP10 DSN@SP15 DSN@SP19 DSN@SP20 DSN@SP21 DSN@SP25 DSN@SP29 DSN@SP30 DSN@SP39 DSN@SP40 DSN@SP49 DSN@SP50 DSN@SP57 DSN@SP59 DSN@SP99 DSN5AAAA DSN5SBAA DSN5SBAB DSN5SBAC DSN5SBAD DSN5SBAE DSN5SBAF DSN5SBAG DSN5SBA0 DSN5SBA1 DSN5SBA2 DSN5SBA3 DSN5SBA4 DSN5SBA5 DSN5SBA6 DSN5SBA7 DSN5SBA8 DSN5SBA9 DSN5SBBA DSN5SBBB DSN5SBBC DSN5SBBD DSN5SBBE DSN5SBBF DSN5SBB0 DSN5SBB1 DSN5SBB2 DSN5SBB3 DSN5SBB4 DSN5SBB5 DSN5SBB6 DSN5SBB7 DSN5SBB8 DSN5SBB9 DSN5SBCA DSN5SBCB DSN5SBCC DSN5SBCD DSN5SBCE DSN5SBCF DSN5SBC0 DSN5SBC1 DSN5SBC2 DSN5SBC3 DSN5SBC4 DSN5SBC5 DSN5SBC6 DSN5SBC7 DSN5SBC8 DSN5SBC9 DSN5SBDA DSN5SBDB DSN5SBDC DSN5SBDD DSN5SBDE DSN5SBDF DSN5SBD0 DSN5SBD1 DSN5SBD2 DSN5SBD3 DSN5SBD4 DSN5SBD5 DSN5SBD6 DSN5SBD7 DSN5SBD8 DSN5SBD9 DSN5SBE0 DSN5SBE1 DSN5SB0A DSN5SB0B DSN5SB0C DSN5SB0D DSN5SB0E DSN5SB0F DSN5SB00 DSN5SB01 DSN5SB05 DSN5SB06 DSN5SB07 DSN5SB08 DSN5SB09 DSN5SB1A DSN5SB1B DSN5SB1C DSN5SB1D DSN5SB1E DSN5SB1F DSN5SB10 DSN5SB11 DSN5SB12 DSN5SB13 DSN5SB14 DSN5SB15 DSN5SB16 DSN5SB17 DSN5SB18 DSN5SB19 DSN5SB2A DSN5SB2B DSN5SB2C DSN5SB2D DSN5SB2E DSN5SB2F DSN5SB20 DSN5SB21 DSN5SB22 DSN5SB23 DSN5SB24 DSN5SB25 DSN5SB26 DSN5SB27 DSN5SB28 DSN5SB29 DSN5SB3A DSN5SB3B DSN5SB3C DSN5SB3D DSN5SB3E DSN5SB3F DSN5SB30 DSN5SB31 DSN5SB32 DSN5SB33 DSN5SB34 DSN5SB35 DSN5SB36 DSN5SB37 DSN5SB38 DSN5SB39 DSN5SB4A DSN5SB4B DSN5SB4C DSN5SB4D DSN5SB4E DSN5SB4F DSN5SB40 DSN5SB41 DSN5SB42 DSN5SB43 DSN5SB44 DSN5SB45 DSN5SB46 DSN5SB47 DSN5SB48 DSN5SB49 DSN5SB5A DSN5SB5B DSN5SB5C DSN5SB5D DSN5SB5E DSN5SB5F DSN5SB50 DSN5SB51 DSN5SB52 DSN5SB53 DSN5SB54 DSN5SB55 DSN5SB56 DSN5SB57 DSN5SB58 DSN5SB6A DSN5SB6B DSN5SB6C DSN5SB6D DSN5SB6E DSN5SB6F DSN5SB60 DSN5SB61 DSN5SB62 DSN5SB63 DSN5SB64 DSN5SB65 DSN5SB66 DSN5SB67 DSN5SB68 DSN5SB69 DSN5SB7A DSN5SB7B DSN5SB7C DSN5SB7D DSN5SB7E DSN5SB7F DSN5SB70 DSN5SB71 DSN5SB72 DSN5SB73 DSN5SB74 DSN5SB75 DSN5SB76 DSN5SB77 DSN5SB78 DSN5SB79 DSN5SB8A DSN5SB8B DSN5SB8C DSN5SB8D DSN5SB8E DSN5SB8F DSN5SB80 DSN5SB81 DSN5SB82 DSN5SB83 DSN5SB84 DSN5SB85 DSN5SB86 DSN5SB87 DSN5SB88 DSN5SB89 DSN5SB9A DSN5SB9B DSN5SB9C DSN5SB9D DSN5SB9E DSN5SB9F DSN5SB90 DSN5SB91 DSN5SB92 DSN5SB93 DSN5SB94 DSN5SB95 DSN5SB96 DSN5SB97 DSN5SB98 DSN5SB99 DSN5SCLP DSN5SEAA DSN5SEAB DSN5SEAC DSN5SEAD DSN5SEAE DSN5SEAF DSN5SEA0 DSN5SEA1 DSN5SEA2 DSN5SEA3 DSN5SEA4 DSN5SEA5 DSN5SEA6 DSN5SEA7 DSN5SEA8 DSN5SEA9 DSN5SEBA DSN5SEBB DSN5SEBC DSN5SEBD DSN5SEBE DSN5SEBF DSN5SEB0 DSN5SEB1 DSN5SEB2 DSN5SEB3 DSN5SEB4 DSN5SEB5 DSN5SEB6 DSN5SEB7 DSN5SEB8 DSN5SEB9 DSN5SECA DSN5SECB DSN5SECC DSN5SECD DSN5SECE DSN5SECF DSN5SEC0 DSN5SEC1 DSN5SEC2 DSN5SEC3 DSN5SEC4 DSN5SEC5 DSN5SEC6 DSN5SEC7 DSN5SEC8 DSN5SEC9 DSN5SEDA DSN5SEDB DSN5SEDC DSN5SEDD DSN5SEDE DSN5SEDF DSN5SED0 DSN5SED1 DSN5SED2 DSN5SED3 DSN5SED4 DSN5SED5 DSN5SED6 DSN5SED7 DSN5SED8 DSN5SED9 DSN5SEEA DSN5SEEB DSN5SEEC DSN5SEED DSN5SEEE DSN5SEEF DSN5SEE0 DSN5SEE1 DSN5SEE2 DSN5SEE3 DSN5SEE4 DSN5SEE5 DSN5SEE6 DSN5SEE7 DSN5SEE8 DSN5SEE9 DSN5SEFA DSN5SEFB DSN5SEFC DSN5SEFD DSN5SEFE DSN5SEFF DSN5SEF0 DSN5SEF1 DSN5SEF2 DSN5SEF3 DSN5SEF4 DSN5SEF5 DSN5SEF6 DSN5SEF7 DSN5SEF8 DSN5SEF9 DSN5SENB DSN5SE0A DSN5SE0B DSN5SE0C DSN5SE0D DSN5SE0E DSN5SE0F DSN5SE00 DSN5SE01 DSN5SE02 DSN5SE03 DSN5SE04 DSN5SE05 DSN5SE06 DSN5SE07 DSN5SE08 DSN5SE09 DSN5SE1B DSN5SE1C DSN5SE1D DSN5SE1E DSN5SE1F DSN5SE10 DSN5SE11 DSN5SE12 DSN5SE13 DSN5SE14 DSN5SE15 DSN5SE16 DSN5SE17 DSN5SE18 DSN5SE19 DSN5SE2A DSN5SE2B DSN5SE2C DSN5SE2D DSN5SE2E DSN5SE2F DSN5SE20 DSN5SE21 DSN5SE22 DSN5SE23 DSN5SE24 DSN5SE25 DSN5SE26 DSN5SE27 DSN5SE28 DSN5SE29 DSN5SE3A DSN5SE3B DSN5SE3C DSN5SE3D DSN5SE3E DSN5SE3F DSN5SE30 DSN5SE31 DSN5SE32 DSN5SE33 DSN5SE34 DSN5SE35 DSN5SE36 DSN5SE37 DSN5SE38 DSN5SE39 DSN5SE4A DSN5SE4B DSN5SE4C DSN5SE4D DSN5SE4E DSN5SE4F DSN5SE40 DSN5SE41 DSN5SE42 DSN5SE43 DSN5SE44 DSN5SE45 DSN5SE46 DSN5SE47 DSN5SE48 DSN5SE49 DSN5SE5A DSN5SE5B DSN5SE5C DSN5SE5D DSN5SE5E DSN5SE5F DSN5SE50 DSN5SE51 DSN5SE52 DSN5SE53 DSN5SE54 DSN5SE55 DSN5SE56 DSN5SE57 DSN5SE58 DSN5SE59 DSN5SE6A DSN5SE6B DSN5SE6C DSN5SE6D DSN5SE6E DSN5SE6F DSN5SE60 DSN5SE61 DSN5SE62 DSN5SE63 DSN5SE64 DSN5SE65 DSN5SE66 DSN5SE67 DSN5SE68 DSN5SE69 DSN5SE7A DSN5SE7B DSN5SE7C DSN5SE7D DSN5SE7E DSN5SE7F DSN5SE70 DSN5SE71 DSN5SE72 DSN5SE73 DSN5SE74 DSN5SE75 DSN5SE76 DSN5SE77 DSN5SE78 DSN5SE79 DSN5SE8A DSN5SE8B DSN5SE8C DSN5SE8D DSN5SE8E DSN5SE8F DSN5SE80 DSN5SE81 DSN5SE82 DSN5SE83 DSN5SE84 DSN5SE85 DSN5SE86 DSN5SE87 DSN5SE88 DSN5SE89 DSN5SE9A DSN5SE9B DSN5SE9C DSN5SE9D DSN5SE9E DSN5SE9F DSN5SE90 DSN5SE91 DSN5SE92 DSN5SE93 DSN5SE94 DSN5SE95 DSN5SE96 DSN5SE97 DSN5SE98 DSN5SE99 DSN5SG0A DSN5SG0B DSN5SG0D DSN5SG0E DSN5SG0F DSN5SG01 DSN5SG02 DSN5SG03 DSN5SG04 DSN5SG05 DSN5SG06 DSN5SG07 DSN5SG08 DSN5SG09 DSN5SG10 DSN5SG11 DSN5SG12 DSN5SG20 DSN5SG21 DSN5SG22 DSN5SG23 DSN5SG24 DSN5SG25 DSN5SG26 DSN5SG27 DSN5SG28 DSN5SG29 DSN5SG3A DSN5SG3B DSN5SG3C DSN5SG3D DSN5SG3E DSN5SG3F DSN5SG30 DSN5SG31 DSN5SG32 DSN5SG33 DSN5SG34 DSN5SG35 DSN5SG36 DSN5SG37 DSN5SG38 DSN5SG39 DSN5SG40 DSN5SG41 DSN5SG42 DSN5SG43 DSN5SG44 DSN5SI0A DSN5SI0B DSN5SI0C DSN5SI0D DSN5SI0E DSN5SI0F DSN5SI01 DSN5SI02 DSN5SI03 DSN5SI04 DSN5SI05 DSN5SI06 DSN5SI07 DSN5SI08 DSN5SI09 DSN5SI2A DSN5SI2B DSN5SI2C DSN5SI2D DSN5SI2E DSN5SI2F DSN5SI20 DSN5SI21 DSN5SI22 DSN5SI23 DSN5SI24 DSN5SI25 DSN5SI26 DSN5SI27 DSN5SI28 DSN5SI29 DSN5SI3A DSN5SI3B DSN5SI3C DSN5SI3D DSN5SI3E DSN5SI3F DSN5SI30 DSN5SI31 DSN5SI32 DSN5SI33 DSN5SI34 DSN5SI35 DSN5SI36 DSN5SI37 DSN5SI38 DSN5SI39 DSN5SI4A DSN5SI4B DSN5SI4C DSN5SI4D DSN5SI4E DSN5SI4F DSN5SI40 DSN5SI41 DSN5SI42 DSN5SI43 DSN5SI44 DSN5SI45 DSN5SI46 DSN5SI47 DSN5SI48 DSN5SI49 DSN5SI50 DSN5SI51 DSN5SI52 DSN5SSTP DSN5SS0A DSN5SS0B DSN5SS0C DSN5SS0D DSN5SS0E DSN5SS0F DSN5SS01 DSN5SS02 DSN5SS03 DSN5SS04 DSN5SS05 DSN5SS06 DSN5SS07 DSN5SS08 DSN5SS09 DSN5SS2A DSN5SS2B DSN5SS2C DSN5SS2D DSN5SS2E DSN5SS2F DSN5SS20 DSN5SS21 DSN5SS22 DSN5SS23 DSN5SS24 DSN5SS25 DSN5SS26 DSN5SS27 DSN5SS28 DSN5SS29 DSN5SS3A DSN5SS3B DSN5SS3C DSN5SS3D DSN5SS3E DSN5SS3F DSN5SS30 DSN5SS31 DSN5SS32 DSN5SS33 DSN5SS34 DSN5SS35 DSN5SS36 DSN5SS37 DSN5SS38 DSN5SS39 DSN5SS40 DSN5SS41 DSN5SS42 DSN5SS43 DSN5SS44 DSN5SS45 DSN5SS46 DSN5SS47 DSN5SS48 DSN5SS49 J2AG210J
Fix information
Fixed component name
DB2 SPATIAL SUP
Fixed component ID
5655R1402
Applicable component levels
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"210"}]
Document Information
Modified date:
04 March 2021