View Single Post

   
  #2 (permalink)  
Old 04-20-2008, 06:27 AM
Richard Kofler
 
Posts: n/a
Default Re: Corruption in old and unsupported v7 database ...

Neil Truby wrote:

[ ... problem description snipped ... ]

> no HP-UX 10.20 servers. He doesn't have enough disk space to
> onunlaod/onload the file to that server.
>
> Any other ideas for helping him out? IBM tech Support won;t touch it - the
> version is too old.
>


sorry, I can only offer one idea for the disk storage &
for the unload.
If you have a laptop with sufficient disk, or anytype
of PeeCee with enuff disk, then put a Linux distro
onto it, start the nfsd and export the disks

On HPUX it was possible to run a nfs client when I last
saw this OS (somewhen in 1994)

nfs_mount the laptop or PeeCee disk and you have some
disk space for an unload like so:

---- untested ------
mkfifo mypipe; ## only once, out side any loop
gzip -fc <mypipe >$TABLE_file_on_nfsmount.gz &
UNLOAD TO "MYPIPE"
SELECT ......FROM $TABLE ;
--------------------

If you create a file of the table names to unload
& if you put a shell-forloop around, set TABLE
iterator variable you have 'poor man's unload'

Here is an example you can run using bash

for TABLE in $( cat file_containing_tablenames ); do
unload_script.sh $TABLE
done

I have no idea, how to solve the other problem, sorry

dic_k
--
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe
Reply With Quote