APAR status
Closed as new function.
Error description
This is APAR for rebuilt patch for usability between IIS8.1.0.1 via Sybace IQ 15.2 for platform AIX 6.1
Local fix
Problem summary
**************************************************************** USERS AFFECTED: All platforms, Sybase EE stage trying to connect to Sybase IQ 15.2 **************************************************************** PROBLEM DESCRIPTION: Provide support for accessing Sybase IQ server 15.2 through sybase EE stages. **************************************************************** RECOMMENDATION: Install patch for JR37495 ****************************************************************
Problem conclusion
Changed CS_VERSION to CS_VERSION_150 and built Sybase EE stage against OCS-15_0. Note: Since CS_VERSION is changed to CS_VERSION_150 with this library, Sybase EE will work correctly only when run against Open Client version 15. Note: For Sybase ASE write and Sybase IQ write if creating a table with long column names, the Truncate Column Name option should be enabled and the Length to Truncate option should be set to a length greater than that of the column name. Note: To run Sybase EE with Sybase IQ 15, the customer will have to install SDK 15 on IS server and point $SYBASE and $SYBASE_OCS to this SDK 15. The Sybase IQ 15 server does not come with SDK bundled in it and the libraries/directory structure for Sybase IQ 15 server is insufficient to support Sybase EE. If the customer wants to use the new IQ feature of remote client load, then additional instructions need to be followed as given below. The feature is enabled through the new env variable APT_SYBASE_REMOTE_LOAD. When this env is set, the Sybase EE will try to load the given table using the new syntax 'USING CLIENT FILE'. This enhancement uses the new load from client file functionality for Load Table. For this functionality to work, please enable it on the IQ 15 server as follows: 1. Login to IQ server as dba > set option allow_read_client_file=on > GRANT READCLIENTFILE TO <group | user> This is also described here --http://infocenter.sybase.com/help/topic/com.sybase.infocenter. dc00608.0480/html/etl_ug/BABEJIGI.htm This new feature requires certain functionality from SDK 15.5, hence SDK 15.5 should be installed and used as the sybase client. The feature also requires the use of dbisql utility, hence the IQ network client 15 should be installed and PATH env modified to include the libraries.
Temporary fix
Comments
APAR Information
APAR number
JR37495
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-16
Closed date
2010-10-06
Last modified date
2010-10-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
SYBASEEE
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
06 October 2010