Re: ITS Woes
Paul Watson hit problems exporting/importing a 10.FC6 database using the TimeSeries DataBlade: dbexport/dbimport kept failing, with support only suggesting re-initialising the instance. One suggestion was to drop the -ss option on dbexport (which had fixed a similar Spatial DataBlade case), another to unregister the blade and keep the DDL separately. Paul's actual fix was simply to hand-edit the SQL dbexport generated, correcting some casts. Others urged him to escalate the bug with IBM; a support contact said escalation was under way, but no IBM fix is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Roy
Thanks for that, it turned out that the dbexport SQL is incorrect, just
neede to correct some of the castings. However I do find it
unacceptable that when you have datablades installed especailly the IBM
ones that the dbexport/dbimport fails so regularly
AND please nobody tell me to raise a bug cos I'm always told it works
when I try :-) :-)
Cheers
Paul
Paul Watson
Tel: +44 1414161772 +1 913-400-2620
Mob: +44 7818003457 +1 913-636-2858
Web: www.oninit.com
Failure is not as frightening as regret.
Attend IDUG 2007 San Jose, North America
May 6-10, 2007
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: Roy Mercer [mailto:roy.mercer@gmail.com]
> Posted At: 29 March 2007 07:53
> Posted To: comp.databases.informix
> Conversation: ITS Woes
> Subject: Re: ITS Woes
>
>
> Paul,
>
> Try your dbexport WITHOUT the -ss option. I had the same problem
> with the spatial datablade in the past. The dbexport would not work
> with the -ss option.
>
> FYI
>
>
>
>
> On Mar 29, 6:00 am, "Paul Watson" <p...@oninit.com> wrote:
> > Hi Peeps
> >
> > Does anybody out there know of anyone in tech support that
> understands
> > DataBlade issues ? Nearly 6 weeks into a ETX problem and
> no progress,
> > apart from 'the only way to fix this is to re-initialise
> the instance'
> > - a real world solution - NOT :-)
> >
> > Has anyone got an export from 10.FC6 with Timeseries to successful
> > export and import ?
> >
> > Cheers
> > Paul
> >
> > Paul Watson
> > Tel: +44 1414161772 +1 913-400-2620
> > Mob: +44 7818003457 +1 913-636-2858
> > Web:www.oninit.com
> >
> > Failure is not as frightening as regret.
> >
> > Attend IDUG 2007 San Jose, North America May 6-10, 2007
> > Visithttp://www.iiug.org/conffor more information.
>
>
I can't resist, Paul. Please take the time and escalate this issue. Unfortunately, there probably isn't a lot of depth at IBM in first or second line support with regards to the datablade technology and the OR capabilities of IDS. So when you report the bug, the person on the other end probably isn't validating the problem in a datablade or OR enabled environment. ESCALATE! This is important, differentiating technology in IDS that isn't getting the attention it deserves. And it won't get the attention it needs unless folks such as yourself escalate things at IBM. You can escalate at anytime simply by telling the support engineer that the issue needs to be escalated.. Christine On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote: > AND please nobody tell me to raise a bug cos I'm always told it works > when I try :-) :-) > > Cheers > Paul >
And if they refuse to escalate it :) Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: elanleblanc@yahoo.com [mailto:elanleblanc@yahoo.com] > Posted At: 29 March 2007 12:00 > Posted To: comp.databases.informix > Conversation: ITS Woes > Subject: Re: ITS Woes > > > I can't resist, Paul. Please take the time and escalate this issue. > Unfortunately, there probably isn't a lot of depth at IBM in > first or second line support with regards to the datablade > technology and the OR capabilities of IDS. So when you > report the bug, the person on the other end probably isn't > validating the problem in a datablade or OR enabled > environment. ESCALATE! This is important, differentiating > technology in IDS that isn't getting the attention it deserves. > > And it won't get the attention it needs unless folks such as > yourself escalate things at IBM. You can escalate at anytime > simply by telling the support engineer that the issue needs > to be escalated.. > > Christine > > On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote: > > > AND please nobody tell me to raise a bug cos I'm always > told it works > > when I try :-) :-) > > > > Cheers > > Paul > > >
Paul, Christine, I have worked with David Jay at IBM Support regarding Datablade problems; he has been very helpful. Mike Badar ESRI 1 International Ct. Broomfield, CO 80021 mbadar@esri.com 303-449-7779 www.esri.com > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of > elanleblanc@yahoo.com > Sent: Thursday, March 29, 2007 11:00 AM > To: informix-list@iiug.org > Subject: Re: ITS Woes > > I can't resist, Paul. Please take the time and escalate this issue. > Unfortunately, there probably isn't a lot of depth at IBM in > first or second line support with regards to the datablade > technology and the OR capabilities of IDS. So when you > report the bug, the person on the other end probably isn't > validating the problem in a datablade or OR enabled > environment. ESCALATE! This is important, differentiating > technology in IDS that isn't getting the attention it deserves. > > And it won't get the attention it needs unless folks such as > yourself escalate things at IBM. You can escalate at anytime > simply by telling the support engineer that the issue needs > to be escalated.. > > Christine > > On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote: > > > AND please nobody tell me to raise a bug cos I'm always > told it works > > when I try :-) :-) > > > > Cheers > > Paul > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >
> And if they refuse to escalate it :)
BULLSHIT!!!!!!!!! do not give up!!!!
Scottishpoet: do something!!!!!!!
and yes you could see a bug or a problem or...example...
if you try to dbexport a database with excalibure text installed in
your hosed
afaikr this is a known bug.
W.a. is grab all the sql (create indexes etc ) unregister the blade,
then dbexport....
The problem was/is there is stuff stored in sbspaces which is not
correct anymore.....
AND one has to do logged imports causing long trx.
sounds like the same is applicable for timeseries.
Have at least a bug filed and ask for a descent workaround.
Superboer.
On 29 mrt, 19:08, "Paul Watson" <p...@oninit.com> wrote:
> And if they refuse to escalate it :)
>
> Paul Watson
> Tel: +44 1414161772 +1 913-400-2620
> Mob: +44 7818003457 +1 913-636-2858
> Web:www.oninit.com
>
> Failure is not as frightening as regret.
>
> Attend IDUG 2007 San Jose, North America
> May 6-10, 2007
> Visithttp://www.iiug.org/conffor more information.
>
> > -----Original Message-----
> > From: elanlebl...@yahoo.com [mailto:elanlebl...@yahoo.com]
> > Posted At: 29 March 2007 12:00
> > Posted To: comp.databases.informix
> > Conversation: ITS Woes
> > Subject: Re: ITS Woes
>
> > I can't resist, Paul. Please take the time and escalate this issue.
> > Unfortunately, there probably isn't a lot of depth at IBM in
> > first or second line support with regards to the datablade
> > technology and the OR capabilities of IDS. So when you
> > report the bug, the person on the other end probably isn't
> > validating the problem in a datablade or OR enabled
> > environment. ESCALATE! This is important, differentiating
> > technology in IDS that isn't getting the attention it deserves.
>
> > And it won't get the attention it needs unless folks such as
> > yourself escalate things at IBM. You can escalate at anytime
> > simply by telling the support engineer that the issue needs
> > to be escalated..
>
> > Christine
>
> > On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote:
>
> > > AND please nobody tell me to raise a bug cos I'm always
> > told it works
> > > when I try :-) :-)
>
> > > Cheers
> > > Paul
The timeseries was an easy fix, just edited the SQL to correct the SQL
the dbexport creates.
Paul Watson
Tel: +44 1414161772 +1 913-400-2620
Mob: +44 7818003457 +1 913-636-2858
Web: www.oninit.com
Failure is not as frightening as regret.
Attend IDUG 2007 San Jose, North America
May 6-10, 2007
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: Superboer [mailto:superboer7@t-online.de]
> Posted At: 29 March 2007 14:27
> Posted To: comp.databases.informix
> Conversation: ITS Woes
> Subject: Re: ITS Woes
>
>
> > And if they refuse to escalate it :)
>
> BULLSHIT!!!!!!!!! do not give up!!!!
>
> Scottishpoet: do something!!!!!!!
>
> and yes you could see a bug or a problem or...example...
> if you try to dbexport a database with excalibure text
> installed in your hosed
>
> afaikr this is a known bug.
> W.a. is grab all the sql (create indexes etc ) unregister the
> blade, then dbexport....
> The problem was/is there is stuff stored in sbspaces which is
> not correct anymore.....
> AND one has to do logged imports causing long trx.
>
> sounds like the same is applicable for timeseries.
> Have at least a bug filed and ask for a descent workaround.
>
> Superboer.
>
>
>
> On 29 mrt, 19:08, "Paul Watson" <p...@oninit.com> wrote:
> > And if they refuse to escalate it :)
> >
> > Paul Watson
> > Tel: +44 1414161772 +1 913-400-2620
> > Mob: +44 7818003457 +1 913-636-2858
> > Web:www.oninit.com
> >
> > Failure is not as frightening as regret.
> >
> > Attend IDUG 2007 San Jose, North America May 6-10, 2007
> > Visithttp://www.iiug.org/conffor more information.
> >
> > > -----Original Message-----
> > > From: elanlebl...@yahoo.com [mailto:elanlebl...@yahoo.com] Posted
> > > At: 29 March 2007 12:00 Posted To: comp.databases.informix
> > > Conversation: ITS Woes
> > > Subject: Re: ITS Woes
> >
> > > I can't resist, Paul. Please take the time and escalate
> this issue.
> > > Unfortunately, there probably isn't a lot of depth at IBM
> in first
> > > or second line support with regards to the datablade
> technology and
> > > the OR capabilities of IDS. So when you report the bug,
> the person
> > > on the other end probably isn't validating the problem in a
> > > datablade or OR enabled environment. ESCALATE! This is
> important,
> > > differentiating technology in IDS that isn't getting the
> attention
> > > it deserves.
> >
> > > And it won't get the attention it needs unless folks such as
> > > yourself escalate things at IBM. You can escalate at
> anytime simply
> > > by telling the support engineer that the issue needs to be
> > > escalated..
> >
> > > Christine
> >
> > > On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote:
> >
> > > > AND please nobody tell me to raise a bug cos I'm always
> > > told it works
> > > > when I try :-) :-)
> >
> > > > Cheers
> > > > Paul
>
>
Paul Watson wrote:
> The timeseries was an easy fix, just edited the SQL to correct the SQL
> the dbexport creates.
You could try myexport! ;-)
Art S. Kagel
>
> Paul Watson
<SNIP>
On 29 Mar, 18:08, "Paul Watson" <p...@oninit.com> wrote:
> And if they refuse to escalate it :)
>
> Paul Watson
> Tel: +44 1414161772 +1 913-400-2620
> Mob: +44 7818003457 +1 913-636-2858
> Web:www.oninit.com
>
> Failure is not as frightening as regret.
>
> Attend IDUG 2007 San Jose, North America
> May 6-10, 2007
> Visithttp://www.iiug.org/conffor more information.
>
>
>
> > -----Original Message-----
> > From: elanlebl...@yahoo.com [mailto:elanlebl...@yahoo.com]
> > Posted At: 29 March 2007 12:00
> > Posted To: comp.databases.informix
> > Conversation: ITS Woes
> > Subject: Re: ITS Woes
>
> > I can't resist, Paul. Please take the time and escalate this issue.
> > Unfortunately, there probably isn't a lot of depth at IBM in
> > first or second line support with regards to the datablade
> > technology and the OR capabilities of IDS. So when you
> > report the bug, the person on the other end probably isn't
> > validating the problem in a datablade or OR enabled
> > environment. ESCALATE! This is important, differentiating
> > technology in IDS that isn't getting the attention it deserves.
>
> > And it won't get the attention it needs unless folks such as
> > yourself escalate things at IBM. You can escalate at anytime
> > simply by telling the support engineer that the issue needs
> > to be escalated..
>
> > Christine
>
> > On Mar 29, 10:54 am, "Paul Watson" <p...@oninit.com> wrote:
>
> > > AND please nobody tell me to raise a bug cos I'm always
> > told it works
> > > when I try :-) :-)
>
> > > Cheers
> > > Paul- Hide quoted text -
>
> - Show quoted text -
Well I was around the UK Support office last week and had a face to
face meeting with Chris Beaney (UK Support Manager) and
almost ALL the support team in the UK.
If they refuse to escalate tell me the PMR number and the issue. I'll
go around to their offices and wack them hard, I know where they work!
I suspect they are not escalating as they cannot reproduce it so send
me more info (e.g. PMR number, symptoms etc). and I'll sort it!
PS I was told Paul Brown is the Timeseries guy at IBM, he practially
wrote it!
Our main user of Timeseries told us that there is no supported way to
move from Solaris to Linux. So dbexport can unload Timseries data?
What if you have Tbs of Timeseries data and many dbspaces hence many
containers. Can you unload each Timeseries container in parallel?
Also I heard that if you have more than one Timeseries container per
dbspace you cannot get I/O going on more than one container in a
single dbspace
at the same time. IBM say you can but they are wrong (???) Is this
true?
David.
The Informix support organisation in EMEA has a lot of experience with the datablades. I don't believe anybody has refused to escalate anything. Scottishpoet is now working with Paul's support provider reagrding this situation.