--- title: "Creating the Db2 Library Manually" slug: "creating-the-dbmotolib-library-manually" updated: 2024-03-27T17:43:45Z published: 2024-03-27T17:43:45Z canonical: "skthelp.syniti.com/creating-the-dbmotolib-library-manually" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Creating the DBMOTOLIB 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. 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 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 | 1. Run the DOS command prompt and change the working directory to C:\DBMLib. ```sql C:>cd C:\DBMLib ``` 1. Run an FTP session followed by the Db2 system IP address ```sql C:\DBMLib> ftp 111.111.111.111 ``` 1. Insert your username and password when prompted. Make sure that your user ID has write permissions and QSECOFR privileges. 2. Make QGPL the current directory. ```sql ftp> quote cwd QGPL ``` 1. Create an empty Savefile on the Db2 system. ```plaintext ftp> quote rcmd CRTSAVF FILE(QGPL/DBMLIBSAVF) AUT(*ALL) ``` 1. Switch to BINARY mode. ```plaintext ftp> bin ``` 1. Transfer the savefile. In the command below, replace DBMLIB.SAVF with the name of the savefile you are using. ```plaintext ftp>  put DBMLIB.SAVF DBMLIBSAVF ``` 1. Restore the savefile, for example in a library called MYDBMOTOLIB: ```plaintext ftp> quote rcmd RSTLIB SAVLIB(DBMOTOLIB) DEV(*SAVF) SAVF(QGPL/DBMLIBSAVF) MBROPT(*ALL) ALWOBJDIF(*ALL) RSTLIB(MYDBMOTOLIB) ``` > [!NOTE] > 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. 1. Delete the save file. ```plaintext ftp>  quote dele DBMLIBSAVF ``` 1. Close the ftp session. ```plaintext ftp> quit ``` 1. Finally, create the stored procedure DBMOTOLIB.JRNSQNM on the Db2 system. This needs to be executed as a SQL command. > [!NOTE] > 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 ```sql 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 ```plaintext 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 ```plaintext 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 ```plaintext 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 ```plaintext 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 ```plaintext 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 ```