SSMV3のDiscoveryでSQL error RC = -7405
Article ID: 256673
Updated On:
Products
OPS/MVS Event Management & Automation
Issue/Introduction
OPSMVSのSSM V2をV3にアップデートしています。Discovery処理を行いましたが、SQL error RC = -7405でエラーになります。
解決方法を教えてください。
なお、実行した手順は以下の通りです。
(1) OPSVIEW で4.11.P.Pを実行して表示される以下の画面で、XxxxPOL1にDIを指定
Policy Administration Xxxx ------- O P S V I E W ------------ 行 1 - 3 / 3
Command ===> Scroll ===> PAGE
Active Policy: XxxxPOL1 System: *
Line Commands: C Copy D Delete DI Discovery E Edit R Remove
CMD Name Policy table Description Status
--- ---------- ------------------ ----------------------------------- ------
ADD I
DI XxxxPOL1 SSM_Xxxx_POL1 Policy 1 : Production I
XxxxPOL2 SSM_Xxxx_POL2 Policy 2 : Disaster Recovery I
XxxxPOL3 SSM_Xxxx_POL3 Policy 3 : Development and Testing I
******************************* Bottom of data ********************************
(2) Dを入力し実行
Xxxx ------ Resource Discovery ------ OPSS
Command ===> D
Add resources to the SSM Policy Manager.
Enter a resource discovery method.
Discovery Method: D
D Run resource discovery utility
S Use existing STC and Action tables
PF3 to exit to SSM Resource List
PF12 to cancel
F1=Help F2=Split F3=Exit F7=Up
F8=Down F9=Swap F12=Cancel
(3) DISCOVER と入力して実行
SSM Discovery-------------- Xxxx -- O P S V I E W ------------- Subsystem OPSS
Command ===> DISCOVER
The Discovery facility scans the current system for active started tasks and
adds them to the SSM POLICY table. Existing policy data is not updated by
this utility.
This process may take several minutes to complete.
After the tables are built, the Resource Policy panel will be invoked to
allow you to view and customize the resulting policy data.
If the resource table specified below does not exist it will be added to
STATEMAN control with an associated action table.
If the table already exists the table and associated action table will not
be updated by this utility.
DISCOVERY RULES DATASET:
Rules DSN ===> 'xxxxxxx.xxxxxxx.CCLXRULM'____________________ (Required)
DISCOVERY INPUT FROM PARMLIB MEMBER LOADF1
SYSPARM ===> F1
DISCOVERY OUTPUT:
Resource table Name ===> SSMXxxx1
Enter DISCOVER to BEGIN DISCOVERY, Press PF3 to EXIT without running DISCOVERY
(4) 以下のメッセージが表示される
SSM Resource List -- Xxxx ----- O P S V I E W ----------- SQL error RC = -7405
Command ===> Scroll ===> CSR
System: * Policy: XxxxPOL1 PolStatus: A Step Through: Y (Y/N)
Commands: ADD REFRESH UPDTYPE TESTSSM COMPARE|IMPORT|LOAD|VERIFY ALL
Line B Browse C Copy CP Compare CT Create user type
Commands: D Delete E Edit I Import L Load U Unload V Verify
Resource Name Type Table Name Status
Filter
******************************* Bottom of data ********************************
Environment
OS : z/OS
Product : OPS/MVS Event Management & Automation
Release : All
Component : OPSMVS
Resolution
エラー7405は、テーブルが存在しないか作成されていないことを示しています。
OPS7405E
OPERATION FAILED. TABLE rdftbl DOES NOT EXIST
まずは、OPSVIEW の2.6で、テーブルの有無を確認してください。
OPSVIEW 4.11.P.PでPolicy tableが作成されていても、OPSVIEW 2.6で表示されない場合は、Policy tableが正しく作成されていない可能性があります。
OPSVIEW 4.11.P.Pで当該Policy tableを再作成してから、OPSVIEW 2.6で確認後に改めてDiscoveryを実施してください。
<ご参考：OPSVIEW 2.6 画面(Policy tableが存在しない)>>
RDF Table Editor ------ RDF Table List for System Xxxx ---- 行 1 - 15 / 15
OPTIONS: Browse Copy Delete Edit Free Insert Rename S(edit) Transfer
MULTI SYS: MCopy MDelete MTransfer
Sel Table New Table
___ COLUMN
___ SSM_MANAGED_POLS
___ SSM_MANAGED_TBLS
___ SSM_TYPE_TBL
___ SSM_UTYPE_TBL
___ SSMXxxx1
___ SSMXxxx1_ACT
___ SSMXxxx2
___ SSMXxxx2_ACT
___ SSMXxxx3
___ SSMXxxx3_ACT
___ TABLE
******************************* Bottom of data ********************************
<ご参考：OPSVIEW 4.11.P.P 画面>
Policy Administration Xxxx ------- O P S V I E W ------------ 行 1 - 3 / 3
Command ===> Scroll ===> PAGE
Active Policy: XxxxPOL1 System: *
Line Commands: C Copy D Delete DI Discovery E Edit R Remove
CMD Name Policy table Description Status
--- ---------- ------------------ ----------------------------------- ------
ADD I
DI XxxxPOL1 SSM_Xxxx_POL1 Policy 1 : Production I
XxxxPOL2 SSM_Xxxx_POL2 Policy 2 : Disaster Recovery I
XxxxPOL3 SSM_Xxxx_POL3 Policy 3 : Development and Testing I
******************************* Bottom of data ********************************
<ご参考：OPSVIEW 2.6 画面(Policy tableが存在する)>
RDF Table Editor ------ RDF Table List for System Xxxx ---- 行 1 -
OPTIONS: Browse Copy Delete Edit Free Insert Rename S(edit) Transf
MULTI SYS: MCopy MDelete MTransfer
Sel Table New Table
___ COLUMN
___ SSM_MANAGED_POLS
___ SSM_MANAGED_TBLS
___ SSM_TYPE_TBL
___ SSM_UTYPE_TBL
___ SSM_Xxxx_POL1
___ SSM_Xxxx_POL2
___ SSM_Xxxx_POL3
___ SSMXxxx1
___ SSMXxxx1_ACT
___ SSMXxxx2
___ SSMXxxx2_ACT
___ SSMXxxx3
___ SSMXxxx3_ACT
___ TABLE
<ご参考：Discoveryの正常完了画面イメージ>
SSM Resource List -- Xxxx ----- O P S V I E W ------------- 行 1 - 24 / 24
Command ===> Scroll ===> CSR
System: * Policy: XxxxPOL1 PolStatus: A Step Through: Y (Y/N)
Commands: ADD REFRESH UPDTYPE TESTSSM COMPARE|IMPORT|LOAD|VERIFY ALL
Line B Browse C Copy CP Compare CT Create user type
Commands: D Delete E Edit I Import L Load U Unload V Verify
Resource Name Type Table Name Status
Filter
APPC APPC SSMXxxx1
ASCH APPC SSMXxxx1
CALDAP CALDAP SSMXxxx1
CCITCP UNKNOWN SSMXxxx1
CCITCPGW UNKNOWN SSMXxxx1
CLEANUP CLEANUP SSMXxxx1
DSIR15 UNKNOWN SSMXxxx1
ENF ENF SSMXxxx1
IZUSVR1 UNKNOWN SSMXxxx1
JES2 JES2 SSMXxxx1
LLA LLA SSMXxxx1
OSNMPD UNKNOWN SSMXxxx1
PORTMAP UNKNOWN SSMXxxx1
RMF RMF SSMXxxx1
SDSF UNKNOWN SSMXxxx1
SDSFAUX UNKNOWN SSMXxxx1
SNMPQE UNKNOWN SSMXxxx1
SYSVIEW SYSVIEW SSMXxxx1
TCPIP TCPIP SSMXxxx1
TSO TSO SSMXxxx1
TSS TSS SSMXxxx1
TSS16 UNKNOWN SSMXxxx1
VLF VLF SSMXxxx1
VTAM VTAM SSMXxxx1
******************************* Bottom of data ********************************
EsssssssssssssssssssssssssssssssssssssssN
e Snapshot COMPLETED for table SSMXxxx1 e
F1=Help F2= DsssssssssssssssssssssssssssssssssssssssM Panl F6=NextPanl
F7=Up F8=Down F9=Swap F10=Tleft F11=Tright F12=Cancel
Additional Information
Old Japanese Knowledge document ID: JTEC003165
OPS/MVSのその他FAQについては、以下のリンクからご確認ください。
Feedback
Yes
No
Powered by
