DAE UQ11444 Readme file



INTRODUCTION
------------

This file describes the contents of the IBM AIX Entry/6000 (5765-097)
Version 1 Release 2 Modification 1 (English) PTF UQ11444.

The following topics are covered in this file:

o  PREREQUISITES
o  ADDITIONAL SUPPORT
   -  Support for AIX 4.1.2 and Later
   -  AIX 4.2+ and Write Access for /usr/lpp (PN86428)
o  INSTALLING PTF UQ11444
o  MIGRATION FOR TQ TABLES (required)
o  LIST OF FILES
o  LIST OF APARS FIXED
o  NOTES FOR UQ11444
   -  New Tables and Queues Utility Tool (DCR4963)
   -  DDMS Doc Change (PQ03833)
   -  Printer Binary Option Added to Print 4029-formatted File (PQ05402)
   -  TXE_OPT_DISCONNECT Flag Provided on CS2_TRANSACT (PN89993)
   -  Database/Transaction Configuration File (optional) (PQ05418)
   -  Txe Mirror Filtering (optional) (PQ05418)
o  COMPLEMENTARY FIXES FOR CS/2 ENTRY 1.3.1


PREREQUISITES
-------------

Program Temporary Fix UQ11444 requires Entry/6000 (5765-097)
Release 1.2.1 (English).  Please ensure you are at this level before
proceeding with the installation of this PTF.

Program Temporary Fix UQ11444 has no prerequisite PTFs.

*** A prerequisite is 3251 AIX Preventive Maintenance Package        ***
*** Rel. 320 Volume Z88701 which includes PTF #U493251 and others,   ***
*** required to load libwms.a shipped on this PTF.                   ***

*** Oracle6 TxE server support is not included in this PTF.          ***
*** If you are using Oracle6 TxE support, do not install             ***
*** this PTF.  Contact the Support Center for more                   ***
*** information.                                                     ***


ADDITIONAL SUPPORT
------------------

Support for AIX 4.1.2 and Later
-------------------------------
    Entry/6000 1.2.1 is supported on AIX 4.1.2 and later releases with the
    installation of this PTF.  However, there are some inconsistencies
    in AIX 4.1.* that must be fixed before installing Entry/6000 1.2.1 or
    this PTF.  Please follow these instructions to correct the
    inconsistencies:

    - Create the directory /usr/lpp/cs2/toolkit/db/cs2.  Note that
      you must be logged in as 'root' and create the lower level
      directories first, e.g. /usr/lpp/cs2.

    - Insure that the locale 'En_US' has been installed.  Note that
      'en_US' is not the same as 'En_US'.


AIX 4.2+ and Write Access for /usr/lpp (PN86428)
------------------------------------------------
    Beginning with Release 4.2 AIX installp no longer allows a product
    to be installed with a subdirectory of /usr/lpp having write access
    for group staff.  Entry/6000 requires that /usr/lpp/cs2/sys be writable
    by the user who starts Entry/6000. (PN86428)

    The root user who installs Entry/6000 on AIX 4.2 should issue the
    the following command after installation is complete:

    chmod g+w /usr/lpp/cs2/sys


INSTALLING PTF UQ11444
----------------------

PTF UQ11444 may be installed using the AIX SMIT utility.  If installing
from tape, give the tape drive name as the 'INPUT device / directory
for software'.  If installing from an image of the tape (that is the
file UQ11444.bff), give the path and file name of the image file.

Follow these directions to update your system and install PTF UQ11444:

   1. Shutdown the Entry/6000, if it is currently running.

   2. Login as 'root' and execute /etc/slibclean to unload the
      Entry/6000 shared libraries from memory.

   3. Install PTF UQ11444 using SMIT.

   4. This will update the files listed in the Updated Files section.

   5. The PTF installation is now complete.  You can restart the
      Entry/6000.  (If on AIX 4.2+, see note above for
      PN86428 on how to give write access to the /usr/lpp/ directory
      before attempting to start Entry/6000.)

   6. Run the TQ migration utility.  See Migration For TQ Tables section.


MIGRATION FOR TQ TABLES (required)
----------------------------------

This utility will examine the Table definitions (Queue's don't need
to be migrated) in cs2tqf00.cfs and will migrate the tables if necessary.

Note: is is VERY unlikely that any tables on OS/2 will need to be
migrated and in that case no changes will be made to the table files.
On AIX, most tables will need to be migrated, but there is little chance
of any data being lost or the table being corrupted if the table is not
migrated.  The only possible result of not modifying a table would
be that it would appear to fill up before it is actually full.

To migrate the TQ tables:

   1. Start DAE.
   2. Execute cs2tqmig from the toolkit.


LIST OF FILES
-------------

The following are the files shipped on this PTF:

        /usr/include/cs2/cs2.h
        /usr/include/cs2/cs2cnerr.h
        /usr/include/cs2/cs2coapi.h
        /usr/include/cs2/cs2codfn.h
        /usr/include/cs2/cs2db.h
        /usr/include/cs2/cs2dberr.h
        /usr/include/cs2/cs2dbext.h
        /usr/include/cs2/cs2dbsdb.h
        /usr/include/cs2/cs2dmcal.h
        /usr/include/cs2/cs2ds.h
        /usr/include/cs2/cs2signl.h
        /usr/include/cs2/cs2xact.h
        /usr/include/cs2/txeapi.h
        /usr/include/cs2/txemsgrc.h
        /usr/include/cs2/txesrv.h
        /usr/lib/libcs2.a
        /usr/lib/libcs2i.a
        /usr/lib/libwms.a
        /usr/lib/nls/msg/En_US/cs2.cat
        /usr/lib/nls/msg/En_US/cs2h.cat
        /usr/lpp/cs2/ddms/ddmldip.h
        /usr/lpp/cs2/inst_UQ11444/readme.doc.UQ11444
        /usr/lpp/cs2/sys/cs2apr00
        /usr/lpp/cs2/sys/cs2aptrp
        /usr/lpp/cs2/sys/cs2blr00
        /usr/lpp/cs2/sys/cs2cbr00
        /usr/lpp/cs2/sys/cs2clnup
        /usr/lpp/cs2/sys/cs2dmr00
        /usr/lpp/cs2/sys/cs2dspro
        /usr/lpp/cs2/sys/cs2dsrdr
        /usr/lpp/cs2/sys/cs2dsrds
        /usr/lpp/cs2/sys/cs2ecr00
        /usr/lpp/cs2/sys/cs2fsr00
        /usr/lpp/cs2/sys/cs2icm00
        /usr/lpp/cs2/sys/cs2icr00
        /usr/lpp/cs2/sys/cs2icr02
        /usr/lpp/cs2/sys/cs2irr00
        /usr/lpp/cs2/sys/cs2irr01
        /usr/lpp/cs2/sys/cs2irr10
        /usr/lpp/cs2/sys/cs2ncr02
        /usr/lpp/cs2/sys/cs2ps0mp
        /usr/lpp/cs2/sys/cs2ps1mp
        /usr/lpp/cs2/sys/cs2psr00
        /usr/lpp/cs2/sys/cs2psr01
        /usr/lpp/cs2/sys/cs2scr00
        /usr/lpp/cs2/sys/cs2setup
        /usr/lpp/cs2/sys/cs2start
        /usr/lpp/cs2/sys/cs2sura0
        /usr/lpp/cs2/sys/cs2surc0
        /usr/lpp/cs2/sys/cs2tccac
        /usr/lpp/cs2/sys/cs2tccon
        /usr/lpp/cs2/sys/cs2tciio
        /usr/lpp/cs2/sys/cs2tcoio
        /usr/lpp/cs2/sys/cs2tcr00
        /usr/lpp/cs2/sys/cs2tmr00
        /usr/lpp/cs2/sys/cs2tqr00
        /usr/lpp/cs2/sys/cs2tqr01
        /usr/lpp/cs2/sys/cs2uialp.hlp
        /usr/lpp/cs2/sys/cs2uialp.pdl
        /usr/lpp/cs2/sys/cs2uialp.pml
        /usr/lpp/cs2/sys/cs2uialt
        /usr/lpp/cs2/sys/cs2uir00
        /usr/lpp/cs2/sys/cs2uir01
        /usr/lpp/cs2/toolkit/cnfgtool
        /usr/lpp/cs2/toolkit/cs2blt
        /usr/lpp/cs2/toolkit/cs2cbt
        /usr/lpp/cs2/toolkit/cs2cuoff
        /usr/lpp/cs2/toolkit/cs2cutil
        /usr/lpp/cs2/toolkit/cs2fst
        /usr/lpp/cs2/toolkit/cs2ftt
        /usr/lpp/cs2/toolkit/cs2stt
        /usr/lpp/cs2/toolkit/cs2tqmig
        /usr/lpp/cs2/toolkit/cs2tqt
        /usr/lpp/cs2/toolkit/cs2utt
        /usr/lpp/cs2/toolkit/cs2utt.doc
        /usr/lpp/cs2/toolkit/db/assets.dat
        /usr/lpp/cs2/toolkit/db/crtdbase.cmd
        /usr/lpp/cs2/toolkit/db/cs2db.doc
        /usr/lpp/cs2/toolkit/db/cs2dbdcl
        /usr/lpp/cs2/toolkit/db/cs2dbdcl.c
        /usr/lpp/cs2/toolkit/db/cs2dbddl
        /usr/lpp/cs2/toolkit/db/cs2dbddl.c
        /usr/lpp/cs2/toolkit/db/cs2dbdml
        /usr/lpp/cs2/toolkit/db/cs2dbdml.c
        /usr/lpp/cs2/toolkit/db/cs2dbsmp.doc
        /usr/lpp/cs2/toolkit/db/cs2dbsmp.mak
        /usr/lpp/cs2/toolkit/db/cstrans
        /usr/lpp/cs2/toolkit/db/cstrans.c
        /usr/lpp/cs2/toolkit/db/cstrans.h
        /usr/lpp/cs2/toolkit/db/ctxeodbc.c
        /usr/lpp/cs2/toolkit/db/ctxeodbc.mak
        /usr/lpp/cs2/toolkit/db/dbsystbl.c
        /usr/lpp/cs2/toolkit/db/dbsystbl.exp
        /usr/lpp/cs2/toolkit/db/dbsystbl.h
        /usr/lpp/cs2/toolkit/db/dbsystbl.mak
        /usr/lpp/cs2/toolkit/db/nondbase.c
        /usr/lpp/cs2/toolkit/db/nondbase.exp
        /usr/lpp/cs2/toolkit/db/nondbase.mak
        /usr/lpp/cs2/toolkit/db/nondbase.o
        /usr/lpp/cs2/toolkit/db/nonsqldb.c
        /usr/lpp/cs2/toolkit/db/persons.dat
        /usr/lpp/cs2/toolkit/db/sumdbl.c
        /usr/lpp/cs2/toolkit/db/sumdbl.exp
        /usr/lpp/cs2/toolkit/db/sumdbl.mak
        /usr/lpp/cs2/toolkit/db/sumdbl.o
        /usr/lpp/cs2/toolkit/db/tables.run
        /usr/lpp/cs2/toolkit/db/txesutbl.c
        /usr/lpp/cs2/toolkit/db/txesutbl.exp
        /usr/lpp/cs2/toolkit/db/txesutbl.mak
        /usr/lpp/cs2/toolkit/db/txetest2
        /usr/lpp/cs2/toolkit/db/txetest2.c
        /usr/lpp/cs2/toolkit/db/txetest2.mak
        /usr/lpp/cs2/toolkit/db/type.dat
        /usr/lpp/cs2/toolkit/db/uraixsql.c
        /usr/lpp/cs2/toolkit/db/urnopdb2.sqc
        /usr/lpp/cs2/toolkit/db/urnopmak.mak
        /usr/lpp/cs2/toolkit/db/urnoptxn.c
        /usr/lpp/cs2/toolkit/db/usrtxdb2.mak
        /usr/lpp/cs2/toolkit/db/usrtxns.exp
        /usr/lpp/cs2/toolkit/myappl.c
        /usr/lpp/cs2/toolkit/poolsab


LIST OF APARS FIXED
-------------------

On UQ11444:
-----------
DCR4811  NCR - to prevent heartbeat messages from appearing on session
         where DAE was started add "DISP=NO" to CS2IRR01.CS2NODE ACB
         start parameters in capital letters with no spaces.
DCR4900  CS2.H - allow multiple #include passes to improve usability.
DCR4927  Improved cs2cbt (Configuration Utility Tool) - allow exit
         from Add request; start parameter display corrected.
DCR4963  Rewrite TQINIT to CS2TQT.
DCR662   CS2_REPLY2 function - acknowledged CS2_REPLY.
PN54193  TQ - adding record to a reopened pre-allocated memory image
         table results in csr429 error.
PN58278  Starting appl using CS2_INITIALIZE_RES by a user other than
         the one who started CS/6000 leaves a semaphore behind.
PN60407  cs2uial0 (alert handler) traps.
PN62244  TCP/IP -coredump was issued from  cs2tciio in iio_proc + 0x60.
PN62289  NLS - os2<->aix performance problem.
PN62301  Base logger loops when logging to remote node and a
         communications error occurs.
PN62310  TCP/IP processes (cs2tcxxx) are not shutting down normally.
PN62392  CS/6000 local CCB not started (CSR317 error) when issuing
         bind() within minute of previous close.  Fixed by using
         setsockopt() with so_reuseaddress so bind is immediate.
PN62545  Data Supply (cs2dsrdr) waiting forever for acknowledgement.
         The timeout specified in cs2dsrdr's ACB start parms is now used
         as RDS timeout for CS2_SEND unless overridden by a nonzero
         DSRP timeout.  The override applies only for the cs2dsrds;
         the start parm timeout value is always used for the cs2dsrdr.
PN62555  Data supply does not cleanup aborted session. Now cs2dsrdr
         aborts stranded request if ACB start parm timeout elapses,
         overridden by nonzero value in DSRP timeout field.
PN62586  Calling CS2_INIT multiple times does not re-enable the signal
         handlers.
PN62587  ACB deleted after program running. Calling CS2_WHOAMI with null
         originator rsname corrupts memory. CSR1029 is returned instead.
PN62596  TCP/IP - insufficient max connections in TCP/IP CACB causes
         TCP/IP rem crash.
PN62652  TCP/IP driver cs2tccac hung up. Core dump. Buffer too small.
PN64319  System hangs up after 4096 disk queued messages.
PN65083  DAE forked process has incorrect process id (pid).
PN68216  TCP/IP -can't establish TCP/IP session. Options TCP_KEEPIDLE,
         TCP_KEEPALIVE are now used to detect link failures. Signal
         handlers to deal with epipe are now installed preventing
         termination of cs2tccac during high message-sending rates.
PN68384  Data supply (cs2dsrdr) traps if a forward slash is specified
         as the first character of a CS/2 file path.
PN68740  TCP/IP - socket remains after normal shutdown.
PN68841  DDMS - program hangs when sequence is d_defload then d_svhdr.
PN69492  WMS trap causes abnormal end of cs2uir00 during display panel.
PN69503  TQ rem crashes when auxiliary table image is on NFS.
PN71313  CS2_TQ_DELETE fails with CSR1385.
PN71652  CS/6000 APPC rem does not allow more than one remote program.
PN72402  WMS performance improved for container list update.
PN72443  CS2_TEMP_RES API fails (depending on char count in prefix).
PN73806  cs2clnup recognizes only 8 digits of semaphore ID.
PN74603  Initialization - CS/6000 leaves semaphores behind.
PN75425  Semaphore number is increased incorrectly.
PN75966  CS2_PURGE_RES should delete ANCB as well as temporary ACB.
PN75968  cs2apr00 does not issue 'mcconfirmd' & 'tpended'.
PN75970  CS2_BASELOG succeeds when issued from a 32-bit appl with ACB
         set to processor type 2, but message is not baselogged.
PN75971  Data transparency - xp validation check for packed decimal
         types only allowing odd lengths.
PN75972  Initialization (cs2irr00) exits without freeing message pool.
PN75973  Initialization - some control block file sizes result in
         corrupt RD pool at initialization.
PN75983  TQ - CS2_TQ_GETNEXT api corrupts memory when accessing a table
         on a remote node with a different architecture.
PN78096  DDMS used to support baud rates of only 32767 (signed integer).
         Now DDMS treats baud rate as unsigned int with value of 65535.
PN78105  DDMS floating point overflow error when device data larger
         than 1e+10 and percent deadbanding used on remote variable.
PN78892  cs2cutil - processor type not valid for RCB.
PN80757  DS - CLM3363 returned when DSRP l_timeout=-1.
PN81535  DB - Oracle7 via ODBC CS2_DB API support for CS/6000.
         enhancement and various CS2_DB API fixes.
PN81536  NT support on other platforms.
PN81759  Rayonier service project enhancements.
PN81780  DB - cross-platform CS2_TRANSACT API requests are failing in
         the mirrored client's path validation - CS2_TRANSACT API has
         been updated to no longer require server_drive_path and
         client_resp_path when not applicable.
PN83202  poolsab hangs DAE system.
PN83589  TCP/IP - cs2tccac does not close unix domain socket.
PN88466  Data supply does not erase temporary files when timeout expired.
PN89938  WMS causes an entry field character validation loop.
PN89993  DB - new TXE_OPT_DISCONNECT flag provides explicit disconnect.
PN90723  Print Server - cannot start more than 10 PCBs on CS/6000.
PN91317  UI - on AIX4.2 get CSR5717 when cs2shell up and start 2nd UI app.
PN91325  TQ - cs2tqr01 core dump when message pool is full.
PQ03833  DDMS d_writervar documentation incomplete.
PQ03838  WMS notebook X-Station memory leakage.
PQ05069  CS2_TEMP_RES - create & purge multiple temporary ACBs causes hang.
PQ05402  CS2_PRINT provides invalid output of 4029-formatted file.
PQ05403  DDMS - CSR2095 - resource in use error from ModifyPoll.
PQ05404  CS2_UTIL api traps when passed invalid originator in the RDS.
PQ05406  DDMS enhancement to support d_writervar cross platform.
PQ05407  ECR - cs2ecr00 frees storage which was not malloc'd.
PQ05408  DB - CS2_TRANSACT returns CSR1391.
PQ05409  DB - CS2_TRANSACT gets timeout using TXE_OPT_OPEN_LOOP.
PQ05410  TQ - trap when 2 TQ servers close same T/Q at same time.
PQ05411  DDMS random I/O points do not update when ldit make connection.
PQ05414  DDMS change for variable msg notification (Plantworks PN84964).
PQ05416  Disk Queued messages not received correctly when CACHE LAZY:ON.
PQ05417  TQ Large tables (300,000+ members) get CSR0409 before table full.
PQ05418  Filter TXE secondary mirror requests based on configurable RCs.
PQ05419  CS2_INIT gets good return code when DAE has been shutdown.
PQ05421  Y2000 - update cs2colib and rebuild REMs for year 2000 support.
PQ05422  Time requester keeps sending requests after timeout condition.
PQ05423  TQ - toggle TQ corruption flag during update.
PQ05424  DDMS passing incorrect remote variable size.
PQ05425  TQ - RMU Verify Utility seems to run endlessly for large tables.
PQ05731  Semaphores not deleted at shutdown.
PQ06265  APPC - synchronous TP incorrectly ends after deallocate from host.
PQ07133  TQ - Occasional TQ REM core dumps on open/close of AIX image files.
PQ07271  DDMS cannot support remote variable data length greater than 32K.
PQ07611  CS/6000 applications may hang when run by root user.
PQ08215  DDMS builds wrong # of templates when reading DDMS list var.


------------------------------------------------------------------------------
NOTES FOR UQ11444
-----------------

New Tables and Queues Utility Tool (DCR4963)
--------------------------------------------
    The cs2utt Utility Tools have a new tool added with this PTF,
    the new Tables and Queues Utility Tool (cs2tqt), and a new
    cs2utt.doc.  Refer to the cs2\toolkit\cs2utt.doc for details.


DDMS Doc Change (PQ03833)
-------------------------
    Page 11-281 of the Device Data Management Support
    Book update needs the NOTE at the bottom added:

    d_writevar  Table 11-150 Field Descriptions

    Name    Type     Description
    bfr_sz  short    Variable write:  Specify the size (in bytes)
            integer  of bfr_addr.  If the data consists of multiple
                     elements, you must pack the elements in the
                     buffer.  The size must be equal to or greater
                     than the variable's element_no field
                     multiplied by the element_len field.  (Both
                     fields are defined by d_defrvar.)
                     .
                     Note:  If the size is too small, an E_INVPARM
                     error is returned.
                     .
                     .
         ADD =>  NOTE: For arrays and character strings,
         ADD =>        the bfr_sz field can be less
         ADD =>        than the variable's element_no
         ADD =>        field multiplied by the element_len.
         ADD =>        In such instances the E_INVPARM
         ADD =>        DDMS error is not returned.


Printer Binary Option Added to Print 4029-formatted File (PQ05402)
------------------------------------------------------------------
    The following is an update to the DAE Communication System Technical
    Guide and Reference, Print and Spool Support chapter, Start Parameters
    section.  The parameters for printer resource continuation buffer
    timeout and printer resource maximum errors remain as before.

  | In order to enable optional start parameters with the menu-based
  | utilities, remember to set the "Use load parameters from ACB" flag.

    Printer REM Start Parameters
    ----------------------------

    The printer REM ACB can contain the following optional start
    parameters.

  | Note it is also possible to configure multiple printer resources which
  | need not all use the same set of start parameters.  This is done by
  | configuring two or more printer REMs each with a desired set of start
  | parameters, then assigning each printer resource to be served by the
  | printer REM with appropriate start parameters.

  | Printer resource mode
  |
  |   This start parameter specifies whether to print in text or binary
  |   mode.  The parameter is not used on all platforms.
  |
  |   The default print mode is text.  With text mode on the OS/2 platform,
  |   for example, each new-line character is converted to a carriage
  |   return / linefeed pair.
  |
  |   When you specify binary mode, data is sent to the printer exactly as
  |   received.  No conversion takes place.  This parameter may be useful
  |   to print data formatted for a specific printer.  In addition, binary
  |   mode causes no new-line to be appended to the end of a print job.  It
  |   causes the Printer resource append new-line parameter to default to
  |   not append a new-line.  (This can be overridden by using the Printer
  |   resource append new-line parameter to explicitly force an ending
  |   new-line.  See the Printer resource append new-line parameter
  |   description for details.)
  |
  |   This parameter has the following format:
  |
  |   PRMD=x
  |
  |   where x specifies text or binary print mode.
  |
  |   0     Specifies the default of text mode.
  |   1     Specifies binary mode.

    Printer resource append new-line

      This start parameter allows a user to choose whether or not a
      new-line will be appended to the end of a print job.  A new-line
      consists of a carriage return and line feed control character pair in
      OS/2 text file mode.  This parameter has the following format.

      PRAN=x

      where x specifies whether or not a new-line will be appended at the
      end of a print job.

      0     Specifies that a new-line will not be appended.
  |         This becomes the default only if the Printer resource
  |         mode parameter is used to specify binary mode.

  |   1     Specifies that a new-line will be appended. This is the default
  |         when the Printer resource mode parameter is not used, or when
  |         the printer resource mode parameter explicitly specifies text
  |         mode.

      The appended new-line may be needed with some printers to ensure that
      the last print line is flushed from the print buffer when a print job
      is completed.  It also ensures that no two print jobs will print on
      the same line, regardless of job content.


TXE_OPT_DISCONNECT Flag Provided on CS2_TRANSACT (PN89993)
----------------------------------------------------------
    Update to DAE Application Programming publication, CS2_TRANSACT chapter:

       The work_opt and fail_opt fields also support the following.

       work_opt      You may optionally specify TXE_OPT_DISCONNECT to
                     disconnect from the database after this transaction
                     successfully completes.  TXE_OPT_DISCONNECT may
                     be combined with other work_opt flag values, for
                     example TXE_OPT_COMMIT.

       fail_opt      You may optionally specify TXE_OPT_DISCONNECT to
                     disconnect from the database if this transaction fails.
                     TXE_OPT_DISCONNECT may be combined with other fail_opt
                     flag values, for example TXE_OPT_ROLLBACK.


Database/Transaction Configuration File (optional) (PQ05418)
------------------------------------------------------------
    The Database/Transaction (DB/Txe) component uses an optional configuration
    file, cs2dbtxe.cnf.  This file is located in your Distributed Application
    Environment system path on the full-function Communication System node
    where the DB/Txe server resides.  The file is provided by default, but may
    be modified, deleted or renamed, if desired.

    The DB/Txe configuration file is used to specify the following options:
      * Txe mirror filtering (See "Txe Mirror Filtering" below.)

    Comments and blank lines are ignored in the file.  Only keywords, such as
    TxeMirrorFilter, are recognized.  Keywords must start in column 1 and are
    case insensitive.


Txe Mirror Filtering (optional) (PQ05418)
-----------------------------------------
    This optional feature applies only if DB/Txe mirroring is enabled.  It is
    available for both synchronous and asynchronous mirroring on the full-
    function Communication System node.  It is described here to document
    the interface to and effect on the client.

    The DB/Txe component offers the option of filtering secondary mirrored
    CS2_TRANSACT requests from reissue to the secondary database exactly as
    originated.  Mirror filtering is configured by specifying Transaction
    mirror return code pairs in the DB/Txe configuration file, cs2dbtxe.cnf, on
    the node where the primary database resides.  The return code pairs are
    specified as a TxeMirrorFilter setting.  They determine which failed
    primary requests are filtered from mirroring directly to the secondary
    database.  Each pair consists of an error domain and error value.

    cs2dbtxe.cnf is shipped on the server with one Txe mirror filter return
    code pair by default:
    TxeMirrorFilter = 3,-911.                /* Don't mirror SQL deadlocks */

    In this setting, 3 is the error domain of TXE_SQL_ERR.  -911 is the error
    value for the SQL error, "the current transaction has been rolled back
    because of a deadlock or timeout."  Although deadlock prevention is
    preferred to detection, occasional database deadlocks may be unavoidable in
    some applications.  Here, mirrored CS2_TRANSACT requests can be filtered
    from direct reissue to the secondary database to prevent creating an
    out-of-synchronization condition, or further deadlock.

    An example of three pairs specified is:
    TxeMirrorFilter = 3,-911. 1,121. 3,100.  /* RCs to filter from mirroring */

    When a CS2_TRANSACT request is filtered from mirroring to the secondary
    database resource, the parameters of the client's CS2_TRANSACT structure
    are examined.  If the fail_opt flag in the CS2_TRANSACT structure is set to
    TXE_OPT_ROLLBACK (or TXE_OPT_COMMIT), the secondary database resource is
    rolled back (or committed, as appropriate).  This is done in an attempt to
    better synchronize to the primary database.

    When a CS2_TRANSACT request results in a Txe error, it returns a non-zero
    error domain and value to the client.  Typically, the CS2_TRANSACT CSR code
    returned is CS2_TXE_ERROR (CSR2820).  When mirrored requests are filtered,
    the CS2_TRANSACT API returns a similar code, however, it is tailored for
    mirror filtering:
      CS2_TXE_ERROR_MIR_FLTR (CSR2821) - CS2_TXE_ERROR with secondary
      CS2_TRANSACT request filtered from mirroring.
    In addition, base log messages confirm the acceptance of the mirror filter
    setting, and provide details of mirror errors and filtering.  Refer to the
    message help for further information.

    Note that CS2_TRANSACT always returns the same value from the API as the
    RDS return code (cnretcd field).


------------------------------------------------------------------------------
COMPLEMENTARY FIXES FOR CS/2 ENTRY 1.3.1
----------------------------------------

  Entry/6000 1.2.1    CS/2 Entry 1.3.1
  PTF UQ11444         PTF UQ11442
  ----------------    ----------------
    DCR4811             DCR4811
    DCR4900             DCR4900
    DCR4927             DCR4927
    DCR4963             DCR4963
    DCR662              DCR662
    PN62289             PN75974
    PN62301             PN75975
    PN62392             PN62590
    PN62545             PN64368
    PN62555             PN64367
    PN62587             PN62587
    PN68216             PN68287
    PN68384             PN60139
    PN68841             PN75976
    PN71313             PN75980
    PN72443             PN75981
    PN75966             PN57206
    PN75968             PN61507
    PN75970             PN64612
    PN75971             PN64673
    PN75972             PN65303
    PN75973             PN70121
    PN75983             PN67417
    PN78096             PN61268
    PN78105             PN77882
    PN78892             PQ05426
    PN80757             PN81539
    PN81535             PN80759
    PN81536             PN81452
    PN81759             PN62160
    PN81780             PN81028
    PN83202             PQ05427
    PN88466             PQ05428
    PN89993             PQ05429
    PN90723             PQ05430
    PQ05402             PN79627
    PQ05403             PN81433
    PQ05404             PN82509
    PQ05406             PN82921
    PQ05407             PN82927
    PQ05408             PN83330
    PQ05409             PN83331
    PQ05410             PN83647
    PQ05411             PN84356
    PQ05414             PN85698
    PQ05416             PN86802
    PQ05417             PN88042
    PQ05418             PN88060
    PQ05419             PN88546
    PQ05421             PN92710
    PQ05422             PQ00281
    PQ05423             PQ00493
    PQ05424             PQ03384
    PQ05425             PQ03667
    PQ06265             PQ05823
    PQ07133             PQ08297
    PQ07271             PQ02149
    PQ08215             PQ08094


END OF FILE
-----------



Last modified: January 23, 2004
DAE File Repository   |   DAE   |   Email DAE

   About IBM  |   Privacy  |   Terms of use  |   Contact