UDB V6.1 question Control Center

[login to unmask email]

UDB V6.1 question Control Center
Does any one know how to terminate a restore from the control center that
is running on a remote location workstation? I think that is really is not
running on the workstation, because I has someone look at the running task
on the NT box and did not see it running, but the control center thinks it
is running. I can see the job in the journal, but it has been running for
over 12 hours and I believe it is not doing anything. I am able to access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



Jeff Faughn

Re: UDB V6.1 question Control Center
(in response to John_Lendman@FPL.COM)
We had the same problem with PC user's running Approach (Lotus equivalent
to Access) when the users would start a query then cancel the Approach
application (alt cntl del) the thread would continue to run on OS/390.
IBM told us that Windows was not returning a message that the thread had
been cancelled to OS/390... : (




John_Lendman@
FPL.COM To: [login to unmask email]
Sent by: DB2 cc:
Data Base Subject: UDB V6.1 question Control Center
Discussion
List
<[login to unmask email]
OM>


09/06/01
08:37 AM
Please
respond to
DB2 Data Base
Discussion
List






Does any one know how to terminate a restore from the control center that
is running on a remote location workstation? I think that is really is not
running on the workstation, because I has someone look at the running task
on the NT box and did not see it running, but the control center thinks it
is running. I can see the job in the journal, but it has been running for
over 12 hours and I believe it is not doing anything. I am able to access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413








Fabrizio Napolitano

Re: UDB V6.1 question Control Center
(in response to Jeff Faughn)
HI there,
I think you can't stop it to be in the Journal, if I remember well it's a
known bug of the CC sometimes it retains entries in the Journal even if they
are finished !
Hope this helps
Fabrizio

-----Original Message-----
From: [login to unmask email]
To: [login to unmask email]
Sent: 9/6/01 3:37 PM
Subject: UDB V6.1 question Control Center

Does any one know how to terminate a restore from the control center
that
is running on a remote location workstation? I think that is really is
not
running on the workstation, because I has someone look at the running
task
on the NT box and did not see it running, but the control center thinks
it
is running. I can see the job in the journal, but it has been running
for
over 12 hours and I believe it is not doing anything. I am able to
access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is
just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can



[login to unmask email]

Re: UDB V6.1 question Control Center
(in response to Fabrizio Napolitano)
Napolitano would you know how in the journal to stop a job? I can not find
a way.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



"Napolitano,
Fabrizio" To: [login to unmask email]
<fnapolitano@I cc:
NSIRIO.IT> Subject: Re: UDB V6.1 question Control Center
Sent by: "DB2
Data Base
Discussion
List"
<[login to unmask email]
M>


09/06/01 10:58
AM
Please respond
to "DB2 Data
Base
Discussion
List"






HI there,
I think you can't stop it to be in the Journal, if I remember well it's a
known bug of the CC sometimes it retains entries in the Journal even if
they
are finished !
Hope this helps
Fabrizio

-----Original Message-----
From: [login to unmask email]
To: [login to unmask email]
Sent: 9/6/01 3:37 PM
Subject: UDB V6.1 question Control Center

Does any one know how to terminate a restore from the control center
that
is running on a remote location workstation? I think that is really is
not
running on the workstation, because I has someone look at the running
task
on the NT box and did not see it running, but the control center thinks
it
is running. I can see the job in the journal, but it has been running
for
over 12 hours and I believe it is not doing anything. I am able to
access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is
just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can








Kurt Sahlberg

Re: UDB V6.1 question Control Center
(in response to John_Lendman@FPL.COM)
John,
The only way to get rid of the job is to rename or delete the db2jobht and db2jobsm files in the DB2DAS00 directory. This is assuming use are using the default directory. These file will get recreated next time you restart and use the Journal.
Let me know if this helped.
Kurt



>>> [login to unmask email] 09/06/01 10:35AM >>>
Napolitano would you know how in the journal to stop a job? I can not find
a way.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



"Napolitano,
Fabrizio" To: [login to unmask email]
<fnapolitano@I cc:
NSIRIO.IT> Subject: Re: UDB V6.1 question Control Center
Sent by: "DB2
Data Base
Discussion
List"
<[login to unmask email]
M>


09/06/01 10:58
AM
Please respond
to "DB2 Data
Base
Discussion
List"






HI there,
I think you can't stop it to be in the Journal, if I remember well it's a
known bug of the CC sometimes it retains entries in the Journal even if
they
are finished !
Hope this helps
Fabrizio

-----Original Message-----
From: [login to unmask email]
To: [login to unmask email]
Sent: 9/6/01 3:37 PM
Subject: UDB V6.1 question Control Center

Does any one know how to terminate a restore from the control center
that
is running on a remote location workstation? I think that is really is
not
running on the workstation, because I has someone look at the running
task
on the NT box and did not see it running, but the control center thinks
it
is running. I can see the job in the journal, but it has been running
for
over 12 hours and I believe it is not doing anything. I am able to
access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is
just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can











[login to unmask email]

Re: UDB V6.1 question Control Center
(in response to Kurt Sahlberg)
Thank you Kurt, once I was able to locate the files you mention, I was able
to rename them and then the job went away. At least you do not see it any
more when you get into the journal for that system.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



"Kurt Sahlberg"
<[login to unmask email] To: [login to unmask email]
ERIAN.COM> cc:
Sent by: "DB2 Data Subject: Re: UDB V6.1 question Control Center
Base Discussion
List"
<[login to unmask email]>


09/06/01 12:11 PM
Please respond to
"DB2 Data Base
Discussion List"






John,
The only way to get rid of the job is to rename or delete the db2jobht and
db2jobsm files in the DB2DAS00 directory. This is assuming use are using
the default directory. These file will get recreated next time you restart
and use the Journal.
Let me know if this helped.
Kurt



>>> [login to unmask email] 09/06/01 10:35AM >>>
Napolitano would you know how in the journal to stop a job? I can not find
a way.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



"Napolitano,
Fabrizio" To: [login to unmask email]
<fnapolitano@I cc:
NSIRIO.IT> Subject: Re: UDB V6.1
question Control Center
Sent by: "DB2
Data Base
Discussion
List"
<[login to unmask email]
M>


09/06/01 10:58
AM
Please respond
to "DB2 Data
Base
Discussion
List"






HI there,
I think you can't stop it to be in the Journal, if I remember well it's a
known bug of the CC sometimes it retains entries in the Journal even if
they
are finished !
Hope this helps
Fabrizio

-----Original Message-----
From: [login to unmask email]
To: [login to unmask email]
Sent: 9/6/01 3:37 PM
Subject: UDB V6.1 question Control Center

Does any one know how to terminate a restore from the control center
that
is running on a remote location workstation? I think that is really is
not
running on the workstation, because I has someone look at the running
task
on the NT box and did not see it running, but the control center thinks
it
is running. I can see the job in the journal, but it has been running
for
over 12 hours and I believe it is not doing anything. I am able to
access
the data on the table that it is supposed to be restoring.

Any help would be great.... I am a mainframe guy and this UDB world is
just
a little different.

John C. Lendman
DBA
[login to unmask email]
(561) 694-5085
Beeper FPL 7413



the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
can


















Rakesh Kumar

UDB Control Center
(in response to John_Lendman@FPL.COM)
If I want to setup the profile such that if the DB2 session(in UDB) is idle
for 20 minutes then it should automatically get disconnected.Can anyone
suggest how can this be done ?


Regards
Rakesh

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com



Marites R Magsino

Re: UDB Control Center
(in response to Rakesh Kumar)
Try to inquire about the db2 governor...

Regards,
Marites R. Magsino
IBM Solutions Delivery, Inc.
an IBM Company
Mobile # (63917) 5354412
e-mail: [login to unmask email],
[login to unmask email]




Rakesh Kumar
<[login to unmask email] To: [login to unmask email]
TMAIL.COM> cc:
Sent by: DB2 Subject: UDB Control Center
Data Base
Discussion
List
<[login to unmask email]
OM>


12/27/01
12:38 PM
Please
respond to
DB2 Data Base
Discussion
List






If I want to setup the profile such that if the DB2 session(in UDB) is idle
for 20 minutes then it should automatically get disconnected.Can anyone
suggest how can this be done ?


Regards
Rakesh

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com








Jeremy Schleicher

Re: UDB Control Center
(in response to Marites R Magsino)
Try creating a governor



From: Rakesh Kumar <[login to unmask email]>@RYCI.COM on 12/26/2001 10:38 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: UDB Control Center


If I want to setup the profile such that if the DB2 session(in UDB) is idle
for 20 minutes then it should automatically get disconnected.Can anyone
suggest how can this be done ?


Regards
Rakesh

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com