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 Data Replicationinstallation 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 Data Replication 6.0.0 or higher.

1. Create a temporary folder on your PC (e.g., C:\DBMLib)

2. 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 DR 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

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

4. Run an FTP session followed by the Db2 system IP address
   C:\DBMLib> ftp 111.111.111.111
   

5. Insert your username and password when prompted. Make sure that your user ID has write permissions and QSECOFR privileges.

6. Make QGPL the current directory.
   ftp> quote cwd QGPL

7. Create an empty Savefile on the Db2 system.
   ftp> quote rcmd CRTSAVF FILE(QGPL/DBMLIBSAVF) AUT(*ALL)
   

8. Switch to BINARY mode.
   ftp> bin

9. Transfer the savefile. In the command below, replace DBMLIB.SAVF with the name of the savefile you are using.
   ftp>  put DBMLIB.SAVF DBMLIBSAVF
   

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

11. Delete the save file.
    ftp>  quote dele DBMLIBSAVF
    

12. Close the ftp session.
    ftp> quit
    

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

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