• Design
  • Tuning
  • Apache Derby
  • IBM DB2
  • MySQL
  • Oracle
  • SQL Server
  • Installing and running Oracle on IBM z/OS

    You are currently using a web browser that does not support HTML pages with style sheets. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.

    Determine the status of the OSDI subsystem

    The following MVS console commands can be used to determine if the Oracle OSDI subsystem is running.

    DISPLAY SSI DISPLAY SSI,SUBSYS=RRS SUBSYS=RRS DYNAMIC=YES STATUS=ACTIVE COMMANDS=REJECT DISPLAY SSI,SUBSYS=orss SUBSYS=orss DYNAMIC=YES STATUS=ACTIVE COMMANDS=ACCEPT

    The Resource Recovery Services (RRS) subsystem is required for the RRSAF interface used by Oracle. The subsystem name for OSDI (orss above) may be different on different systems.

    If the Oracle subsystem is not included in the display, it needs to be defined with an operator command:

    SETSSI ADD,S=orss,I=ORASSINI,P='....PARMLIB(member)' MIS0020I Oracle subsystem orss initialized. Version:10.02.0.2.00 MIS0196I Service group orss defined MIS0198I Service ORAP10 defined MIS0198I Service ORAN10 defined MIS0195I Service group orss (OSDI Oracle 10G Subsystem - orss) Mode=*SYS , Systems=*ALL Service ORAN10 Type NET (Oracle V10G Net Service) Service ORAP10 Type GTW (Oracle V10G TG4DB2 Service) MIS0193I Service ORAP10 starting MIS0193I Service ORAN10 starting

    Display the names of the OSDI services with:

    orss SHOW SERVICEGROUP LONG MIS0195I Service group orss (OSDI Oracle 10G Subsystem - orss) Mode=*SYS , Systems=*ALL Service ORAN10 Type NET (Oracle V10G Net Service) Service db2gw1 Type GTW (Oracle V10G TG4DB2 Service)

    Display the definition of the Oracle Net service with:

    orss SHOW SERVICE ORAN10 MIS0194I Service ORAN10 Type NET (Oracle V10G Net Service) Proc=ORAN10 , ID=ORAN , Parm='HPNS PORT(1521) ENCLAVE(SESS)' Jobname= , JobAcct=(no accounting) MaxAS=001, Mode=LOCAL , Systems=(none)

    Display the definition of the gateway service with:

    orss SHOW SERVICE db2gw1 MIS0194I Service db2gw1 Type GTW (Oracle V10G TG4DB2 Service) Proc=db2gw1 , ID=db2gw1 , Parm='ORACLE...PARMLIB(member) Jobname= , JobAcct=(no accounting) MaxAS=004, Mode=LOCAL , Systems=(none)

    Display the operational status of the Oracle Net service with:

    orss DISPLAY ORAN10 MIS0308I Service ORAN10 is ACTIVE , 001 address spaces F ORAN10,DIS ALL MIN0200I CID Owner Protocol Address MIN0201I nnnnnnnn ORAN10 TCP 010.001.001.nnn/nnnnn MIN0201I nnnnnnnn ORAN10 TCP 010.001.001.nnn/nnnnn

    Display the operational status of the gateway service with:

    orss DISPLAY db2gw1 MIS0308I Service db2gw1 is ACTIVE , 001 address spaces

    Services can be stopped and started with these commands:

    orss STOP ORAN10 [FORCE] orss STOP db2gw1 [FORCE] SETSSI DEACT,SUBNAME=orss
    SETSSI ACT,SUBNAME=orss orss START db2gw1 orss START ORAN10

    There are also DRAIN and RESUME commands which block and unblock new incoming connections through the gateway.

    Last updated Monday October 23, 2006


    Printer-friendly PDF* format:

    Oracle on IBM z/OS

    This Section

    You are currently viewing this page in XHTML 2 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML Style Sheet*XHTML 1* XML* HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.