Coolgen Error TIRM030E

steve mallett

Coolgen Error TIRM030E
A few weeks ago we were asked to backout some table changes during the day
(with CICS up). I believe it was data only.

Subsequently all the CICS users got the following messages when they tried
to use Applications sharing these tables

TIRM030E: Application failed - Updates have been backed out
ODC: (Transport-10061:-1) executing "connect" on xx01 in IPHost::connHost
().

There all Coolgen applications and the 'xx01' part is the mainframe name.

For some reason we could only get rid of it by performing a cold start on
CICS region - several warm starts didn't take.

Anyone got any ideas?

TIA,
Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

steve mallett

Re: Coolgen Error TIRM030E
(in response to steve mallett)
I'd like to post this one again, doesn't even look like a Mainframe Error
to me and couldn't find anything in the mainframe logs: I guess I'm really
asking what's the difference for Db2 between cols and warm CICS starts?


A few weeks ago we were asked to backout some table changes during the day
(with CICS up). I believe it was data only.

Subsequently all the CICS users got the following messages when they tried
to use Applications sharing these tables

TIRM030E: Application failed - Updates have been backed out
ODC: (Transport-10061:-1) executing "connect" on xx01 in IPHost::connHost
().

They are all Coolgen applications and the 'xx01' part is the mainframe
name.

For some reason we could only get rid of it by performing a cold start on
CICS region - several warm starts didn't take.

Anyone got any ideas?
>
>TIA,
>Steve
>
>--------------------------------------------------------------------------
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". If you will be out of the office, send
the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List
Admins can be reached at [login to unmask email] Find out the
latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Bednarz

Re: Coolgen Error TIRM030E
(in response to steve mallett)
Hi Steve,

did you contact CA - Support?

Michael

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve
Sent: Freitag, 9. Januar 2004 03:12
To: [login to unmask email]
Subject: Re: Coolgen Error TIRM030E

I'd like to post this one again, doesn't even look like a Mainframe
Error to me and couldn't find anything in the mainframe logs: I guess
I'm really asking what's the difference for Db2 between cols and warm
CICS starts?


A few weeks ago we were asked to backout some table changes during the
day (with CICS up). I believe it was data only.

Subsequently all the CICS users got the following messages when they
tried to use Applications sharing these tables

TIRM030E: Application failed - Updates have been backed out
ODC: (Transport-10061:-1) executing "connect" on xx01 in
IPHost::connHost ().

They are all Coolgen applications and the 'xx01' part is the mainframe
name.

For some reason we could only get rid of it by performing a cold start
on CICS region - several warm starts didn't take.

Anyone got any ideas?
>
>TIA,
>Steve
>
>-----------------------------------------------------------------------
>---
-------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". If you will be out of the office,
send the SET DB2-L NOMAIL command to [login to unmask email] The
IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

steve mallett

Re: Coolgen Error TIRM030E
(in response to Michael Bednarz)
I don't think so - why have you guys got Cool:gen now as well?

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUDG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Bednarz

Re: Coolgen Error TIRM030E
(in response to steve mallett)
Hi Steve,
yes we got it! I think probably over a year ago.

Regards Michael.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve
Sent: Samstag, 10. Januar 2004 02:21
To: [login to unmask email]
Subject: Re: Coolgen Error TIRM030E

I don't think so - why have you guys got Cool:gen now as well?

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUDG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Rich Gugel

Re: Coolgen Error TIRM030E
(in response to Michael Bednarz)
-----Original Message-----
From: Bednarz, Michael P [mailto:[login to unmask email]
Sent: Monday, January 12, 2004 3:55 AM
To: [login to unmask email]
Subject: Re: Coolgen Error TIRM030E


Hi Steve,
yes we got it! I think probably over a year ago.

Regards Michael.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve
Sent: Samstag, 10. Januar 2004 02:21
To: [login to unmask email]
Subject: Re: Coolgen Error TIRM030E

I don't think so - why have you guys got Cool:gen now as well?

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUDG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Rich Gugel

Re: Coolgen Error TIRM030E
(in response to Rich Gugel)
Here is a clip from the CICS documentation describing what a cold start is:

"In CICS TS for OS/390, a cold start means that log information about local
resources is erased, and resource definitions are reinstalled from the CSD
or from CICS tables. However, resynchronization information relating to
remote systems or to RMI-connected resource managers is preserved. The CICS
log is scanned during startup, and information regarding unit of work
obligations to remote systems, or to non-CICS resource managers (such as
DB2¦) connected through the RMI, is preserved. (That is, any decisions about
the outcome of local UOWs, needed to allow remote systems or RMI resource
managers to resynchronize their resources, are preserved.)"

There is another from of cold start called an initial start which does not
even attempt to resolve the units of work. CICS programmers sometimes use
these terms interchangably you may want to find out which one they
performed.


The error meesage your were seeing has a code of 10061 - econnrefused which
makes me think your application was having a tcpip issue when connecting to
CICS. The following link documents the return code.

http://www.sockets.com/err_lst1.htm


TIRM030E: Application failed - Updates have been backed out
ODC: (Transport-10061:-1) executing "connect" on xx01 in IPHost::connHost
().

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

steve mallett

Re: Coolgen Error TIRM030E
(in response to Rich Gugel)
Thanks Rich,

That is most helpful.

Of course it raises a few more questions for us but now at least we can
see where that particular error was coming from.

I'm fairly new to this site and wasn't actually personally involved with
this at the time but the change backout which caused the problem involved
the DBAs performing a data Restore operation for a simple table. In the
light of this network error there must have also been some related non-DB2
changes which were backed out by other groups. A DB2 data restore couldn't
give rise to a network error could it?

Regards,
Steve

Oh and PS: it's because I'm fairly new here that I didn't realise Cool:gen
ownership had changed since I left my last Cool:gen site a couple of years
ago. Hard to keep up with all the 3rd party vendors nowadays.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm