com.tivoli.twg.inventory
Class TWGPciDeviceTable

java.lang.Object
  extended bycom.tivoli.twg.engine.TWGObject
      extended bycom.tivoli.twg.engine.TWGPersistentObject
          extended bycom.tivoli.twg.engine.TWGDatabaseTable
              extended bycom.tivoli.twg.inventory.TWGPciDeviceTable

public class TWGPciDeviceTable
extends TWGDatabaseTable

SQL database table for PCI Device information

Primary key - MANAGED_OBJ_ID, PCI_BUS_NUMBER, PCI_SLOT_NUMBER, PCI_DEVICE_NUMBER

TWG_PCI_DEVICE
Field Name Data Type Description NT/2000 95/98 OS/2 Netware AS/400 SNMP AIX HPUX Solaris Unixware Linux
MANAGED_OBJ_ID INT Managed object id X X X X
PCI_BUS_NUMBER INT Bus number X X X X
PCI_SLOT_NUMBER INT Slot number X X X X
PCI_DEVICE_NUMBER INT Device number X X X X
MANUFACTURER CHAR(40) Manufacturer X X X X
PCI_TYPE CHAR(40) Type - ENUM1 X X X X
CLASS_CODE INT Class code X X X X
VENDOR_ID INT Vendor ID X X X X
DEVICE_ID INT Device ID X X X X
REVISION_ID INT Revision ID X X X X
CACHE_LINE_SIZE INT Cache line size X X X X
LATENCY_TIMER INT Latency timer X X X X
MIN_GNT INT Minimum GNT X X X X
MAX_LAT INT Maximum LAT X X X X
INTERRUPT_LINE INT Interrupt line X X X X
INTERRUPT_PIN INT Interrupt pin X X X X
ROM_BASE_ADDRESS INT Base ROM address X X X X
HEADER_TYPE INT Header type X X X X
BIST INT Built-In-Self-Test X X X X
COMMAND_REGISTER INT Command register X X X X
STATUS_REGISTER INT Status register X X X X
SUBVENDORID INT Status register X X X X
SUBSYSTEMID INT Status register X X X X

1 Note: Data values like PCI_TYPE_*; see static variables below


Field Summary
static java.lang.String BIST
           
static java.lang.String CACHE_LINE_SIZE
           
static java.lang.String CLASS_CODE
           
static java.lang.String COMMAND_REGISTER
           
static java.lang.String DEVICE_ID
           
static java.lang.String HEADER_TYPE
           
static java.lang.String INTERRUPT_LINE
           
static java.lang.String INTERRUPT_PIN
           
static java.lang.String LATENCY_TIMER
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String MANUFACTURER
           
static java.lang.String MAX_LAT
           
static java.lang.String MIN_GNT
           
static java.lang.String PCI_BUS_NUMBER
           
static java.lang.String PCI_DEVICE_NUMBER
           
static java.lang.String PCI_SLOT_NUMBER
           
static java.lang.String PCI_TYPE
           
static java.lang.String PCI_TYPE_BRIDGE_HOST_PCI
           
static java.lang.String PCI_TYPE_BRIDGE_OTHER
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_CARDBUS
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_EISA
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_ISA
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_MCA
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_NUBUS
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_PCI
           
static java.lang.String PCI_TYPE_BRIDGE_PCI_PCMCIA
           
static java.lang.String PCI_TYPE_COMM_OTHER
           
static java.lang.String PCI_TYPE_COMM_PARALLEL
           
static java.lang.String PCI_TYPE_COMM_SERIAL
           
static java.lang.String PCI_TYPE_DISPLAY_OTHER
           
static java.lang.String PCI_TYPE_DISPLAY_VGA
           
static java.lang.String PCI_TYPE_DISPLAY_XGA
           
static java.lang.String PCI_TYPE_DOCKING_GENERIC
           
static java.lang.String PCI_TYPE_DOCKING_OTHER
           
static java.lang.String PCI_TYPE_INPUT_KEYBOARD
           
static java.lang.String PCI_TYPE_INPUT_MOUSE
           
static java.lang.String PCI_TYPE_INPUT_OTHER
           
static java.lang.String PCI_TYPE_INPUT_PEN
           
static java.lang.String PCI_TYPE_MEMORY_FLASH
           
static java.lang.String PCI_TYPE_MEMORY_OTHER
           
static java.lang.String PCI_TYPE_MEMORY_RAM
           
static java.lang.String PCI_TYPE_MULTIMEDIA_AUDIO
           
static java.lang.String PCI_TYPE_MULTIMEDIA_OTHER
           
static java.lang.String PCI_TYPE_MULTIMEDIA_VIDEO
           
static java.lang.String PCI_TYPE_NETWORK_ATM
           
static java.lang.String PCI_TYPE_NETWORK_ETHERNET
           
static java.lang.String PCI_TYPE_NETWORK_FDDI
           
static java.lang.String PCI_TYPE_NETWORK_OTHER
           
static java.lang.String PCI_TYPE_NETWORK_TOKEN
           
static java.lang.String PCI_TYPE_OTHER
           
static java.lang.String PCI_TYPE_PRE_REV_20
           
static java.lang.String PCI_TYPE_SERIAL_ACCESS
           
static java.lang.String PCI_TYPE_SERIAL_FIBER
           
static java.lang.String PCI_TYPE_SERIAL_FIREWIRE
           
static java.lang.String PCI_TYPE_SERIAL_OTHER
           
static java.lang.String PCI_TYPE_SERIAL_SSA
           
static java.lang.String PCI_TYPE_SERIAL_USB
           
static java.lang.String PCI_TYPE_STORAGE_FLOPPY
           
static java.lang.String PCI_TYPE_STORAGE_IDE
           
static java.lang.String PCI_TYPE_STORAGE_IPI
           
static java.lang.String PCI_TYPE_STORAGE_OTHER
           
static java.lang.String PCI_TYPE_STORAGE_RAID
           
static java.lang.String PCI_TYPE_STORAGE_SCSI
           
static java.lang.String PCI_TYPE_SYSTEM_DMA
           
static java.lang.String PCI_TYPE_SYSTEM_OTHER
           
static java.lang.String PCI_TYPE_SYSTEM_PIC
           
static java.lang.String PCI_TYPE_SYSTEM_RTC
           
static java.lang.String PCI_TYPE_SYSTEM_TIMER
           
static java.lang.String PCI_TYPE_UNKNOWN
           
static java.lang.String REVISION_ID
           
static java.lang.String ROM_BASE_ADDRESS
           
static java.lang.String STATUS_REGISTER
           
static java.lang.String SUBSYSTEMID
           
static java.lang.String SUBVENDORID
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String VENDOR_ID
           
 
Fields inherited from class com.tivoli.twg.engine.TWGDatabaseTable
CLASSNAME, DbKeyWords, DEFAULT_TABLE_BUNDLE_NAME, validChars
 
Fields inherited from class com.tivoli.twg.engine.TWGPersistentObject
CLASS_NAME, SIZEOF_BYTE, SIZEOF_CHAR, SIZEOF_DOUBLE, SIZEOF_FLOAT, SIZEOF_INT, SIZEOF_LONG, SIZEOF_SHORT
 
Constructor Summary
TWGPciDeviceTable()
           
 
Method Summary
 void create()
          Abstract method must be overriden by subclass to define the table.
 java.lang.String getTableVersion()
          Abstract method must be overriden by subclass to get the version for table
 
Methods inherited from class com.tivoli.twg.engine.TWGDatabaseTable
deleteManagedObject, deleteTable, findTableByClassName, flatten, getAllFullColumnNames, getAllTrue, getAllTrueForSame, getAnyTrue, getBundleName, getBundleString, getColumn, getColumnByColumnRealName, getColumnLength, getColumnLength, getColumnLengths, getColumns, getColumnType, getColumnType, getColumnTypes, getDatabase, getDefaultValue, getDefaultValue, getDefaultValues, getDisplayColumnName, getDisplayFullColumnNames, getDisplayName, getDisplayValues, getEachTrueForAtLeastOne, getFilterColumns, getFilterPrompt, getFilterSQL, getGraphicName, getKey, getMatchingMoids, getMultiLocaleBundle, getMyClassName, getNumberOfColumns, getRealColumnName, getRealColumnName, getRealColumnNames, getRealName, getShortClassName, getTable, getTableBy, getTableByRealTableName, getTableInfo, getTableMultiLocaleBundle, getTableName, getTables, getTokenColumnNames, getTokenName, insertOrDeleteRow, insertRow, isFilterColumn, isMappedColumn, restoreData, saveData, setShortTableName, toString, TWGInitTable, userTableFixClassName
 
Methods inherited from class com.tivoli.twg.engine.TWGPersistentObject
Destroy, enableAsyncWrites, fromPersistID, initialize, isNewPersistentStore, isSaveRequired, PersistID, restore, restoreAll, save, save, setSaveRequired, terminate, toPersistID
 
Methods inherited from class com.tivoli.twg.engine.TWGObject
AllObjects, AllObjects, Delete, DumpTWGObjects, FindObject, isDeleted, isNewObject, isPersistent, isPersistent, isValid, isValid, ObjectID, setDistinctObjectID, SetObjectID
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values

MANAGED_OBJ_ID

public static final java.lang.String MANAGED_OBJ_ID
See Also:
Constant Field Values

PCI_BUS_NUMBER

public static final java.lang.String PCI_BUS_NUMBER
See Also:
Constant Field Values

PCI_SLOT_NUMBER

public static final java.lang.String PCI_SLOT_NUMBER
See Also:
Constant Field Values

PCI_DEVICE_NUMBER

public static final java.lang.String PCI_DEVICE_NUMBER
See Also:
Constant Field Values

MANUFACTURER

public static final java.lang.String MANUFACTURER
See Also:
Constant Field Values

PCI_TYPE

public static final java.lang.String PCI_TYPE
See Also:
Constant Field Values

CLASS_CODE

public static final java.lang.String CLASS_CODE
See Also:
Constant Field Values

VENDOR_ID

public static final java.lang.String VENDOR_ID
See Also:
Constant Field Values

DEVICE_ID

public static final java.lang.String DEVICE_ID
See Also:
Constant Field Values

REVISION_ID

public static final java.lang.String REVISION_ID
See Also:
Constant Field Values

CACHE_LINE_SIZE

public static final java.lang.String CACHE_LINE_SIZE
See Also:
Constant Field Values

LATENCY_TIMER

public static final java.lang.String LATENCY_TIMER
See Also:
Constant Field Values

MIN_GNT

public static final java.lang.String MIN_GNT
See Also:
Constant Field Values

MAX_LAT

public static final java.lang.String MAX_LAT
See Also:
Constant Field Values

INTERRUPT_LINE

public static final java.lang.String INTERRUPT_LINE
See Also:
Constant Field Values

INTERRUPT_PIN

public static final java.lang.String INTERRUPT_PIN
See Also:
Constant Field Values

ROM_BASE_ADDRESS

public static final java.lang.String ROM_BASE_ADDRESS
See Also:
Constant Field Values

HEADER_TYPE

public static final java.lang.String HEADER_TYPE
See Also:
Constant Field Values

BIST

public static final java.lang.String BIST
See Also:
Constant Field Values

COMMAND_REGISTER

public static final java.lang.String COMMAND_REGISTER
See Also:
Constant Field Values

STATUS_REGISTER

public static final java.lang.String STATUS_REGISTER
See Also:
Constant Field Values

SUBVENDORID

public static final java.lang.String SUBVENDORID
See Also:
Constant Field Values

SUBSYSTEMID

public static final java.lang.String SUBSYSTEMID
See Also:
Constant Field Values

PCI_TYPE_UNKNOWN

public static final java.lang.String PCI_TYPE_UNKNOWN
See Also:
Constant Field Values

PCI_TYPE_OTHER

public static final java.lang.String PCI_TYPE_OTHER
See Also:
Constant Field Values

PCI_TYPE_PRE_REV_20

public static final java.lang.String PCI_TYPE_PRE_REV_20
See Also:
Constant Field Values

PCI_TYPE_STORAGE_SCSI

public static final java.lang.String PCI_TYPE_STORAGE_SCSI
See Also:
Constant Field Values

PCI_TYPE_STORAGE_IDE

public static final java.lang.String PCI_TYPE_STORAGE_IDE
See Also:
Constant Field Values

PCI_TYPE_STORAGE_FLOPPY

public static final java.lang.String PCI_TYPE_STORAGE_FLOPPY
See Also:
Constant Field Values

PCI_TYPE_STORAGE_IPI

public static final java.lang.String PCI_TYPE_STORAGE_IPI
See Also:
Constant Field Values

PCI_TYPE_STORAGE_RAID

public static final java.lang.String PCI_TYPE_STORAGE_RAID
See Also:
Constant Field Values

PCI_TYPE_STORAGE_OTHER

public static final java.lang.String PCI_TYPE_STORAGE_OTHER
See Also:
Constant Field Values

PCI_TYPE_NETWORK_ETHERNET

public static final java.lang.String PCI_TYPE_NETWORK_ETHERNET
See Also:
Constant Field Values

PCI_TYPE_NETWORK_TOKEN

public static final java.lang.String PCI_TYPE_NETWORK_TOKEN
See Also:
Constant Field Values

PCI_TYPE_NETWORK_FDDI

public static final java.lang.String PCI_TYPE_NETWORK_FDDI
See Also:
Constant Field Values

PCI_TYPE_NETWORK_ATM

public static final java.lang.String PCI_TYPE_NETWORK_ATM
See Also:
Constant Field Values

PCI_TYPE_NETWORK_OTHER

public static final java.lang.String PCI_TYPE_NETWORK_OTHER
See Also:
Constant Field Values

PCI_TYPE_DISPLAY_VGA

public static final java.lang.String PCI_TYPE_DISPLAY_VGA
See Also:
Constant Field Values

PCI_TYPE_DISPLAY_XGA

public static final java.lang.String PCI_TYPE_DISPLAY_XGA
See Also:
Constant Field Values

PCI_TYPE_DISPLAY_OTHER

public static final java.lang.String PCI_TYPE_DISPLAY_OTHER
See Also:
Constant Field Values

PCI_TYPE_MULTIMEDIA_VIDEO

public static final java.lang.String PCI_TYPE_MULTIMEDIA_VIDEO
See Also:
Constant Field Values

PCI_TYPE_MULTIMEDIA_AUDIO

public static final java.lang.String PCI_TYPE_MULTIMEDIA_AUDIO
See Also:
Constant Field Values

PCI_TYPE_MULTIMEDIA_OTHER

public static final java.lang.String PCI_TYPE_MULTIMEDIA_OTHER
See Also:
Constant Field Values

PCI_TYPE_MEMORY_RAM

public static final java.lang.String PCI_TYPE_MEMORY_RAM
See Also:
Constant Field Values

PCI_TYPE_MEMORY_FLASH

public static final java.lang.String PCI_TYPE_MEMORY_FLASH
See Also:
Constant Field Values

PCI_TYPE_MEMORY_OTHER

public static final java.lang.String PCI_TYPE_MEMORY_OTHER
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_HOST_PCI

public static final java.lang.String PCI_TYPE_BRIDGE_HOST_PCI
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_ISA

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_ISA
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_EISA

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_EISA
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_MCA

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_MCA
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_PCI

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_PCI
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_PCMCIA

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_PCMCIA
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_NUBUS

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_NUBUS
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_PCI_CARDBUS

public static final java.lang.String PCI_TYPE_BRIDGE_PCI_CARDBUS
See Also:
Constant Field Values

PCI_TYPE_BRIDGE_OTHER

public static final java.lang.String PCI_TYPE_BRIDGE_OTHER
See Also:
Constant Field Values

PCI_TYPE_SERIAL_FIREWIRE

public static final java.lang.String PCI_TYPE_SERIAL_FIREWIRE
See Also:
Constant Field Values

PCI_TYPE_SERIAL_ACCESS

public static final java.lang.String PCI_TYPE_SERIAL_ACCESS
See Also:
Constant Field Values

PCI_TYPE_SERIAL_SSA

public static final java.lang.String PCI_TYPE_SERIAL_SSA
See Also:
Constant Field Values

PCI_TYPE_SERIAL_USB

public static final java.lang.String PCI_TYPE_SERIAL_USB
See Also:
Constant Field Values

PCI_TYPE_SERIAL_FIBER

public static final java.lang.String PCI_TYPE_SERIAL_FIBER
See Also:
Constant Field Values

PCI_TYPE_SERIAL_OTHER

public static final java.lang.String PCI_TYPE_SERIAL_OTHER
See Also:
Constant Field Values

PCI_TYPE_COMM_SERIAL

public static final java.lang.String PCI_TYPE_COMM_SERIAL
See Also:
Constant Field Values

PCI_TYPE_COMM_PARALLEL

public static final java.lang.String PCI_TYPE_COMM_PARALLEL
See Also:
Constant Field Values

PCI_TYPE_COMM_OTHER

public static final java.lang.String PCI_TYPE_COMM_OTHER
See Also:
Constant Field Values

PCI_TYPE_SYSTEM_PIC

public static final java.lang.String PCI_TYPE_SYSTEM_PIC
See Also:
Constant Field Values

PCI_TYPE_SYSTEM_DMA

public static final java.lang.String PCI_TYPE_SYSTEM_DMA
See Also:
Constant Field Values

PCI_TYPE_SYSTEM_TIMER

public static final java.lang.String PCI_TYPE_SYSTEM_TIMER
See Also:
Constant Field Values

PCI_TYPE_SYSTEM_RTC

public static final java.lang.String PCI_TYPE_SYSTEM_RTC
See Also:
Constant Field Values

PCI_TYPE_SYSTEM_OTHER

public static final java.lang.String PCI_TYPE_SYSTEM_OTHER
See Also:
Constant Field Values

PCI_TYPE_INPUT_KEYBOARD

public static final java.lang.String PCI_TYPE_INPUT_KEYBOARD
See Also:
Constant Field Values

PCI_TYPE_INPUT_PEN

public static final java.lang.String PCI_TYPE_INPUT_PEN
See Also:
Constant Field Values

PCI_TYPE_INPUT_MOUSE

public static final java.lang.String PCI_TYPE_INPUT_MOUSE
See Also:
Constant Field Values

PCI_TYPE_INPUT_OTHER

public static final java.lang.String PCI_TYPE_INPUT_OTHER
See Also:
Constant Field Values

PCI_TYPE_DOCKING_GENERIC

public static final java.lang.String PCI_TYPE_DOCKING_GENERIC
See Also:
Constant Field Values

PCI_TYPE_DOCKING_OTHER

public static final java.lang.String PCI_TYPE_DOCKING_OTHER
See Also:
Constant Field Values

TABLE_VERSION

public static final java.lang.String TABLE_VERSION
See Also:
Constant Field Values
Constructor Detail

TWGPciDeviceTable

public TWGPciDeviceTable()
Method Detail

create

public void create()
            throws TWGDbException
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to define the table.

Specified by:
create in class TWGDatabaseTable
Throws:
TWGDbException

getTableVersion

public java.lang.String getTableVersion()
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to get the version for table

Specified by:
getTableVersion in class TWGDatabaseTable
Returns:
the version id for this table