onunload problem.....
Will Landstrom got 'Error positioning within TBLspace' running onunload on a table in IDS 9.4 on AIX 5.2, and the same for every table. Gerardo Flores suspected corruption and suggested oncheck. Jonathan Smaby and Bob Allan posted working onunload examples (-t, plus -b and -s on 7.31). The cause was not identified; no confirmed fix.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi. I am trying to simply unload a IDS 9.4 table with onunload. I am getting
an error "Error positioning within TBLspace"
It's an aix 5.2 machine
The name of the database is sdm1prd
the table I want to unload is called st_remarks
the owner of the table is informix
I execute....
onunload -b 16 -s 15360000 -t /sdmbkup_trk/archive sdm1prd:informix.sr_remarks
Does anyone know what is wrong here?
Maybe you have a corrupted table. Try running 'oncheck -cID' to fix the error.
Regards
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of WILL
LANDSTROM
Sent: Miércoles, 04 de Junio de 2008 05:37 p.m.
To: ids@iiug.org
Subject: onunload problem..... [12307]
Hi. I am trying to simply unload a IDS 9.4 table with onunload. I am getting
an error "Error positioning within TBLspace"
It's an aix 5.2 machine
The name of the database is sdm1prd
the table I want to unload is called st_remarks the owner of the table is
informix I execute....
onunload -b 16 -s 15360000 -t /sdmbkup_trk/archive sdm1prd:informix.sr_remarks
Does anyone know what is wrong here?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I get the same error with every table. Does anyone have a real life example of
an onunload command to load a single table?
Hi,
I have a database called "database1" and a table in the database called
"table1", I would use this command as the user 'informix' on my HPUX system:
# onunload -t /tmp/table1.dat database1:informix.table1
This assumes that /tmp has enough available disk space to unload the table
as a binary file.
I hope that is what you were looking for.
Jonathan Smaby
Pomona College
ITS Department
> From: WILL LANDSTROM <willlandstrom@yahoo.com>
> Reply-To: <ids@iiug.org>
> Date: Wed, 4 Jun 2008 18:53:25 -0400 (EDT)
> To: <ids@iiug.org>
> Subject: Re: RE: onunload problem..... [12309]
>
> I get the same error with every table. Does anyone have a real life example
of
> an onunload command to load a single table?
>
>
>
******************************************************************************
> *
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
-------------------------------------------------------------
This message has been scanned by Postini anti-virus software.
Use this one all the time in a 7.31.
onunload -t my_backup_dir/my_file_name -b 128 -s 150000000
my_database:my_table
----- Original Message -----
From: "WILL LANDSTROM" <willlandstrom@yahoo.com>
To: <ids@iiug.org>
Sent: Wednesday, June 04, 2008 5:53 PM
Subject: Re: RE: onunload problem..... [12309]
>I get the same error with every table. Does anyone have a real life example
>of
> an onunload command to load a single table?
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>