Creating the Db2 Library Manually

If you are unable to create the library for your Db2 system automatically, you can access the appropriate savefile in the ServerFiles folder and restore it manually as described below. Use the name of the restored library when configuring your System i connection in the Management Center. The default name provided in the Management Center is DBMOTOLIB, so either use this name in the instructions below, or be sure to change the name in the Management Center.

If more than one Syniti Replicateinstallation is sharing the same IBM i server, be sure to set up a different library for each installation.

Note that operating system version V3R2 or higher is required for Syniti Replicate 6.0.0 or higher.

Create a temporary folder on your PC (e.g., C:\DBMLib)
Copy the appropriate savefile for your i operating system version from the ServerFiles folder to C:\DBMLib. The savefiles are:

i/iSeries/AS400 Operating System Version	Syniti Replicate Savefile
V3R2 up to and including V4R2	DBMLIB32.SAVF
V4R3 up to and including V5R0	DBMLIB43.SAVF
V5R1 up to and including V5R3	DBMLIB51.SAVF
V5R4 and above. For use with Log Reader transaction mode.	DBMLIB54.SAVF
V6R1 and above. For use with Log Reader API transaction mode.	DBMLIBAPI61.SAVF

Run the DOS command prompt and change the working directory to C:\DBMLib.

C:>cd C:\DBMLib

Run an FTP session followed by the Db2 system IP address

C:\DBMLib> ftp 111.111.111.111

Insert your username and password when prompted. Make sure that your user ID has write permissions and QSECOFR privileges.
Make QGPL the current directory.

ftp> quote cwd QGPL

Create an empty Savefile on the Db2 system.

ftp> quote rcmd CRTSAVF FILE(QGPL/DBMLIBSAVF) AUT(*ALL)

Switch to BINARY mode.

ftp> bin

Transfer the savefile. In the command below, replace DBMLIB.SAVF with the name of the savefile you are using.

ftp>  put DBMLIB.SAVF DBMLIBSAVF

Restore the savefile, for example in a library called MYDBMOTOLIB:

ftp> quote rcmd RSTLIB SAVLIB(DBMOTOLIB) DEV(*SAVF) SAVF(QGPL/DBMLIBSAVF) MBROPT(*ALL) ALWOBJDIF(*ALL) RSTLIB(MYDBMOTOLIB)

Note
If using the default library name, DBMOTOLIB, be sure to replace only the library name in the command RSTLIB(MYDBMOTOLIB). SAVLIB(DBMOTOLIB)indicates the name of the library as saved in the SAVF file. The RSTLIB parameter instead indicates the name of the library where you want to restore the SAVF file which by default is the name of the library saved in the SAVF.

Delete the save file.

ftp>  quote dele DBMLIBSAVF

Close the ftp session.

ftp> quit

Finally, create the stored procedure DBMOTOLIB.JRNSQNM on the Db2 system. This needs to be executed as a SQL command.
Note
If using the IBM i console to perform this operation, use "/" instead of "." below in "DBMOTOLIB.JRNSQNM" to give you "DBMOTOLIB/JRNSQNM"

Operating System Versions up to and including V4R1 Use with DBMLIB32.SAVF

 CREATE PROCEDURE DBMOTOLIB.JRNSQNM
(IN JOUR CHAR(10) ,
 IN JLIB CHAR(10) ,
 IN FNMS CHAR(900) ,
 IN JDAT CHAR(8) ,
 IN JTIM CHAR(6) ,
 INOUT NUMSEQ DECIMAL(10, 0) ,
 INOUT RECVR CHAR(10) ,
 INOUT LIBRCV CHAR(10) ,
 OUT LSTSQN DECIMAL (10, 0) ,
 OUT LSTRECVR CHAR(10) ,
 OUT LSTLIBREC CHAR(10) ,
 OUT FLAG CHAR(1) ,
 OUT CODC CHAR(7) ,
 OUT MSGG CHAR(100) )
EXTERNAL NAME 'DBMOTOLIB/JRNSQNM'
LANGUAGE CL
PARAMETER STYLE GENERAL

Operating System VersionV4R2 Use with DBMLIB32.SAVF

CREATE PROCEDURE DBMOTOLIB.JRNSQNM
(IN JOUR CHAR(10),
 IN JLIB CHAR(10),
 IN FNMS CHAR(900),
 IN JDAT CHAR(8),
 IN JTIM CHAR(6),
 INOUT NUMSEQ DECIMAL(10,0),
 INOUT RECVR CHAR(10),
 INOUT LIBRCV CHAR(10),
 OUT LSTSQN DECIMAL(10,0),
 OUT LSTRECVR CHAR(10),
 OUT LSTLIBREC CHAR(10),
 OUT FLAG CHAR(1),
 OUT CODC CHAR(7),
 OUT MSGG CHAR(100))
LANGUAGE CL SPECIFIC DBMOTOLIB.JRNSQNM
NOT DETERMINISTIC
NO SQL
EXTERNAL NAME 'DBMOTOLIB/JRNSQNM'
PARAMETER STYLE GENERAL

Operating System Versions V4R3 up to and including V5R0M0 Use with DBMLIB43.SAVF

CREATE PROCEDURE DBMOTOLIB.JRNSQNM
(IN JOUR CHAR(10),
 IN JLIB CHAR(10),
 IN FNMS CHAR(900),
 IN JDAT CHAR(8),
 IN JTIM CHAR(6),
 INOUT NUMSEQ DECIMAL(10,0),
 INOUT RECVR CHAR(10),
 INOUT LIBRCV CHAR(10),
 OUT LSTSQN DECIMAL(10,0),
 OUT LSTRECVR CHAR(10),
 OUT LSTLIBREC CHAR(10),
 OUT FLAG CHAR(1),
 OUT CODC CHAR(7),
 OUT MSGG CHAR(100))
LANGUAGE CL SPECIFIC DBMOTOLIB.JRNSQNM
NOT DETERMINISTIC
NO SQL
EXTERNAL NAME 'DBMOTOLIB/JRNSQNM'
PARAMETER STYLE GENERAL

Operating System Versions V5R1 up to and including V5R3 Use with DBMLIB51.SAVF

CREATE PROCEDURE DBMOTOLIB.JRNSQNM
(IN JOUR CHAR(10),
 IN JLIB CHAR(10),
 IN FNMS CHAR(900),
 IN JDAT CHAR(8),
 IN JTIM CHAR(6),
IN JCDE CHAR(100),
 INOUT NUMSEQ DECIMAL(10,0),
 INOUT RECVR CHAR(10),
 INOUT LIBRCV CHAR(10),
 OUT LSTSQN DECIMAL(10,0),
 OUT LSTTMSP CHAR(26),
 OUT LSTRECVR CHAR(10),
 OUT LSTLIBREC CHAR(10),
 OUT FLAG CHAR(1),
 OUT CODC CHAR(7),
 OUT MSGG CHAR(100))
LANGUAGE CL SPECIFIC DBMOTOLIB.JRNSQNM
NOT DETERMINISTIC
NO SQL
CALLED ON NULL INPUT
EXTERNAL NAME 'DBMOTOLIB/JRNSQNM'
PARAMETER STYLE GENERAL

Operating System Version V5R4 and above: Use with DBMLIB54.SAVF

CREATE PROCEDURE DBMOTOLIB.JRNSQNM
(IN JOUR CHAR(10),
IN JLIB CHAR(10),
IN FNMS CHAR(9000),
IN JDAT CHAR(8),
IN JTIM CHAR(6),
IN JCDE CHAR(100),
INOUT NUMSEQ CHAR(20),
INOUT RECVR CHAR(10),
INOUT LIBRCV CHAR(10),
OUT LSTSQN CHAR(20),
OUT LSTTMSP CHAR(26),
OUT LSTRECVR CHAR(10),
OUT LSTLIBREC CHAR(10),
OUT FLAG CHAR(1),
OUT CODC CHAR(7),
OUT MSGG CHAR(100))
LANGUAGE CL SPECIFIC DBMOTOLIB.JRNSQNM
NOT DETERMINISTIC
NO SQL
CALLED ON NULL INPUT
EXTERNAL NAME 'DBMOTOLIB/JRNSQNM'
PARAMETER STYLE GENERAL

Operating Operating System Versions V6R1 and above Required for transactional replication mode Log Reader API. Use with DBMLIBAPI61.SAVF