TNSPING sample JCL [message #113774] |
Mon, 19 November 2001 08:46 |
Chris Conover
Messages: 3 Registered: November 2001
|
Junior Member |
|
|
I would like to try TNSPING from our OS-390 box. I need some sample JCL to do it in batch. Does anyone have some they would share with me? I'm interested in the DDs and the required parameters if any.
Thanks ... Chris
|
|
|
Re: TNSPING sample JCL [message #113776 is a reply to message #113774] |
Mon, 19 November 2001 11:12 |
George Soley
Messages: 14 Registered: July 2001
|
Junior Member |
|
|
//JS010 EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTERM DD DUMMY
//TNSNAMES DD DISP=SHR,DSN=ORACLE.V817.TNSNAMES(TNSNAMES)
//ORA$LIB DD DISP=SHR,DSN=ORACLE.V817.MESG
//SYSTSIN DD *
call 'ORACLE.V817.CMDLOAD(TNSPING)' 'sid1'
|
|
|
Re: TNSPING sample JCL [message #113777 is a reply to message #113776] |
Mon, 19 November 2001 11:40 |
Chris Conover
Messages: 3 Registered: November 2001
|
Junior Member |
|
|
Thanks so much for the example.... I got it to work... Is there a WEB site with the current complete OS-390 docset available, or Oracle press book that deals with this operating system? Thanks again ... Chris
: //JS010 EXEC PGM=IKJEFT01
: //SYSPRINT DD SYSOUT=*
: //SYSTSPRT DD SYSOUT=*
: //SYSTERM DD DUMMY
: //TNSNAMES DD DISP=SHR,DSN=ORACLE.V817.TNSNAMES(TNSNAMES)
: //ORA$LIB DD DISP=SHR,DSN=ORACLE.V817.MESG
: //SYSTSIN DD *
: call 'ORACLE.V817.CMDLOAD(TNSPING)' 'sid1'
|
|
|
|
Re: TNSPING sample JCL [message #113820 is a reply to message #113774] |
Mon, 11 March 2002 00:04 |
Mutu Srinivasan.B
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Hi,
I need a Favour. I am doing a conversion of Database. From Jbase to Oracle. i am not able to get the output of tnsping. can u please tell me the procedure how to do it? I have TNSNAME.ORA file with ADDRESS LIST. can u tell me how to use tnsping.
Mutu
|
|
|