topic Re: Compress DB in Operating System - HP-UX

Compress DB

Rudi Martin — Thu, 21 Aug 2003 08:47:54 GMT

Hi there

I need help as soon as possible please.

I got a request to we shut down on DB that's grown quite big, compress the file into a new file, and copy the new , smaller file across.

How do I do this ? I haven't got a clue !

Thanks
Regards
Rudi

Re: Compress DB

twang — Thu, 21 Aug 2003 09:02:51 GMT

Do you need some commands to compress file? If yes, you may use gzip with -9 option
-9 indicates the slowest compression method but best compression.
eg.
to compress:
# gzip -9 /stand/vmunix
to expand:
# gunzip /stand/vmunix

hope this helps.

Re: Compress DB

Rudi Martin — Thu, 21 Aug 2003 09:13:05 GMT

Hi Twang...

Thanx for the command , but I still am in the dark with compressing it to a new file.

Re: Compress DB

Chris Wilshaw — Thu, 21 Aug 2003 09:16:34 GMT

It sounds more like your DBA's need to purge old data from the database. (what database are you using?)

It's not possible to simply take a database file, run it through a normal file compression utility, and then let the database run against the compressed file.

Re: Compress DB

Indira Aramandla — Fri, 22 Aug 2003 02:58:59 GMT

Hi Rudi,

Did you mean to compress the database data file. If so you cannot compress the datafile and re-create an empty new datafile. The database will not funtion at all.

If you know that your database has grown large, then you should ask your DBA to archive some of the old data. Move that data to a different tablespace or export that part of the data and save it some where. then you can shrink the remaining data, by exporting and coalesing the tablespaces.

If you were refering to the archive logs then you can compress the older archive logs and move them to a different file system.

I hope this helps.

Re: Compress DB

Volker Borowski — Fri, 22 Aug 2003 16:08:02 GMT

Hi,

there was a function to compress an
MS ACCESS database.

Never heard about this for real RDBMS of any type.

Volker