I don't see option to dump data and definition together?
Correct. It is a two-step process.
Also please clarify prodb syntax
You want to start with an empty database. (I see that you have already named it "bkuptss1").
prodb prompts for missing arguments. You could skip the prompts by saying:
Your next step is to start a session with the new database and use the dictionary to LOAD the .df file that you made previously. Usage of -rx may, or may not, be required. If it doesn't work one way try it the other way.
Once the .df is loaded make a backup of the "has schema but no-data", database. That can be a handy backup to have. i.e.
Code:
probkup bkuptss1 bkuptss1.pbk
If you get that far...
I can only dump data definitions...
Did you start the session with, or without the -rx option? Try starting a new session in the opposite manner. If I recall correctly there are some circumstances where you need to do the definitions dump one way and the data dump the other way.
Worst case (which in some ways is actually better) you can opt to do a binary dump & load using proutil instead.
If you managed to get .d files just go ahead and use those to load.
If not then do a binary dump with proutil for each table:
Code:
proutil olddbname -C dump tablename
You can then load that with:
Code:
proutil newdbname -C load tablename.bd
The .bd file for long table names gets abbreviated - so pay attention to that if you go down this road.
You will also need to rebuild indexes after a binary load:
Code:
proutil newdbname -C idxbuild all
I have omitted various optimization techniques since this is a small database. I may have also glossed over or forgotten a few details here and there. It's early and a weekend, I've just started my coffee