Home » Infrastructure » Other Operating Systems » TNSPING sample JCL
TNSPING sample JCL [message #113774] Mon, 19 November 2001 08:46 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #113778 is a reply to message #113777] Mon, 19 November 2001 12:27 Go to previous messageGo to next message
George Soley
Messages: 14
Registered: July 2001
Junior Member
You can find most OS/390 doc at http://www-1.ibm.com/servers/s390/os390/bkserv/ .

Your installation should have already received complete documantation CD's from IBM .

Oracle doc can be found in the Technical Libraries on Metalink.
Re: TNSPING sample JCL [message #113820 is a reply to message #113774] Mon, 11 March 2002 00:04 Go to previous message
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
Previous Topic: Re: Export problem
Next Topic: Oracle 8i and 9i over Netware
Goto Forum:
  


Current Time: Thu Mar 28 06:27:40 CDT 2024