Re: Re-Register BTS.3.10 fails
So what would 'show last log' say in these cases, and what would=20
sysblderrorlog table have?
From: "MICHAEL HOFFMAN" <offdisc@gmail.com>
To: ids@iiug.org
Date: 19.04.2016 19:42
Subject: Re-Register BTS.3.10 fails [36997]
Sent by: ids-bounces@iiug.org
Hi All,=20
We have an issue with Re-registering the BTS.3.10 blade on Informix=20
12.10.FC4=20
under Solaris 10.=20
We do regular onunloads of our databases for baselining purposes. That=20
function is incompatible with the BTS blade. So before we onunload, we=20
drop=20
the BTS index and unregister the blade. However, now that we upgraded to=20
12.10.FC4, we are running into an issue where the re-registration of the=20
blade=20
fails.=20
The error, from 'show last log', is:=20
blade: bts.3.10=20
err expct: unexpected=20
SQL stmt: execute procedure bts=5FCreateStorage("bts=5Findex", 11);=20
SQL state: XIX000:-9791 : User Defined Routine (bts=5Fcreatestorage)=20
execution=20
failed.=20
Interestingly, registering bts.2.00 works fine, and then upgrading to 3.10 =
works!=20
Here is a screen grab of a full test using blademgr.=20
Test 1 -- re-register bts.3.10 =3D=3D> FAIL=20
Test 2 -- register bts.2.00, unregister & re-register bts.2.00 =3D=3D> SUCC=
ESS=20
Test 3 -- register bts.3.10 =3D=3D> SUCCESS=20
Test 4 -- unregister & re-register bts.3.10 =3D=3D> FAIL=20
Test 5 -- register bts.2.00, unregister & re-register bts.3.10 =3D=3D> FAIL=
=20
-----=20
foghornfp=5Ftcp>register bts.3.10 fcpang=20
Register module bts.3.10 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=20
fcpang.=20
Use 'show last log' for details of failures in module's scripts.=20
foghornfp=5Ftcp>register bts.2.00 fcpang=20
Register module bts.2.00 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
DataBlade bts.2.00 was successfully registered in database fcpang.=20
foghornfp=5Ftcp>unregister bts.2.00 fcpang=20
Unregister module bts.2.00 out of database fcpang? [Y/n]y=20
DataBlade bts.2.00 was successfully unregistered from Database fcpang.=20
foghornfp=5Ftcp>register bts.2.00 fcpang=20
Register module bts.2.00 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
DataBlade bts.2.00 was successfully registered in database fcpang.=20
foghornfp=5Ftcp>register bts.3.10 fcpang=20
Register module bts.3.10 into database fcpang? [Y/n]y=20
DataBlade module(s) that will be replaced by bts.3.10:=20
bts.2.00=20
Are these changes ok? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
DataBlade bts.3.10 was successfully registered in database fcpang.=20
foghornfp=5Ftcp>unregister bts.3.10 fcpang=20
Unregister module bts.3.10 out of database fcpang? [Y/n]y=20
DataBlade bts.3.10 was successfully unregistered from Database fcpang.=20
foghornfp=5Ftcp>register bts.3.10 fcpang=20
Register module bts.3.10 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=20
fcpang.=20
Use 'show last log' for details of failures in module's scripts.=20
foghornfp=5Ftcp>register bts.2.00 fcpang=20
Register module bts.2.00 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
DataBlade bts.2.00 was successfully registered in database fcpang.=20
foghornfp=5Ftcp>unregister bts.2.00 fcpang=20
Unregister module bts.2.00 out of database fcpang? [Y/n]y=20
DataBlade bts.2.00 was successfully unregistered from Database fcpang.=20
foghornfp=5Ftcp>register bts.3.10 fcpang=20
Register module bts.3.10 into database fcpang? [Y/n]y=20
Registering DataBlade module... (may take a while).=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=20
fcpang.=20
Use 'show last log' for details of failures in module's scripts.=20
--------------=20
Database parameters set correctly with bts VP, and sbspaces defined:=20
SBSPACETEMP bts=5Ftemp=20
SBSPACENAME bts=5Fsbspace=20
VPCLASS bts,num=3D3,noyield=20
10fe86d48 26 0x48001 62 5 2048 N SBA informix bts=5Fsbspace=20
10fe88028 27 0xa001 63 1 2048 N U A informix bts=5Ftemp=20
745 kaio 9bts* 04/18 10:05:04 0.1173 94 IO Idle=20
Thanks,=20
Michael Hoffman=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Hi Andreas,
You wrote,=20
> That function [onunload] is incompatible with the BTS blade
To clarify, I do not believe onload and onunload ever supported the=20
blade technology in IDS, so its not an issue specific to bts.=20
Michael,
Sorry to here about your problems with register/unregister/re-register=20
bts.3.10 on Solaris 64 with 12.10.xC4.
I ran this sequence on linux x86=5F64 with 12.10.xC4 and 12.10.xC6 and did =
not see any issues. I went to a Solaris box with 12.10.xC4 and
found there was a failure in unregister and then a failure in the=20
subsequent register of BTS 3.10. However the repro worked on 12.10.xC6=20
on
Solaris 64. BTS has been stable between 12.10.xC4 and 12.10.xC6 and were =
few defects reported and then fixed between the releases
releases. On my first scan I didn't see any defects related to BTS that=20
could explain what was fixed. I did note that the unregister failure=20
was in another subsystem and not in the actual code that unregisters BTS.=20
It is possible the problem was fixed in another component that
I am not aware of.
If you are able to reproduce this issue with 12.10.xC6 on Solaris, you=20
should open a PMR on the issue.
=20
-- Mark.
Mark Ashworth=20
Office phone: +1 (905) 413-5033=20
Email: mailto:ashworth@ca.ibm.com=20
Check out my blog=20
From: "Andreas Legner" <andreas.legner@de.ibm.com>
To: ids@iiug.org
Date: 04/20/2016 03:56 AM
Subject: Re: Re-Register BTS.3.10 fails [37004]
Sent by: ids-bounces@iiug.org
So what would 'show last log' say in these cases, and what would=3D20=20
sysblderrorlog table have?=20
From: "MICHAEL HOFFMAN" <offdisc@gmail.com>=20
To: ids@iiug.org=20
Date: 19.04.2016 19:42=20
Subject: Re-Register BTS.3.10 fails [36997]=20
Sent by: ids-bounces@iiug.org=20
Hi All,=3D20=20
We have an issue with Re-registering the BTS.3.10 blade on Informix=3D20=20
12.10.FC4=3D20=20
under Solaris 10.=3D20=20
We do regular onunloads of our databases for baselining purposes. That=3D20=
=20
function is incompatible with the BTS blade. So before we onunload, we=3D20=
=20
drop=3D20=20
the BTS index and unregister the blade. However, now that we upgraded=20
to=3D20=20
12.10.FC4, we are running into an issue where the re-registration of=20
the=3D20=20
blade=3D20=20
fails.=3D20=20
The error, from 'show last log', is:=3D20=20
blade: bts.3.10=3D20=20
err expct: unexpected=3D20=20
SQL stmt: execute procedure bts=3D5FCreateStorage("bts=3D5Findex", 11);=3D2=
0=20
SQL state: XIX000:-9791 : User Defined Routine (bts=3D5Fcreatestorage)=3D20=
=20
execution=3D20=20
failed.=3D20=20
Interestingly, registering bts.2.00 works fine, and then upgrading to 3.10 =
=3D=20
works!=3D20=20
Here is a screen grab of a full test using blademgr.=3D20=20
Test 1 -- re-register bts.3.10 =3D3D=3D3D> FAIL=3D20=20
Test 2 -- register bts.2.00, unregister & re-register bts.2.00 =3D3D=3D3D> =
SUCC=3D=20
ESS=3D20=20
Test 3 -- register bts.3.10 =3D3D=3D3D> SUCCESS=3D20=20
Test 4 -- unregister & re-register bts.3.10 =3D3D=3D3D> FAIL=3D20=20
Test 5 -- register bts.2.00, unregister & re-register bts.3.10 =3D3D=3D3D> =
FAIL=3D=20
=3D20=20
-----=3D20=20
foghornfp=3D5Ftcp>register bts.3.10 fcpang=3D20=20
Register module bts.3.10 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=3D2=
0=20
fcpang.=3D20=20
Use 'show last log' for details of failures in module's scripts.=3D20=20
foghornfp=3D5Ftcp>register bts.2.00 fcpang=3D20=20
Register module bts.2.00 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
DataBlade bts.2.00 was successfully registered in database fcpang.=3D20=20
foghornfp=3D5Ftcp>unregister bts.2.00 fcpang=3D20=20
Unregister module bts.2.00 out of database fcpang? [Y/n]y=3D20=20
DataBlade bts.2.00 was successfully unregistered from Database fcpang.=3D20=
=20
foghornfp=3D5Ftcp>register bts.2.00 fcpang=3D20=20
Register module bts.2.00 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
DataBlade bts.2.00 was successfully registered in database fcpang.=3D20=20
foghornfp=3D5Ftcp>register bts.3.10 fcpang=3D20=20
Register module bts.3.10 into database fcpang? [Y/n]y=3D20=20
DataBlade module(s) that will be replaced by bts.3.10:=3D20=20
bts.2.00=3D20=20
Are these changes ok? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
DataBlade bts.3.10 was successfully registered in database fcpang.=3D20=20
foghornfp=3D5Ftcp>unregister bts.3.10 fcpang=3D20=20
Unregister module bts.3.10 out of database fcpang? [Y/n]y=3D20=20
DataBlade bts.3.10 was successfully unregistered from Database fcpang.=3D20=
=20
foghornfp=3D5Ftcp>register bts.3.10 fcpang=3D20=20
Register module bts.3.10 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=3D2=
0=20
fcpang.=3D20=20
Use 'show last log' for details of failures in module's scripts.=3D20=20
foghornfp=3D5Ftcp>register bts.2.00 fcpang=3D20=20
Register module bts.2.00 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
DataBlade bts.2.00 was successfully registered in database fcpang.=3D20=20
foghornfp=3D5Ftcp>unregister bts.2.00 fcpang=3D20=20
Unregister module bts.2.00 out of database fcpang? [Y/n]y=3D20=20
DataBlade bts.2.00 was successfully unregistered from Database fcpang.=3D20=
=20
foghornfp=3D5Ftcp>register bts.3.10 fcpang=3D20=20
Register module bts.3.10 into database fcpang? [Y/n]y=3D20=20
Registering DataBlade module... (may take a while).=3D20=20
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database=3D2=
0=20
fcpang.=3D20=20
Use 'show last log' for details of failures in module's scripts.=3D20=20
--------------=3D20=20
Database parameters set correctly with bts VP, and sbspaces defined:=3D20=20
SBSPACETEMP bts=3D5Ftemp=3D20=20
SBSPACENAME bts=3D5Fsbspace=3D20=20
VPCLASS bts,num=3D3D3,noyield=3D20=20
10fe86d48 26 0x48001 62 5 2048 N SBA informix bts=3D5Fsbspace=3D20=20
10fe88028 27 0xa001 63 1 2048 N U A informix bts=3D5Ftemp=3D20=20
745 kaio 9bts* 04/18 10:05:04 0.1173 94 IO Idle=3D20=20
Thanks,=3D20=20
Michael Hoffman=3D20=20
***************************************************************************=
=3D=20
****=3D20=20
Forum Note: Use "Reply" to post a response in the discussion forum.=3D20=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20