Cisco Transport Manager データベース スキーマ Release7.1追補
データベース スキーマ ビュー
データベース スキーマ ビュー
発行日;2012/02/07 | ドキュメントご利用ガイド | ダウンロード ; この章pdf , ドキュメント全体pdf (PDF - 630KB) | フィードバック

目次

データベース スキーマ ビュー

データベース スキーマ ビュー

新しい情報は、次の項で説明します。

「Cisco 7600 NE ビュー」

CTM 7.0 の機能(『 Cisco Transport Manager Release 7.0 Database Schema 』に記載)の変更点は、次の項で説明します。

「変更点」

2.1 Cisco 7600 NE ビュー

2.1.1 DOM_Info_View

create or replace view DOM_INFO_VIEW as
select
eqpt.nedbaccessid as neid,
eqpt.col30 as interfacename,
eqpt.col31 as sensor,
eqpt.col32 as value,
eqpt.col33 as refreshinterval,
eqpt.col34 as threshold1,
eqpt.col35 as enable_threshold1,
eqpt.col36 as threshold2,
eqpt.col37 as enable_threshold2,
eqpt.col38 as threshold3,
eqpt.col39 as enable_threshold3,
eqpt.col40 as threshold4,
eqpt.col41 as enable_threshold4
from
eqpt_info_table eqpt
where
eqpt.objectindex = 18000;
 

2.1.2 IOS7600_Flash_File_View

CREATE OR REPLACE VIEW IOS7600_FLASH_FILE_VIEW AS
SELECT
eqpt.nedbaccessid AS NESysId,
eqpt.col30 AS FLASHPARTNAME,
eqpt.col31 AS FLASHFILENAME,
eqpt.col33 AS FLASHFILESTATUS,
eqpt.col34 AS FLASHFILESIZE,
eqpt.col35 AS FLASHFILECHECKSUM
FROM
eqpt_info_table eqpt
WHERE
eqpt.objectindex = 18000;
 

2.1.3 IOS7600_Interface_View

CREATE OR REPLACE VIEW IOS7600_INTERFACE_VIEW AS
SELECT
ne.NESysId as NEDBACCESSID,
if.IFID as IFNAME,
if.IFSHUTDOWN as IFSHUTDOWN,
if.OPER_STATUS as OPER_STATUS
FROM
ne_info_table ne,
hfr_common_interface_config if
WHERE
ne.NEDBACCESSID = if.NEDBACCESSID AND
ne.NEModelType = 37;
 
commit;

2.1.4 IOS7600_Inventory_View

CREATE OR REPLACE VIEW IOS7600_inventory_view AS
SELECT
ne.NESysId as NEID,
eit.PhysicalLoc as PhysicalLoc,
eit.Col16 as ModuleName,
eit.Col4 as Description,
eit.Col3 as PhysicalName,
eit.Col5 as HardwareRev,
eit.Col6 as FirmwareRev,
eit.Col7 as SoftwareRev,
eit.Col8 as SerialNumber,
eit.Col9 as MfgName,
eit.Col10 as ModelName,
eit.Col11 as Alias,
eit.Col12 as AssetID,
eit.Col13 as PartNumber,
eit.Col14 as CleiCode,
eit.Col1 as FRU,
eit.Col17 as OperStatus,
ne.NEDBAccessId as NEDBACCESSID,
eit.rowid as myrow,
eit.COL15 as Type,
eit.IFINDEX as IfIndex,
eit.moduletype as ModuleType
FROM
ne_info_table ne,
eqpt_info_table eit
WHERE
ne.NEDBAccessId = eit.NEDBAccessId AND
eit.modeltype = 37 AND
eit.moduletype != 8 AND
eit.moduletype != 10;
 

2.1.5 Syslog_Message_View

create or replace view SYSLOG_MESSAGE_VIEW AS
SELECT
sm.message_id,
nvl,
sm.timestamp,
sm.facility,
sm.subfacility,
sm.severity,
sm.mnemonic,
sm.description,
sm.ne_id
FROM
ne_info_table ni,
syslog_message_table sm
WHERE
sm.NE_ID = ni.NEDBAccessID(+);
 

2.1.6 Template_NE_View

create or replace template_ne_view as
select
DISTINCT
nit.NEDBACCESSID,
nit.NESYSID,
mtt.MODELTYPENAME,
nit.NEVERSION
from
NE_INFO_TABLE nit,
MODEL_TYPE_TABLE mtt
where
nit.NEMODELTYPE = mtt.MODELTYPE ;
 

2.1.7 Template_Version_View

create or replace template_version_view as
select
DISTINCT
vt.NETYPE,
mtt.MODELTYPENAME,
vt.SOFTWAREVERSION
from
VERSION_TABLE vt,
MODEL_TYPE_TABLE mtt
where
vt.NETYPE = mtt.MODELTYPE ;

2.2 変更点

この項に記載された変更は、すべて『 Cisco Transport Manager Release 7.0 Database Schema 』の対応する項に適用されます。


) この文書の項の表題は『Cisco Transport Manager Release 7.0 Database Schema』の項の名前と対応していますが、項の番号は異なる場合があります。この文書の各項にあるリンク テキストをクリックすると、『Cisco Transport Manager Release 7.0 Database Schema』の対応する項に直接移動できます。


2.2.1 CIRCUIT_CTP_XC_VIEW

CTM Base Views 」の項にある項目「 CIRCUIT_CTP_XC_VIEW 」は、次の情報で置き換えます。

CREATE OR REPLACE VIEW CIRCUIT_CTP_XC_VIEW AS
SELECT DISTINCT
b.CKTNAME as CktName,
a.CKTNODEID as NodeId,
a.CKTUNIQUEID as UniqueId,
a.CKTCTPNODEID as NENodeId,
a.CKTCTPNEDBACCESSID as NEDBAccessId,
b.CKTDIRECTION as CktDirection,
b.CKTTYPE as CktType,
b.CKTSIZE as CktSize
 
from circuit_ctp_tbl a,
circuit_bs_tbl b,
circuit_ctp_tbl z
where
a.CTPACCESSID != z.CTPACCESSID and
a.CKTCTPNODEID = z.CKTCTPNODEID and
a.CKTNODEID = z.CKTNODEID and
a.CKTUNIQUEID = z.CKTUNIQUEID and
a.CKTNODEID = b.CKTNODEID and
a.CKTUNIQUEID = b.CKTUNIQUEID and
b.CKTSTATE != 12 and
b.CKTTYPE not in (5, 6, 21, 22);