SQDR Plus for iSeries Release Notes

StarQuest Data Replicator Plus for iSeries v3.66 Release Notes

June 2010

Introduction

StarQuest Data Replicator (SQDR) is a replication software product that allows you to copy data between IBM DB2, Oracle, MySQL, Informix, and Microsoft SQL Server database environments.

The base StarQuest Data Replicator software runs on Windows and provides full refresh replication, which copies all the source data that you specify for replication, regardless of when that data was last replicated. This provides a “snapshot” of the specified source data at the time of replication.

SQDR Plus for iSeries is a separately licensed component that provides incremental replication support for SQDR users. Incremental replications copy only the data that has changed, reducing the amount of data that is transferred and allowing the replication to occur more frequently.

The following topics are addressed in these Release Notes. Refer to the appropriate SQDR Plus Quick Start Guide at http://www.starquest.com/Supportdocs/browseQuickStarts.shtml for detailed information about installing StarQuest Data Replicator Plus for iSeries for the first time. The SQDR Plus Quick Start Guides include instructions for installing both SQDR and SQDR Plus. Refer to the SQDR Plus for iSeries Users Guide for detailed information about using the StarQuest Data Replicator Plus for iSeries software. Refer to SQDR_Plus_doc_addendum.pdf for details about new features and documentation errata.

What's New in this Release
Upgrade Considerations
System Requirements
FixPak and PTF Notes
Installing and Using the StarQuest Data Replicator Plus for iSeries Software
Known Issues
Release History
Contacting StarQuest

The base StarQuest Data Replicator software (for Windows) contains its own readme file and online documentation; refer to those documents for information about the SQDR base software.

What's New in this Release

This release of the StarQuest Data Replicator Plus for iSeries introduces the following new features and improvements.

Automatic deletion of inactive subscriptions

Refer to SQDR_Plus_doc_addendum.pdf for details about the new features.

Upgrade Considerations

This section describes issues of interest for users who are upgrading from a prior version of StarQuest Data Replicator Plus for iSeries.

If you are upgrading from a prior release of SQDR Plus for iSeries, be sure to review Updating the SQDR Plus Software on page 23 of the SQDR Plus for iSeries Users Guide before you install the new version of the software.
You must connect to the AS/400 with the same user ID that you used during the original installation. If you attempt to run the upgrade with a different userID, the installer will display a dialog showing the correct user ID and ask you to restart the installation.

System Requirements

You can install and run the StarQuest Data Replicator Plus for iSeries on computers with the following operating systems.

OS/400 v5r2, v5r3, v5r4, i5/OS v6r1, and i 7.1.
recent cumulative PTF package
recent DB2 Group PTF package (SF99502, SF99503, SF99504, SF99601, SF99701)
Refer to the appropriate SQDR Plus Quick Start Guide at http://www.starquest.com/Supportdocs/browseQuickStarts.shtml for additional PTF information
Qshell (5722SS1 option 30 for v5rX, 5761SS1 option 30 for v6r1, 5770SS1 option 30 for 7.1)
for v5rX: Java Developer Kit v1.4 (5722JV1 option 6)
or for v6r1: any JVM 1.4 or later (Classic or IBM Technology for Java):
5761JV1 option 6 Java Developer Kit 1.4
5761JV1 option 7 Java Developer Kit 5.0
5761JV1 option 8 J2SE 5.0 32 bit
5761JV1 option 9 J2SE 5.0 64 bit
5761JV1 option 10 Java Developer Kit 6
5761JV1 option 11 Java SE 6 32 bit
5761JV1 option 12 Java SE 6 64 bit
or for 7.1: any JVM 1.4 or later:
5770JV1 8 J2SE 5.0 32 bit
5770JV1 9 J2SE 5.0 64 bit
5770JV1 11 Java SE 6 32 bit
5770JV1 12 Java SE 6 64 bit
5770JV1 13 J2SE 1.4 64 bit
recent Java Group PTF package (SF99169, SF99269, SF99291, SF99562, SF99572)

FixPak and PTF Notes

Refer to the SQDR Plus Quick Start Guides at http://www.starquest.com/Supportdocs/browseQuickStarts.shtml for specific IBM issues and the FixPak and PTFs that may be necessary for StarQuest Data Replicator Plus for iSeries to function properly.

CCSID values:

Both the installing user and the Capture Agent user must be configured for a CCSID (Coded character set identifier) other than the AS/400 default of 65535 (*HEX).

The default behavior of the installer is to create the Capture Agent user with a CCSID of 37. During installation, this value can be changed to any valid CCSID or to *SYSVAL (use the system value QCCSID).

During installation, the CCSID of the installation job is changed to 37. If you wish to use a different CCSID during installation, this value can be changed to any valid CCSID or to *SYSVAL.

To examine what CCSID value is normally used by the installing user, use WRKUSRPRF <user> and scroll to the last page. If "Coded character set identifier" is set to *SYSVAL, then check the system value with DSPSYSVAL QCCSID.

Java versions:

If you have multiple Java versions installed, make sure that the correct version is being used - Java version 1.4 or later is required for correct operation. The default JDK version is typically the latest version present, except on OS/400 v5r2.

To verify the version of Java being used, log in as the installing user and type "java -version" at a QSH or PASE command prompt or "QSH CMD('java -version')" at a CL prompt.

On v5r3 and later, If the result shows that your active JDK version is earlier than 1.4, you should specify the Java version (for the Classic JVM) by setting java.version=1.4 in

/QIBM/UserData/Java400/SystemDefault.properties (system-wide)

or

/home/<user>/SystemDefault.properties (user-specific).

On v5r2, the SQDR Plus installer will modify the system-wide file /QIBM/UserData/Java400/SystemDefault.properties to contain the line java.version=1.4; the previous version will be saved as /QIBM/UserData/Java400/SystemDefault.prev. Please review any existing Java applications that might be affected by this change.

If the command results in the error "qsh: 001-0019 Error found searching for command java. No such path or directory." then there may be a problem with the PATH or with the symbolic link /usr/bin/java. If you get this error, refer to the IBM technote 86256E3D008188C0 QSHELL 001-0019 No Such Path or Directory.

Installing and Using the StarQuest Data Replicator Plus for iSeries Software

The SQDR Plus Quick Start Guides at http://www.starquest.com/Supportdocs/browseQuickStarts.shtml provide step-by-step instructions for installing and using the StarQuest Data Replicator Plus for iSeries in the shortest time. Choose the Quick Start Guide appropriate for your environment.
Refer to the SQDR Plus for iSeries Users Guide for detailed information about using the StarQuest Data Replicator Plus for iSeries software.
Browse the StarQuest Data Replicator Plus technical documents at http://www.starquest.com/Supportdocs/techSQDRPlus/browseSQDRPlus.shtml for specialized information, such as using the StarQuest Data Replicator Plus for iSeries in a particular environment or to accomplish a special task.

Known Issues

When installing from a Windows system, the installer files should be copied or extracted to a temporary directory on the system drive (e.g. C:\). If you run the installation from a drive other than the system drive, you may see the following error message at the end of the installation. This error is harmless and can be ignored:

[java.io.FileNotFoundException:
\DOCUME~1\user\LOCALS~1\Temp\2\ismp001\1923345.tmp
(The system cannot find the path specified)]

SQDR Plus for iSeries does not support the incremental replication of partitioned tables.

Release History

This section provides information about problems or enhancements that are made available as "point releases" and major releases of the StarQuest Data Replicator Plus for iSeries software.

Version Number	Release Date	Significant Changes
3.66.0608	Jun 2010	11329 Decouple delete target from delete subscription 11330 parameterize pruning operation to detect maxRows/maxTransactions to limit UOW 11331 Detect and cleanup orphaned "target" rows periodically 11332 Create CHANGES3 executable in iSeries SQDR distribution 11333 register GETCHANGE3 for iSeries product 11336 Flag, then delete inactive subscribers subscriptions 11348 Reduce retry frequency when DB2 is unavailable 11356 Log errors caused by bad criteria as INFO (or less), not SEVERE 11357 Subscription can be left not collecting changes after DB2 failure
3.65.0506	May 2010	11247 Notify clients upon startup 11252 Support "Ignore Delete" captureOptions 11293 Create iSeries control table columns with explicit CCSID setting
3.64.0405	Apr 2010	11216 Capture after table altered operation
3.63.0318	Mar 2010	11064 don't register an exit program if managedLogs=false & AutoJournal=false 11156 GetChanges and rowCount 11168 Re=subscription of an auto-journaled table may result in the client receving an incorrect indication of a table altered event 11169 Changes to auto-journal names and CALOGMGT
3.62.0302	Mar 2010	11005 iSeries Installer: Cancel button on sign on screen not working 11103 iSeries installer: PTF checks should check for both temp & perm apply 11104 Add "quiesce" shutdown option to CAMAINT capture agent control 11105 Modify GetChanges INFO to "FINE", "FINER"->"FINEST" 11108 TABLEINFO returning COLUMN name as CLOB 11114 register the QCMDEXC Stored Procedure 11115 iSeries installer: Modifications to creation of user profiles 11116 Investigate SQL Syntax error message 11117 Invalid command parameter for release level when sending SQDR save file 11118 Use single operation to attempt grant SQDR privileges when publishing 11120 Publish invalid journal option is a warning - not severe 11130 TABLEINFO should close cursors if SQL error condition detected prior to return 11131 Capture does not log "FINEST" messages from CHANGES2 11138 CaptureAgent install should suceed without dependency on network configuration 11143 Use CL program for save of controlDB 11144 Installer: cursor focus should start on the first field of a dialog 11145 Table list in IR sub wizard is not ordered properly 11147 SQDRPlus does not detect when journaling is ended for a table/file
3.61.0208	Feb 2010	11092 Constrain Select from SYSTABLE "FOR FETCH ONLY" 11107 Incorrect error handling can lead to row count errors 11096 Installer: Tab order on installer dialogs is not correct 11093 iSeries Installer: changes for QSH detection
3.60.1320	Jan 2010	10831 Implement "MoveSubscription" SP 9685 Support customer support product error email notification 10961 Installer: Support customer support product error email notification 10733 Support subscribing to tables with AFTER journaling option-only allow RRN 9894 Restrict view of tables available to replicate with I/R if restrictPublish is enabled 10686 Modify OS400 version of CHANGES to accept maxRow & maxTrans IN parameter 10837 Use case insensitive selection on sq_properties 10735 Review reset of TOTAL for RecordsProcessed 10836 Connectivity check slows down startup 10840 Define monitors for lagtime conditions 10842 Support dynamic maxROW setting - add counters to transaction table 10909 Failure to delete subscription should be considered a WARNING not SEVERE 10864 Publish appears to require SQDR user to have OBJMGT authority 10910 Exception in AddSubscriber not trapped, not logged 10936 ack only should not display maxrow/maxtrans 9895 Do not allow publish of SQDR Plus control tables 10642 display startup information in capture log before accessing sqagent.properties 10863 emphasize case sensitivity when publishing files 10704 CAMAINT: Highlight subscription status if associated "target" is no longer "current" 11031 Provide Option for CAMAINT to save zip file locally 11032 Remote CAMAINT: Publish doesn't detect table when full name used 10889 Use DSPFFD OS400 command to collect DDL of SQDR CT, CV etc. 10834 Capture Agent job should not default to run as CCSID 37 10906 Use of /home/sqdr even though customer specified /sqdr 10912 Insure reference to PGM "CA" in CA_START [_I] Job descriptions is qualified 10946 specify optimized rowcount as MaxRows - not actual Rows 10876 Downgrade CPF9803 error while processing Reciver to WARNING 10952 CPF7054 error should be handled like CPF9801, and flag baseline required 10953 Flag all occurances when Capture requires new baselines 9604 Installer: remove /home/<install-user>/sqagent.properties symlink 9605 Gray out the Next button on warning dialog if the installing user does not have QSECOFR authority 10819 iSeries Installer: add more info to error dialog for system catalogs missing condition 10874 Rework setting of CCSID for SQDR/SQDRADM to use system catalog CCSID 10908 Capture requires CRTPF authority 10739 Provide programmatic mechanism to render "target(s)" offline/online on source system 11014 Provide Capture startup option to support "Fail-over"/"Fall-back" scenarios 11035 Provide mechanism for dynamically creating ASP-dependent journal libraries 11022 Extend AutoJournalling support 10959 Add installation parameter to allow *AFTER only subscriptions 10964 Include StarAdmin in SQDR Plus/iSeries zip file and use StarAdmin's JRE for SQDR+ install 11033 iSeries Installer: avoid DOS window 11037 iSeries Installer: autojournaling changes 11048 iSeries installer: write deleteLogsWithoutSave to sqagent.properties 11076 Provide command to invoke offline/online operations 11062 Accumulate number of staged rows in SQ_STATISTICS 11063 Reject resetTablePosition SP call if table is offline 11067 Recovery menu options
3.45.0917	Sept 2009	10847 Modify TABLEINFO to not return UNIQUE indexes if alwaysUseRowId=true 10907 iSeries: TABLEINFO should return SYSCOLUMN column names
3.45.0602	Jun 2009	10709 Prevent buffer overrun of Error Message Text Output Parameter 10710 Reorder names of GetChanges SP cursors to correspond to creation sequence 10722 Changes not explicitly setting logINFO for skip requests w/out acknowledgements 10720 Deadlock on delete group/subscriber 10717 iSeries installer: change ownership of only SQDR journal receivers 10714 iSeries Installer: disable Next button if Capture Agent or CAMAINT is in use
3.44.0507	May 2009	10671 Enhance Publish to support lenient mode of operation 10673 Modify TGTRLS of Support function in CAMAINT 10677 Failures in Journal reader when using mis-matched metadata 10678 Contention/Error during subscription/deletion can cause getChanges error 10679 permit specification of maxTrans value in sq_properties to control GetChanges 10680 Rare condition causes leftover staging tables 10689 Replace traceback text with meaningful error message 10379 detect & react to changes affecting journaling of subs on active Capture Agent 10695 SQDRPlus/iSeries - Typo in error message (CHANGES) 10694 Grant privileges prior to the "flush" operation when adding subscription 10697 React to D DT = "Delete File" Journal Entry alternative 10700 Enforce null termination of Agent Parameter in call to CHANGES (V6R1) 10701 Log Dynamic SQL at logLevel=FINE 10703 Capture Loops after subscribed tables are dropped 10649 Installer rejecting valid library names 10632 Installer: display of expected destination when using Express Update path 10682 SQDR Plus iSeries: convert readme to HTML 10693 iSeries installer: remove <installing-user>\capture_agent0.log before creating control tables
3.43.0319	Mar 2009	9933 Improve rollback performance 10622 flag subscription if RSTOBJ journal entry encountered 10623 clear all rows signal to SQDR, if journal entry associated with RMVM (remove member) is encountered 10631 Use 20 digit sequence number instead of 4 byte version to sync journal @ startup
3.42.0211	Feb 2009	10560 issue GRTOBJAUT on VIEW created for LOB data to match underlying Physical File 10589 Error when retrieving INTEGER using getShort method
3.41.0802	Aug 2008	10406 length of exception data must be based upon bytes_Available less standard feedback 10408 Add message description to exception data returned by JrnlReader 10434 Job Number contains trailing garbage character 10443 Log summary result set returned by GetChanges 10407 update default password for sqdrdrop to latest value 10410 change CAMAINT to persist ftp, mail address for "support" functions 10448 provide mechanism to delivery "zip" logs etc to new client application 10452 Installer: create installer for remote CAMAINT
3.40.0529	May 2008	repackage of 3.40.0410 10402 test for buffer sufficiency when retrieving information re. Journal Properties 10403 check bytesAvailable when making system API code for error feedback 10404 Increase max_retry to 10 from 2 and initial guess to 10K from 5K for JournalInfo 10405 Pass error structure when calling QjoRtvJrnReceiverInformation
3.40.0410	Apr 2008	10174 DNS/TCP checking code should not throw SEVERE message unless the issue prevents connectivity. 10306 Detect incorrect journal settings 10329 i5/OS v6r1: Ignore "F CB" after row deletes 10170 send email notification to starquest if "support" files are posted 10245 Detect invalid logging options for files when adding a subscription 10358 issue w/IR subs if daylight savings time is not set correctly 10366 Treat Duplicate Subscription as warning not error 10372 CHANGES & HEALTHCHK: use internet address of local host without name lookup 10234 Installer: verify existence of SQL Catalog tables when installing 10263 Installer: misleading error msg after changing email notification checkbox 10297 Installer changes for i5/OS v6r1 9947 Installer: check that exec-user has access to its home directory 10376 Split CADLTRCV into two programs with different ownership 10377 Installer: Change ownership of CADLTRCV1, grant *EXECUTE authority 10378 flag subscription as altered if journal option is not acceptable
3.37.1212	Dec 2007	repackage of 3.37 with new JRNLREADER 10306 Detect incorrect journal settings
3.37.1030	Oct 2007	10221 Return error on TableInfo call if Catalog Tables not found 10258 Data type mismatch error on getShort 10204 dump journal/receiver sequence number information when unexpected log records
3.36.0731	Jul 2007	9670 need option to FTP/email relevant product files to customer support 10100 Remove "unnecessary" dependency on local TCP/DNS configuration 10108 Display the job CCSID when starting the capture agent 10110 Provide a more robust verification of the local communication channel 10111 Unknown log format causing tables to be flagged
3.35.0402	Apr 2007	10005 support SP access to log via RMI 10018 provide status of subscriber/subscription acknowledgment via AgentUtil
3.34.0206	Feb 2006	9986 Allow add and override of primary keys AgentUtil: add StarSQL for Java to JDBC driver search
3.33.0117	Jan 2006	9558 TableInfo specifies "with hold" incorrectly for result sets 9955 Use return statement in favor of exit in TABLEINFO SP 9968 TABLEINFO incorrectly identifies Primary Keys
3.32.1229	Dec 2005	9768 DB2/400 reporting Cursor not open error while SQDR polls for Changes 9950 Check name resolution of Capture Host when starting up Capture 9951 Quit after "n" attempts to create CAQ

Contacting StarQuest

If you need to contact technical support, please provide the following information to help the support engineers address your issue. You can contact StarQuest via phone, email, or facsimile as indicated at the bottom of this page.

Company Information	Address Phone Fax
Contact Information	First and Last Name of individual contact Email Address
Host Type	Hardware and Operating System (i.e., AS/400 V5R4)
Network Protocol/Gateways	Protocol and/or Gateways used (i.e., TCP/IP, HIS 2000)
Client Type	Client Type and Operating System (i.e., Windows 2008 SP2)
StarQuest Product, Version, and Source	Which StarQuest product and what version is installed (i.e., StarSQL for Windows v5.50.02.18) Where you obtained the software (i.e., direct from StarQuest, name of specific reseller)
Problem Information	Provide as much detail as possible, including information about any application that is using the StarQuest product when the problem occurs and the exact error message that appears.

StarQuest Ventures, Inc.
PO Box 1076
Point Reyes Station, CA 94956
Telephone: 415-669-9619
FAX: 415-669-9639
Sales & Support: contact@starquest.com
URL: http://www.starquest.com

SQDR Plus Resources