Fixes are available
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
REPL ADMIN APAR FOR V97FP2
Local fix
REPL ADMIN APAR FOR V97FP2
Problem summary
**************************************************************** * USERS AFFECTED: * * Q/SQL Replication 9.7 users. * **************************************************************** * PROBLEM DESCRIPTION: * * wsdbu00626281 * * * * Problem Summary * * * * Asnclp relies on the stored procedure call to determine if a * * dbclob is supported in the database or not. If the stored * * procedure is not correctly installed then asnclp issues an * * error message saying dbclob is not supported although it is * * supported. * * * * Fix Details * * * * The check for stored procedure is changed to just rely on a * * query to determine whether dbclob is allowed or not. * * * * wsdbu00745671 * * * * Problem Summary * * * * If a parent table is not subscribed in a bidi/p2p * * subscription, an internal error is issued by asnclp/rc * * instead of giving a proper error message. * * * * Fix Details * * * * A proper ASN message is now issued clearly explaining why * * the subscription cannot be created. * * * * wsdbu00604868 * * * * Problem Summary * * * * ASNCLP fails with JAVA error if path does tto set to the JVM * * binaries * * * * Fix Details * * * * When customer runs ASNCLP, the path will automatically set * * into the JVM that was shipped with the DB2. * * * * wsdbu00629043 * * * * Problem Summary * * * * If the page size of the table exceeds 4k then asnclp is * * issuing an error message saying the default page size is * * exceeding. However, the SET PROFILE command was not * * correctly setting the page size even if it is used. * * * * Fix Details * * * * The SET PROFILE command processing was changed to correctly * * set the pagesize information. * * * * wsdbu00625353 * * * * Problem Summary * * * * Replication Center and Dashboard are not integrated, they * * have to be started separately. * * * * Fix Details * * * * Add the ability to launch the Dashboard from the Replication * * Center * * * * wsdbu00604719 * * Problem Summary * * * * In some SQL Replication cases when selecting tables to * * register using a search criteria, the selected table shows * * in in the "Selected tables" area of the "Register Table" * * window but the "Definition", "CD Table" and "CD-Table Index" * * remain gray not allowing us to complete our registration. * * Fix Details * * * * The "Definition", "CD Table" and "CD-Table Index"are * * correctly enabled to allow the registration completion. * * * * wsdbu00590334 * * * * Problem Summary * * * * If the validate MQ queues fails, do not run the test to * * verify the channels * * * * Fix Details * * * * Simplify both the success and fail messages, and not to run * * the channel verification if the validate MQ queues fails. * * * * wsdbu00747741 * * * * Problem Summary * * * * Unable to fix column mapping problem that should be able to * * be fixed by going into the properties on the Review Q * * Subscription page of the create Q Subscription wizard. * * * * Fix Details * * * * Redo the OK button logic so that it is properly enabled. * * * * wsdbu00397906 * * * * Problem Summary * * * * In RC SQL replication, there is an equality check on a CLOB * * column which should not be done. The result is: [IBM][CLI * * Driver][DB2/NT] SQL0401N The data types of the operands for * * the operation "=" are not compatible or comparable. * * SQLSTATE=42818 * * * * Fix Details * * * * Use the correct technique for performing equality check on a * * CLOB column. * * * * wsdbu00581152 * * * * Problem Summary * * * * Within RC, hang upon clicking OK after selecting SP from the * * "Select Stored Procedure" dialog * * * * Fix Details * * * * There should be no hang selecting stored procedures. * * * * wsdbu00625360 * * * * Problem Summary * * * * Customers would be better served for BiDi if we provided a * * form similar to the simple Uni form. * * * * Fix Details * * * * Create a bidi "Smart" MQ Script Generator pdf form and * * integrated its launch into RC. * * * * wsdbu00624136 * * * * Problem Summary * * * * Create Replication Queue map through RC sets the value * * MEMORY_LIMIT in IBMQREP_RECVQUEUES to 2 instead of the * * default 32. This value is not consistent with the default * * value we document and also it is too low. * * * * Fix Details * * * * The default value in RC is changed to match with the * * recommended value - 32. * * * * wsdbu00629044 * * * * Problem Summary * * * * asnclp outputs error when executing command "SET SERVER ALL * * TO DB DBCAP ID repbvt01" without password. * * * * Fix Details * * * * With the fix, asnclp prompts for a password on the SET * * SERVER command * * * * wsdbu00600206 * * * * Problem Summary * * * * While creating Q Subscription from an oracle source, the * * data type decimal(5,2) is incorrectly created as just * * decimal in db2 target. * * * * Fix Details * * * * Fixed the problem to create the target with deciaml(p,s) * * * * wsdbu00624300 * * * * Problem Summary * * * * In RC, when creating a Replication Queue Map in an * * environment where the local name of the ADMINQ is different * * than the remote queue name, after creating the map * * successfully and check Properties of the Replication Queue * * Map, what is displayed under the QCapture and QApply's * * adminstration queue names are both changed to Remote Queue * * name. But when defining the QMap, by default we have local * * queue name of adminq in QCapture and we set remote name in * * QApply. * * * * Fix Details * * * * The RC replication queue map UI is correctly initialized * * with defaults. * * * * wsdbu00606301 * * * * Problem Summary * * * * State Street found the Validate WebSphere MQ queues dialog * * confusing. * * * * Fix Details * * * * Implemented UI improvements to Validate WebSphere MQ queues * * dialog * * * * wsdbu00601138 * * * * Problem Summary * * * * The MQ queue/channel/listener attributes are not the same in * * samples, documentation, or the MQ Script Generator. * * * * Fix Details * * * * MQ Script Generator pdf tool has the same attributes as the * * samples and Information Center documentation. * * * * wsdbu00579767 * * * * Problem Summary * * * * RC is erroneously checking for the SHARE setting on model * * spill queue which results in an ASN2286W. * * * * Fix Details * * * * User does not experience ASN2286W for the SHARE setting on * * the model spill queue. * * * * wsdbu00617085 * * * * Problem Summary * * * * RC experiencing erroneous "This version of DB2 for zOS is * * not supported." when connecting to z/OS v10 * * * * Fix Details * * * * Have RC tolerate connecting to z/OS v10 (however, fully * * tested RC support for administering z/OS v10 is in v97fp3a * * and later) * **************************************************************** * RECOMMENDATION: * * As described in Problem Description. * ****************************************************************
Problem conclusion
As described in Problem Description.
Temporary fix
Comments
APAR Information
APAR number
JR34459
Reported component name
WS Q-REPLIC LUW
Reported component ID
5724N9801
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-10-05
Closed date
2011-09-20
Last modified date
2011-09-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IC66612 JR36159
Fix information
Fixed component name
WS Q-REPLIC LUW
Fixed component ID
5724N9801
Applicable component levels
R970 PSY
UP
Document Information
Modified date:
11 October 2021