Hey all,
Currently we are using RTB on a unix AIX platform, but are intending to switch towards a Linux setup.
This means that we need to rebuild the rtb database on a Linux platform. As some rtb databasefields have datatype recid/rowid, this is not a straightforward dump/load exercise.
Are there some specific rtb tools available to actually perform this kind of job?
We are currently using RTB 10.2B (on AIX).
Thanks in advance,
Dirk Anthonis
See <rtb installation>/rtb_util. We have customized dump and load procedures to handle restoring the RECID values.
FYI, starting with RTB 11.x we no longer store RECID and the standard OE dump and load routines can be used.
From Roundtable 10.2B User Guide:
3.13. Repository Dump and Load
Do not use the OpenEdge database administration utilities to dump and load a Roundtable repository database. The Roundtable repository database stores many RECID values and if you use the OpenEdge database administration utilities to dump and load your Roundtable repository database, the RECID values will be lost. Also, your new Roundtable repository database will be unusable.
Roundtable comes with its own tools for dumping and loading the repository database. These tools preserve the RECID values.
Follow these steps to dump and reload the Roundtable repository database:
1. Ensure that adequate disk space is available to accommodate a database dump. It is difficult to predict how much space this should be, but dumps often require between half to three quarters the size of the original database.
2. From the OpenEdge editor of a Roundtable session, run rtb_dmp1.p to dump the Roundtable repository data to ASCII ".d" files in the current directory. This program is located in the rtb_util subdirectory of the Roundtable installation procedure and makes calls to a second program in that directory, rtb_dmp2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p).
3. Use the OpenEdge data dictionary tools to dump the user table of contents.
4. Use the OpenEdge data dictionary tools to dump the Roundtable repository database schema to an ASCII ".df" file in the current directory.
5. If the new Roundtable repository database will be in a different location, change to that new location and move in or copy in the ASCII ".d" and ".df" files created earlier.
6. Use the OpenEdge prodb command to create a new Roundtable repository database from the OpenEdge empty database.
7. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the schema from the ASCII ".df" file in the current directory.
8. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the user table of contents.
9. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, run rtb_lod1.p to load the Roundtable repository data from the ASCII ".d" files in the current directory. Like rtb_dmp1.p, this program is located in the rtb_util subdirectory of the Roundtable installation and makes calls to a second program in that directory, rtb_lod2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p).
Hi Dirk,
Have a look at this document: www.roundtable-software.com/.../RTB-Char-100A.pdf
Under heading of "3.12 Repository Dump and Load".
To ruin the ending, Roundtable have customised dump and load procedures.
HTH
Molly
Hi Dirk,
Have a look at this document: www.roundtable-software.com/.../RTB-Char-100A.pdf
Under heading of "3.12 Repository Dump and Load".
To ruin the ending, Roundtable have customised dump and load procedures.
HTH
Molly
See <rtb installation>/rtb_util. We have customized dump and load procedures to handle restoring the RECID values.
FYI, starting with RTB 11.x we no longer store RECID and the standard OE dump and load routines can be used.
From Roundtable 10.2B User Guide:
3.13. Repository Dump and Load
Do not use the OpenEdge database administration utilities to dump and load a Roundtable repository database. The Roundtable repository database stores many RECID values and if you use the OpenEdge database administration utilities to dump and load your Roundtable repository database, the RECID values will be lost. Also, your new Roundtable repository database will be unusable.
Roundtable comes with its own tools for dumping and loading the repository database. These tools preserve the RECID values.
Follow these steps to dump and reload the Roundtable repository database:
1. Ensure that adequate disk space is available to accommodate a database dump. It is difficult to predict how much space this should be, but dumps often require between half to three quarters the size of the original database.
2. From the OpenEdge editor of a Roundtable session, run rtb_dmp1.p to dump the Roundtable repository data to ASCII ".d" files in the current directory. This program is located in the rtb_util subdirectory of the Roundtable installation procedure and makes calls to a second program in that directory, rtb_dmp2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p).
3. Use the OpenEdge data dictionary tools to dump the user table of contents.
4. Use the OpenEdge data dictionary tools to dump the Roundtable repository database schema to an ASCII ".df" file in the current directory.
5. If the new Roundtable repository database will be in a different location, change to that new location and move in or copy in the ASCII ".d" and ".df" files created earlier.
6. Use the OpenEdge prodb command to create a new Roundtable repository database from the OpenEdge empty database.
7. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the schema from the ASCII ".df" file in the current directory.
8. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the user table of contents.
9. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, run rtb_lod1.p to load the Roundtable repository data from the ASCII ".d" files in the current directory. Like rtb_dmp1.p, this program is located in the rtb_util subdirectory of the Roundtable installation and makes calls to a second program in that directory, rtb_lod2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p).
Hi Jeff and Molly,
Both your replies will enable to perform the actual job.
Many thanks for your quick reply.
Dirk.