Onunload error opening TBLspace
On IDS 11.50.FC5 (Solaris 10 SPARC), onunload of two databases in one instance failed partway through with "Error opening TBLspace... ISAM error: illegal argument to ISAM function", with no indication of which tblspace. Suggestions were to run the full range of oncheck tests (-cc, -cr, -cD, -cI, -ce, -cR, -cS) and check online.log/OS logs; all came back clean. Art Kagel concluded there was no corruption and it was likely an onunload bug worth a PMR; others suggested unloading table by table and trapping errno 102 via 'onmode -I 102' to produce an assertion file for support. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 11.50.FC5
Solaris 10 - SPARC
I am trying to do an onunload on a database. I have done this numerous times
on other similar databases. On this database and a second database in the same
instance, when I try to do an onunload, it starts to wright to tape (disk).
After a while I receive the following error:
Error opening TBLspace...
ISAM error: illegal argument to ISAM function.
It is not very descriptive, it does not tell me which TBLspace or anything
else.
Has anyone seen this before?
Thank you.
Larry
I would oncheck everything.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> IDS 11.50.FC5
>
> Solaris 10 - SPARC
>
> I am trying to do an onunload on a database. I have done this numerous
> times
> on other similar databases. On this database and a second database in the
> same
> instance, when I try to do an onunload, it starts to wright to tape (disk).
> After a while I receive the following error:
>
> Error opening TBLspace...
>
> ISAM error: illegal argument to ISAM function.>
> It is not very descriptive, it does not tell me which TBLspace or anything
> else.
>
> Has anyone seen this before?
>
> Thank you.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Do oncheck to validate your database and instance and this may tell something
that is not good.
Let's go GreenThis email contains 100% recycled electrons.
From: LARRY SORENSEN <LSORENSEN25@msn.com>
To: ids@iiug.org
Sent: Sunday, July 16, 2017 3:40 PM
Subject: Onunload error opening TBLspace [39579]
IDS 11.50.FC5
Solaris 10 - SPARC
I am trying to do an onunload on a database. I have done this numerous times
on other similar databases. On this database and a second database in the same
instance, when I try to do an onunload, it starts to wright to tape (disk).
After a while I receive the following error:
Error opening TBLspace...
ISAM error: illegal argument to ISAM function.
It is not very descriptive, it does not tell me which TBLspace or anything
else.
Has anyone seen this before?
Thank you.
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
Larry Sorensen
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Sunday, July 16, 2017 1:42 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39580]
I would oncheck everything.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> IDS 11.50.FC5
>
> Solaris 10 - SPARC
>
> I am trying to do an onunload on a database. I have done this numerous
> times
> on other similar databases. On this database and a second database in the
> same
> instance, when I try to do an onunload, it starts to wright to tape (disk).
> After a while I receive the following error:
>
> Error opening TBLspace...
>
> ISAM error: illegal argument to ISAM function.>
> It is not very descriptive, it does not tell me which TBLspace or anything
> else.
>
> Has anyone seen this before?
>
> Thank you.
>
> Larry
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
oncheck -ce
Regards,
David.
> On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
>
> I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
>
> Larry Sorensen
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Sunday, July 16, 2017 1:42 PM
> To: ids@iiug.org
> Subject: Re: Onunload error opening TBLspace [39580]
>
> I would oncheck everything.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> > IDS 11.50.FC5
> >
> > Solaris 10 - SPARC
> >
> > I am trying to do an onunload on a database. I have done this numerous
> > times
> > on other similar databases. On this database and a second database in the
> > same
> > instance, when I try to do an onunload, it starts to wright to tape (disk).
> > After a while I receive the following error:
> >
> > Error opening TBLspace...
> >
> > ISAM error: illegal argument to ISAM function.> >
> > It is not very descriptive, it does not tell me which TBLspace or anything
> > else.
> >
> > Has anyone seen this before?
> >
> > Thank you.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk> wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
> > www.askdbmgt.com
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Ok. So now I have done oncheck -cc, cr, cD, cI on the two databases and a
general oncheck -ce all with no error messages.
Anything else that I need to do?
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:41 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39583]
oncheck -ce
Regards,
David.
> On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
>
> I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
>
> Larry Sorensen
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Sunday, July 16, 2017 1:42 PM
> To: ids@iiug.org
> Subject: Re: Onunload error opening TBLspace [39580]
>
> I would oncheck everything.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
>
> Informix - My view<http://informix-myview.blogspot.com/>;
Informix - My view<http://informix-myview.blogspot.com/>;
informix-myview.blogspot.com
A place to share my views and ideas which may be of interest to the Informix
user Community.
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> > IDS 11.50.FC5
> >
> > Solaris 10 - SPARC
> >
> > I am trying to do an onunload on a database. I have done this numerous
> > times
> > on other similar databases. On this database and a second database in the
> > same
> > instance, when I try to do an onunload, it starts to wright to tape
(disk).
> > After a while I receive the following error:
> >
> > Error opening TBLspace...
> >
> > ISAM error: illegal argument to ISAM function.> >
> > It is not very descriptive, it does not tell me which TBLspace or anything
> > else.
> >
> > Has anyone seen this before?
> >
> > Thank you.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
No errors with oncheck -cR on each of the two databases. oncheck -cS without a
parameter just blinks with now messages.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:51 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39584]
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk> wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in
the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I did oncheck -cS on both the dbspaces that are associated with the two
tables. No errors.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:51 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39584]
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk> wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in
the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
OK, so all significant onchecks passes, so no damage. That can only mean
one of things...
A bug in onunload or something REALLY unusual in some column (like a NAN or
-NAN in a FLOAT or SMALLFLOAT column). Given that onunload doesn't
interpret what it reads, it just writes pages out to disk, the latter is
unlikely to be the cause. PMR time?
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Sun, Jul 16, 2017 at 3:03 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
>
> Larry Sorensen
>
> ________________________________
> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> <art.kagel@gmail.com>
> Sent: Sunday, July 16, 2017 1:42 PM
> To: ids@iiug.org
> Subject: Re: Onunload error opening TBLspace [39580]
>
> I would oncheck everything.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>;
>
> ASK Database Management - Home<http://www.askdbmgt.com/>;
> www.askdbmgt.com
> Database Consulting and Support ... This is the site for Art S. Kagel's
> consultancy. The soaring majesty and beauty in the image above hides the
> complex ecology and ...
>
> Blog: http://informix-myview.blogspot.com/
>
> Informix - My view<http://informix-myview.blogspot.com/>;
> informix-myview.blogspot.com
> A place to share my views and ideas which may be of interest to the
> Informix
> user Community.
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
> > IDS 11.50.FC5
> >
> > Solaris 10 - SPARC
> >
> > I am trying to do an onunload on a database. I have done this numerous
> > times
> > on other similar databases. On this database and a second database in the
> > same
> > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > After a while I receive the following error:
> >
> > Error opening TBLspace...
> >
> > ISAM error: illegal argument to ISAM function.> >
> > It is not very descriptive, it does not tell me which TBLspace or
> anything
> > else.
> >
> > Has anyone seen this before?
> >
> > Thank you.
> >
> > Larry
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Try onunloading each table in turn.
Regards,
David.
> On 17 July 2017 at 00:19 Art Kagel <art.kagel@gmail.com> wrote:
>
>
> OK, so all significant onchecks passes, so no damage. That can only mean
> one of things...
>
> A bug in onunload or something REALLY unusual in some column (like a NAN or
> -NAN in a FLOAT or SMALLFLOAT column). Given that onunload doesn't
> interpret what it reads, it just writes pages out to disk, the latter is
> unlikely to be the cause. PMR time?
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
> On Sun, Jul 16, 2017 at 3:03 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
>
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
> > www.askdbmgt.com
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
> > Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> > wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> > (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
> > anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> > ************************************************************
> > *******************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
I'd suggest trapping errno 102 (illegal arg) on server side: 'onmode -I
102' to enable the trap -> onunload -> wait on error and assertion
being created for the trap -> 'onmode -I' to disable the trap.
(consider temporarily disabling shmem dumping for this exercise)
-> open a PMR with the resulting af file.
From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
To: ids@iiug.org
Date: 07/16/2017 09:40 PM
Subject: Onunload error opening TBLspace [39579]
Sent by: ids-bounces@iiug.org
IDS 11.50.FC5
Solaris 10 - SPARC
I am trying to do an onunload on a database. I have done this numerous
times
on other similar databases. On this database and a second database in the
same
instance, when I try to do an onunload, it starts to wright to tape (disk).
After a while I receive the following error:
Error opening TBLspace...
ISAM error: illegal argument to ISAM function.
It is not very descriptive, it does not tell me which TBLspace or anything
else.
Has anyone seen this before?
Thank you.
Larry
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Really long shot here, but have you confirmed that the filesystem is not out
of space (if unloading to disk) or that there's not a problem with the tape
(if unloading to tape)?
Does it work for single tables?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Sunday, July 16, 2017 4:04 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39587]
I did oncheck -cS on both the dbspaces that are associated with the two
tables. No errors.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:51 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39584]
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk>
wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in
the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you for all of the responses. I have over 100 tables, so I think I will
start with the onmode -l 102 option to see if we can figure out which table is
having a TBLspace issue. If that does not work, then I will try unloading
individual tables. The reason I don't try individual tables first is because I
am getting a 30GB file before I receive the error, so I know a lot of tables
are being unloaded before the issue.
Thank you.
Larry Sorensen
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Mike Walker
<mike@advancedatatools.com>
Sent: Monday, July 17, 2017 7:08 AM
To: ids@iiug.org
Subject: RE: Onunload error opening TBLspace [39599]
Really long shot here, but have you confirmed that the filesystem is not out
of space (if unloading to disk) or that there's not a problem with the tape
(if unloading to tape)?
Does it work for single tables?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Sunday, July 16, 2017 4:04 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39587]
I did oncheck -cS on both the dbspaces that are associated with the two
tables. No errors.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:51 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39584]
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk>
wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com<http://www.askdbmgt.com>;
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com<http://www.askdbmgt.com>;
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on the IIUG, nor any other organization with which I
am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this numerous
> > > times
> > > on other similar databases. On this database and a second database in
the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Also: a per-table onunload is a pretty different beast - even onunloading
and onloading all tables in a database wouldn't get you the same as a
database onunload/load.
Reason: a database onunload would just contain the whole database (except
for certain out-of-row data?), including blindly onunloading all system
tables, whereas per-table onunload would consider only a subset of system
catalog content pertaining to a table. For instance all stored procedures
and triggers would not be contained.
From: "LARRY SORENSEN" <LSORENSEN25@msn.com>
To: ids@iiug.org
Date: 07/17/2017 03:46 PM
Subject: Re: Onunload error opening TBLspace [39600]
Sent by: ids-bounces@iiug.org
Thank you for all of the responses. I have over 100 tables, so I think I
will
start with the onmode -l 102 option to see if we can figure out which table
is
having a TBLspace issue. If that does not work, then I will try unloading
individual tables. The reason I don't try individual tables first is
because I
am getting a 30GB file before I receive the error, so I know a lot of
tables
are being unloaded before the issue.
Thank you.
Larry Sorensen
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Mike Walker
<mike@advancedatatools.com>
Sent: Monday, July 17, 2017 7:08 AM
To: ids@iiug.org
Subject: RE: Onunload error opening TBLspace [39599]
Really long shot here, but have you confirmed that the filesystem is not
out
of space (if unloading to disk) or that there's not a problem with the tape
(if unloading to tape)?
Does it work for single tables?
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY
SORENSEN
Sent: Sunday, July 16, 2017 4:04 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39587]
I did oncheck -cS on both the dbspaces that are associated with the two
tables. No errors.
Larry
________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of
david@smooth1.co.uk <david@smooth1.co.uk>
Sent: Sunday, July 16, 2017 3:51 PM
To: ids@iiug.org
Subject: Re: Onunload error opening TBLspace [39584]
Hi,
Also
oncheck -cR
oncheck -cS
Also check the online.log and OS logs (/var/log/message or equivalent) for
errors.
Regards,
David.
> On 16 July 2017 at 22:41 "david@smooth1.co.uk" <david@smooth1.co.uk>
wrote:
>
>
> oncheck -ce>
> Regards,
> David.
>
> > On 16 July 2017 at 21:03 LARRY SORENSEN <LSORENSEN25@msn.com> wrote:
> >
> >
> > I did oncheck -cc, -cI, -cr, -cD. What else would you suggest?
> >
> > Larry Sorensen
> >
> > ________________________________
> > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art
Kagel
> > <art.kagel@gmail.com>
> > Sent: Sunday, July 16, 2017 1:42 PM
> > To: ids@iiug.org
> > Subject: Re: Onunload error opening TBLspace [39580]
> >
> > I would oncheck everything.
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com<http://www.askdbmgt.com>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com<http://www.askdbmgt.com>;
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> >
> > ASK Database Management - Home<http://www.askdbmgt.com/>;
ASK Database Management - Home<http://www.askdbmgt.com/>;
www.askdbmgt.com<http://www.askdbmgt.com>;
Database Consulting and Support ... This is the site for Art S. Kagel's
consultancy. The soaring majesty and beauty in the image above hides the
complex ecology and ...
> > www.askdbmgt.com<http://www.askdbmgt.com>;
> > Database Consulting and Support ... This is the site for Art S. Kagel's
> > consultancy. The soaring majesty and beauty in the image above hides
the
> > complex ecology and ...
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Informix - My view<http://informix-myview.blogspot.com/>;
> > informix-myview.blogspot.com
> > A place to share my views and ideas which may be of interest to the
Informix
> > user Community.
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
opinions
> > and do not reflect on the IIUG, nor any other organization with which I
am
> > associated either explicitly, implicitly, or by inference. Neither do
> > those opinions reflect those of other individuals affiliated with any
> > entity with which I am affiliated nor those of the entities themselves.
> >
> > On Sun, Jul 16, 2017 at 2:39 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
wrote:
> >
> > > IDS 11.50.FC5
> > >
> > > Solaris 10 - SPARC
> > >
> > > I am trying to do an onunload on a database. I have done this
numerous
> > > times
> > > on other similar databases. On this database and a second database in
the
> > > same
> > > instance, when I try to do an onunload, it starts to wright to tape
> (disk).
> > > After a while I receive the following error:
> > >
> > > Error opening TBLspace...
> > >
> > > ISAM error: illegal argument to ISAM function.> > >
> > > It is not very descriptive, it does not tell me which TBLspace or
anything
> > > else.
> > >
> > > Has anyone seen this before?
> > >
> > > Thank you.
> > >
> > > Larry
> > >
> > >
> > > ************************************************************
> > > *******************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
>
****************************************************************************
***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
****************************************************************************
***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.