com.tivoli.twg.inventory
Class TWGScsiAdapterTable

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.TWGScsiAdapterTable

public class TWGScsiAdapterTable
extends TWGDatabaseTable

SQL database table for SCSI Adapter information

Primary key - MANAGED_OBJ_ID, SCSI_ADAPTER_INDEX

TWG_SCSI_ADAPTER
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
SCSI_ADAPTER_INDEX INT Adapter index X X
ADAPTER_TYPE CHAR(40) Adapter type X X
LOCATION CHAR(40) Location - ENUM1 X X
PUN INT Physical Unit Number X X
LUN INT Logical Unit Number X X
BUS_TYPE CHAR(40) Bus type ENUM1 X X
BUS_WIDTH INT Bus width (in bits) X X
IO_ACCESS CHAR(40) IO access ENUM1 X X
HOST_BUS CHAR(40) Host bus ENUM1 X X
HOST_BUS_WIDTH INT Host bus width (in bits) X X
ADDRESS_OVER_16 CHAR(40) Address addresses greater than 16 Mb - ENUM1 X X
SCB_COMMANDS CHAR(40) Supports SCB - ENUM1 X X
SCATTER_GATHER CHAR(40) Scatter/Gather ENUM1 X X
CHS CHAR(40) Cylinder/Head/Sector Addressing - ENUM1 X X
MAX_SCATTER_GATHER_LIST INT Maximum scatter/gather list X X
MAX_CDB_LENGTH INT Maximum Control Data Block transfer length(bytes) X X
ADD_MAJOR_LEVEL INT ADD major level X X
ADD_MINOR_LEVEL INT ADD minor level X X
DEVICES_CONNECTED INT Devices connected X X

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


Field Summary
static java.lang.String ADAPTER_TYPE
           
static java.lang.String ADD_MAJOR_LEVEL
           
static java.lang.String ADD_MINOR_LEVEL
           
static java.lang.String ADDRESS_OVER_16
           
static java.lang.String ADDRESS_OVER_16_OTHER
           
static java.lang.String ADDRESS_OVER_16_SUPPORTED
           
static java.lang.String ADDRESS_OVER_16_UNKNOWN
           
static java.lang.String ADDRESS_OVER_16_UNSUPPORTED
           
static java.lang.String BUS_TYPE
           
static java.lang.String BUS_TYPE_ESDI
           
static java.lang.String BUS_TYPE_FLOPPY
           
static java.lang.String BUS_TYPE_OTHER
           
static java.lang.String BUS_TYPE_SCSI_I
           
static java.lang.String BUS_TYPE_SCSI_II
           
static java.lang.String BUS_TYPE_SCSI_III
           
static java.lang.String BUS_TYPE_ST506CAM_I
           
static java.lang.String BUS_TYPE_ST506CAM_II
           
static java.lang.String BUS_TYPE_UNKNOWN
           
static java.lang.String BUS_WIDTH
           
static java.lang.String CHS
           
static java.lang.String CHS_IN_HARDWARE
           
static java.lang.String CHS_IN_SOFTWARE
           
static java.lang.String CHS_OTHER
           
static java.lang.String CHS_UNKNOWN
           
static java.lang.String DEVICES_CONNECTED
           
static java.lang.String HOST_BUS
           
static java.lang.String HOST_BUS_EISA
           
static java.lang.String HOST_BUS_ISA
           
static java.lang.String HOST_BUS_MICROCHANNEL
           
static java.lang.String HOST_BUS_OTHER
           
static java.lang.String HOST_BUS_PC98_C
           
static java.lang.String HOST_BUS_PC98_LOCAL
           
static java.lang.String HOST_BUS_UNKNOWN
           
static java.lang.String HOST_BUS_WIDTH
           
static java.lang.String IO_ACCESS
           
static java.lang.String IO_ACCESS_DMA_MASTER
           
static java.lang.String IO_ACCESS_DMA_SLAVE
           
static java.lang.String IO_ACCESS_MAPPED_IO
           
static java.lang.String IO_ACCESS_OTHER
           
static java.lang.String IO_ACCESS_PROGRAMMED_IO
           
static java.lang.String IO_ACCESS_UNKNOWN
           
static java.lang.String LOCATION
           
static java.lang.String LOCATION_OTHER
           
static java.lang.String LOCATION_PLANAR
           
static java.lang.String LOCATION_SLOT
           
static java.lang.String LOCATION_UNKNOWN
           
static java.lang.String LUN
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String MAX_CDB_LENGTH
           
static java.lang.String MAX_SCATTER_GATHER_LIST
           
static java.lang.String PUN
           
static java.lang.String SCATTER_GATHER
           
static java.lang.String SCATTER_GATHER_IN_HARDWARE
           
static java.lang.String SCATTER_GATHER_IN_SOFTWARE
           
static java.lang.String SCATTER_GATHER_OTHER
           
static java.lang.String SCATTER_GATHER_UNKNOWN
           
static java.lang.String SCB_COMMANDS
           
static java.lang.String SCB_COMMANDS_OTHER
           
static java.lang.String SCB_COMMANDS_SUPPORTED
           
static java.lang.String SCB_COMMANDS_UNKNOWN
           
static java.lang.String SCB_COMMANDS_UNSUPPORTED
           
static java.lang.String SCSI_ADAPTER_INDEX
           
static java.lang.String SHORT_MAX_SCATTER_GATHER_LIST
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
 
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
TWGScsiAdapterTable()
           
 
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

SCSI_ADAPTER_INDEX

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

ADAPTER_TYPE

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

LOCATION

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

PUN

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

LUN

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

BUS_TYPE

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

BUS_WIDTH

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

IO_ACCESS

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

HOST_BUS

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

HOST_BUS_WIDTH

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

ADDRESS_OVER_16

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

SCB_COMMANDS

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

SCATTER_GATHER

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

CHS

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

MAX_SCATTER_GATHER_LIST

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

SHORT_MAX_SCATTER_GATHER_LIST

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

MAX_CDB_LENGTH

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

ADD_MAJOR_LEVEL

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

ADD_MINOR_LEVEL

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

DEVICES_CONNECTED

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

LOCATION_UNKNOWN

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

LOCATION_OTHER

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

LOCATION_PLANAR

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

LOCATION_SLOT

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

BUS_TYPE_OTHER

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

BUS_TYPE_UNKNOWN

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

BUS_TYPE_ST506CAM_I

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

BUS_TYPE_ST506CAM_II

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

BUS_TYPE_ESDI

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

BUS_TYPE_FLOPPY

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

BUS_TYPE_SCSI_I

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

BUS_TYPE_SCSI_II

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

BUS_TYPE_SCSI_III

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

IO_ACCESS_OTHER

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

IO_ACCESS_UNKNOWN

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

IO_ACCESS_DMA_MASTER

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

IO_ACCESS_DMA_SLAVE

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

IO_ACCESS_PROGRAMMED_IO

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

IO_ACCESS_MAPPED_IO

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

HOST_BUS_OTHER

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

HOST_BUS_UNKNOWN

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

HOST_BUS_ISA

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

HOST_BUS_EISA

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

HOST_BUS_MICROCHANNEL

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

HOST_BUS_PC98_LOCAL

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

HOST_BUS_PC98_C

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

ADDRESS_OVER_16_OTHER

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

ADDRESS_OVER_16_UNKNOWN

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

ADDRESS_OVER_16_SUPPORTED

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

ADDRESS_OVER_16_UNSUPPORTED

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

SCB_COMMANDS_OTHER

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

SCB_COMMANDS_UNKNOWN

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

SCB_COMMANDS_SUPPORTED

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

SCB_COMMANDS_UNSUPPORTED

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

SCATTER_GATHER_OTHER

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

SCATTER_GATHER_UNKNOWN

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

SCATTER_GATHER_IN_HARDWARE

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

SCATTER_GATHER_IN_SOFTWARE

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

CHS_OTHER

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

CHS_UNKNOWN

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

CHS_IN_HARDWARE

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

CHS_IN_SOFTWARE

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

TABLE_VERSION

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

TWGScsiAdapterTable

public TWGScsiAdapterTable()
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