Dump ver 8 database on AIX to csv file

D

danl

New Member
The objective is to dump/export a version 8 Db to a .csv file. The Db is on an AIX system that's 15+ yrs old that has no writable drives, so the dump would be done via a terminal session from a Windows PC connected over the network. I am not aware of any other possible connections to the Db, such as ODBC. I appologize in advance for my complete lack of experience with either Progress or AIX. However, I do have access to someone who is capable on Unix that can execute a solution. I assume I'd have to stop the Db first.

Thanks,
Dan
 
Do you have a development license available to you?
That would make things lots easier.

What is the size of the DB and what is the exact version of Progress?

If the server as no writable disks, how is it then possible that the database is runnnng?

Casper.
 
Sorry, I wasn't clear. There are no drives other than the HDD it's running on (i.e. no external drives or writable CD drives, etc.). There is a DAT drive that has been used for backups, but I have low confidence in it's condition. I do not have any other licensing available to me. I estimate the size of the Db at about 500MB. This is based on the size of the .d1 file with the most recent modified date. I will find out the specific version of Progress and post back. Thanks for your help.
 
Knowing what sort of license you have is also important. Use the "showcfg" command to get the details.

Use the "df" command to find out how much free disk space you have.

Once that is known we can provide potential solutions.
 
showcfg returned:

Product Name: Progress AppServer
Installation Date: 04/27/2000
Expiration Date: None
Serial Number: XXXXXXXXXX
Control Numbers: XXXXX - XXXXX - XXXXX
Version Number: 8.3C
Machine Class: KB
Port Number: 17

df returned the following:

[FONT=&quot]Filesystem 1024-blocks Free %Used Iused %Iused Mounted on[/FONT]
[FONT=&quot]/dev/hd4 49152 29644 40% 1612 7% /[/FONT]
[FONT=&quot]/dev/hd2 311296 13656 96% 16676 22% /usr[/FONT]
[FONT=&quot]/dev/hd9var 49152 46388 6% 133 2% /var[/FONT]
[FONT=&quot]/dev/hd3 49152 37256 25% 131 2% /tmp[/FONT]
[FONT=&quot]/dev/hd1 49152 40964 17% 136 2% /home[/FONT]
[FONT=&quot]/dev/infolv 98304 7816 93% 65 1% /usr/lpp/info[/FONT]
[FONT=&quot]/dev/trufax 81920 32180 61% 844 5% /usr/lpp/trufax [/FONT]
[FONT=&quot]/dev/progress71v 114688 17760 85% 3029 11% /usr/lpp/progress7[/FONT]
[FONT=&quot]/dev/p21prolv 294912 36240 88% 6032 9% /usr/lpp/p21pro[/FONT]
[FONT=&quot]/dev/p21prodblv 1359872 270028 81% 45 1% /usr/lpp/p21pro/db[/FONT]
[FONT=&quot]/dev/p21probilv 131072 116592 12% 26 1% /usr/lpp/p21pro/db/i[/FONT]
[FONT=&quot]/dev/progress8lv 98304 9820 91% 3409 14% /usr/lpp/progress8[/FONT]

Thanks for you help
 
I think you must have more than one copy of Progress installed. (The df command hints at both Progress 8 and Progress 7). That showcfg only shows the app server license. Which isn't going to be helpful.

Does anyone there know anything about how to work with this system? Are there any Progress programmers or administrators available? It's going to take a long time going back and forth with questions in this forum...

What does "ps -ef | grep _mpr" return?

On the bright side you do have free disk space to dump to. Not a lot but probably enough to work with.
 
That very well could be. I am told the system was last upgraded in 2000.

This is a small company with no one proficient with AIX, let alone Progress, and the original vendor cannot be contacted.

There was some other info returned with the showcfg:

C-ISAM DataServer
Enterprise Database
4GL Dev

Not sure if that helps. Sorry for the omission.

[FONT=&quot]#ps -ef | grep _mpr[/FONT]
[FONT=&quot] [FONT=&quot] root 5198 1 0 15:47:49 - 0:01 /usr/lpp/progress8/dlc/bin/_mprs[/FONT][/FONT]
[FONT=&quot] [FONT=&quot] root 7670 1 0 15:47:54 - 0:08 /usr/lpp/progress8/dlc/bin/_mpro[/FONT][/FONT]
[FONT=&quot] [FONT=&quot] root 15120 1 0 15:47:49 - 0:07 /usr/lpp/progress8/dlc/bin/_mpro[/FONT][/FONT]
[FONT=&quot] [FONT=&quot] root 37806 17466 1 09:15:03 0 0:00 grep _mpr[/FONT][/FONT]
[FONT=&quot] [FONT=&quot] root 37936 1 0 15:47:49 - 0:24 /usr/lpp/progress8/dlc/bin/_mprs[/FONT][/FONT]
[FONT=&quot] [FONT=&quot] root 39856 1 0 15:47:49 - 0:07 /usr/lpp/progress8/dlc/bin/_mpro[/FONT][/FONT]

Thanks
 
Actually that omitted information is crucial.

You have a 4GL development license which means that dumping your data just became quite a lot easier.

The simplest method is probably to start a session with "mpro dbname -p dict.p". If you are prompted for a username and password and don't have one try ^E. (If no user security is setup you may not be prompted.) Then navigate to "Admin -> Dump Data and Definitions -> Table Contents". (Use arrow keys and enter to navigate.) Use * to select all tables and type ^X to accept the selections. You will be prompted for a directory to dump the data into. You seem to have the most free space in /usr/lpp/p21pro/db so I'd create a "dump" directory there and put the files in it.

This will create a "dictionary dump". Space delimited files with quoted text fields and a trailer at the end of the file with half a dozen or so lines of gobbledygook.

You may, or may not have enough space to do it all in one pass as described above. If you run out of space it will likely crash and you will need to cleanup and do it piecemeal.

If this sounds scary or too complicated a good consultant could do it for you using a remote connection. A consultant could also easily provide you with comma delimited vs space delimited data. If you want to go that route contact info for one consultant is in the signature line of this post ;)
 
Thanks for the reply. Is there any way to predict how long it will take to complete? I believe the db is around 500MB and the system is an old IBM RISC/6000 (604e), if this helps. It'd be helpful to just have a ballpark time on it, in terms of minutes or hours. Again, thanks for your help, and I appreciate the consulting offer :). I will definitely contact you if we need to.
 
No, there's no easy way to say how long it will take. There are too many variables and unknowns regarding your situation. And I've given you instructions on what is the simplest, but also the slowest, possible way to do things.

Just winging it -- you are definitely looking at many hours. Possibly days.

I'm sure that it can be sped up dramatically but that would take some "hands on" time.
 
You must log in or register to reply here.
Back
Top