JR37495: IIS8.1 CONNECT WITH SYABCE IQ15.2

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 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