Start Procedure

Robert J. Milonas

Start Procedure
I run the command -START PROCEDURE (SYSPROC.XRJM9956)
It comes back with

DSNX946I ¢ DSNX9ST2 START PROCEDURE SUCCESSFUL FOR SYSPROC.XRJM9956
DSN9022I ¢ DSNX9COM '-START PROC' NORMAL COMPLETION

But when I reun -DISPLAY PROCEDURE It doesn't show up:

DSNX940I ¢ DSNX9DIS DISPLAY PROCEDURE REPORT FOLLOWS -
------- SCHEMA=SYSPROC
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
DSNTPSMP STARTED 0 0 0 0 DBT0#SPB
------- SCHEMA=WSES
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
GETGRP STARTED 0 0 0 0 DBT0#TEST
PROC2 STARTED 0 0 0 0 DBT0#TEST
PROC3 STARTED 0 0 0 0
DSNX9DIS DISPLAY PROCEDURE REPORT COMPLETE
DSN9022I ¢ DSNX9COM '-DISPLAY PROC' NORMAL COMPLETION
***

***

It did show up as started a few days ago.
Any Ideas???????????
--




__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [login to unmask email]! http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/



Wayne Driscoll

Re: Start Procedure
(in response to Robert J. Milonas)
Robert,
From what I have seen, the DISPLAY PROCEDURE command only displays
procedures that have been invoked since the last time that DB2 was started.
Wayne Driscoll
Product Developer
Quest Software Inc.
[login to unmask email]
Note: All opinions are strictly my own.

-----Original Message-----
From: Robert J. Milonas [mailto:[login to unmask email]
Sent: Thursday, January 10, 2002 11:09 AM
To: [login to unmask email]
Subject: [DB2-L] Start Procedure


I run the command -START PROCEDURE (SYSPROC.XRJM9956)
It comes back with

DSNX946I ¢ DSNX9ST2 START PROCEDURE SUCCESSFUL FOR SYSPROC.XRJM9956
DSN9022I ¢ DSNX9COM '-START PROC' NORMAL COMPLETION

But when I reun -DISPLAY PROCEDURE It doesn't show up:

DSNX940I ¢ DSNX9DIS DISPLAY PROCEDURE REPORT FOLLOWS -
------- SCHEMA=SYSPROC
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
DSNTPSMP STARTED 0 0 0 0 DBT0#SPB
------- SCHEMA=WSES
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
GETGRP STARTED 0 0 0 0 DBT0#TEST
PROC2 STARTED 0 0 0 0 DBT0#TEST
PROC3 STARTED 0 0 0 0
DSNX9DIS DISPLAY PROCEDURE REPORT COMPLETE
DSN9022I ¢ DSNX9COM '-DISPLAY PROC' NORMAL COMPLETION
***

***

It did show up as started a few days ago.
Any Ideas???????????
--

Suresh Sane

Re: Start Procedure
(in response to Wayne Driscoll)
Robert,

Are you in a data sharing mode? If so, try adding:

SCOPE(GROUP)

at the end to show all data sharing members.

HTH.

Suresh


>From: Wayne Driscoll <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: Start Procedure
>Date: Thu, 10 Jan 2002 10:08:48 -0800
>
>Robert,
>From what I have seen, the DISPLAY PROCEDURE command only displays
>procedures that have been invoked since the last time that DB2 was started.
>Wayne Driscoll
>Product Developer
>Quest Software Inc.
>[login to unmask email]
>Note: All opinions are strictly my own.
>
>-----Original Message-----
>From: Robert J. Milonas [mailto:[login to unmask email]
>Sent: Thursday, January 10, 2002 11:09 AM
>To: [login to unmask email]
>Subject: [DB2-L] Start Procedure
>
>
>I run the command -START PROCEDURE (SYSPROC.XRJM9956)
>It comes back with
>
>DSNX946I ¢ DSNX9ST2 START PROCEDURE SUCCESSFUL FOR SYSPROC.XRJM9956
>DSN9022I ¢ DSNX9COM '-START PROC' NORMAL COMPLETION
>
>But when I reun -DISPLAY PROCEDURE It doesn't show up:
>
>DSNX940I ¢ DSNX9DIS DISPLAY PROCEDURE REPORT FOLLOWS -
>------- SCHEMA=SYSPROC
>PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
>DSNTPSMP STARTED 0 0 0 0 DBT0#SPB
>------- SCHEMA=WSES
>PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
>GETGRP STARTED 0 0 0 0 DBT0#TEST
>PROC2 STARTED 0 0 0 0 DBT0#TEST
>PROC3 STARTED 0 0 0 0
>DSNX9DIS DISPLAY PROCEDURE REPORT COMPLETE
>DSN9022I ¢ DSNX9COM '-DISPLAY PROC' NORMAL COMPLETION
>***
>
>***
>
>It did show up as started a few days ago.
>Any Ideas???????????
>--


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com



Mark Ediger

Re: Start Procedure
(in response to Suresh Sane)
Run the command -DISPLAY PROCEDURE(SYSPROC.XRJM9956) and you will see it
before it has been invoked.

Mark Ediger
Acxiom Corp.
(312) 985-3237

>>> [login to unmask email] 01/10/02 11:09AM >>>
I run the command -START PROCEDURE (SYSPROC.XRJM9956)
It comes back with

DSNX946I ¢ DSNX9ST2 START PROCEDURE SUCCESSFUL FOR SYSPROC.XRJM9956
DSN9022I ¢ DSNX9COM '-START PROC' NORMAL COMPLETION

But when I reun -DISPLAY PROCEDURE It doesn't show up:

DSNX940I ¢ DSNX9DIS DISPLAY PROCEDURE REPORT FOLLOWS -
------- SCHEMA=SYSPROC
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
DSNTPSMP STARTED 0 0 0 0 DBT0#SPB
------- SCHEMA=WSES
PROCEDURE STATUS ACTIVE QUEUED MAXQUE TIMEOUT WLM_ENV
GETGRP STARTED 0 0 0 0 DBT0#TEST
PROC2 STARTED 0 0 0 0 DBT0#TEST
PROC3 STARTED 0 0 0 0
DSNX9DIS DISPLAY PROCEDURE REPORT COMPLETE
DSN9022I ¢ DSNX9COM '-DISPLAY PROC' NORMAL COMPLETION
***

***

It did show up as started a few days ago.
Any Ideas???????????
--




__________________________________________________________________
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with [login to unmask email]!
http://shopnow.netscape.com/

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/



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