SEO

#1 (**permalink**) 04-20-2008, 06:26 AM

My customer is on 7.2x on HP-UX 10.20.
Informix support patched one of his chinks better a couple of months ago.
Now (and probably then) he is getting page errors:

Noticed assert failure af.5008e6dc which advised oncheck -cDI 8394250
Dropped index tfgld1061001abaan
Ran create unique index "baan".tfgld1061001abaanon "baan".ttfgld106100
(hash1)
Process halted with 25580:System erroroccurred in network function, invalid
arguement
Ran oncheck cDI 8394250 - It reported bad page, pg-stamp 155ccd15 !=
PG_STAMP2 0
Ran onckeck -cD 8394250 - It reported bad page 33a155f: pg_stamp 358403349
!= PG_STAMP2 0

He's keen to try and do an ASCII unload, but I think it will fail with the
same thing. I'd like to get a copy of his database to work on, but we have
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.

thanks
Neil

#2 (**permalink**) 04-20-2008, 06:27 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Corruption in old and unsupported v7 database ...