00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE - 第13页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 13 4.5 Tables The layout of the ind ividual tables is illus trated below. The specified data t ypes correspond to th e naming schem e in the M…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
12
4.4.2 Automatic Reorganization of Indexes and Statistics
The removal of old data may lead to fragmented database indexes and distorted statistics. Thus,
indexes and statistics have to be reorganized regularly. The OIS service checks the database
fragmentation at regular intervals (configured: 40 days). If the database fragmentation exceeds the
configured limit, the reorganization is started. All OIS connections are disabled and the OIS service
starts rebuilding the database indexes and statistics. This will take about 5 minutes. Reading and
writing are not possible during the reorganization.
After reorganization, all OIS connections will be enabled again.
4.4.3 Periodic Manual Maintenance of the OIS Database in OIS V10.x / V11.x
In these versions, the OIS database should be manually maintained bimonthly. If the maintenance
is not performed, there will be performance losses in the database queries after some time.
Preparations
● Log in as a system administrator (sa) to have access to the database.
● Stop all OIS clients (such as SIPLACE Explorer).
● Stop the OIS Server by right-clicking the OIS Server Manager icon.
Execution
● Execute the MaintainOISDatabase.cmd script.
The database will be reorganized and locked during the maintenance. Therefore it is essential that
no other programs access the OIS or SIS databases during this time. The lines can continue
to produce because they buffer the incoming data.
However, the script should not run longer than 10 minutes. Otherwise, the database is probably in
use by other programs. In this case, the script has to be canceled and the OIS Server rebooted to
collect the incoming data at the stations. After the active program has been identified and the OIS
connection to the machines exists for about 10 minutes the process can be restarted.
Files
● <Monitoring Service InstallDir>\MaintainOISDatabase.cmd
● <Monitoring Service InstallDir>\DBSkripts\MaintainOISDatabase.sql
● <Monitoring Service InstallDir>\DBSkripts\OIS_RebuildIndexAndStatistics.sql
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
13
4.5 Tables
The layout of the individual tables is illustrated below. The specified data types correspond to the
naming scheme in the MS-SQL-Server.
NOTICE
The sole purpose of the following tables is to clarify the views. No write access is
permitted to these tables. Backward compatibility cannot be guaranteed if you access
the tables directly. Use the provided views instead.
Legend for the following tables
CI
=
Clustered index
I
=
Index
P
=
Primary key
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
14
4.5.1 OIS Tables
4.5.1.1 STATETEXT Table
STATETEXT
OIS name
Data type
Byte
CI
I
P
Identification number of the State
sState
smallint
2
Name of the State
strName
nvarchar(32)
64
4.5.1.2 FEEDERTYPE Table
FEEDERTYPE
OIS name
Data type
Byte
CI
I
P
SIPLACE Pro number for feeder type
(available with station software version 701
and higher)
lFeederType
int
4
SIPLACE Pro name for feeder type
strFeederTypeName
nvarchar(128)
256
SIPLACE Pro feeder code
IFeederCode
int
4
4.5.1.3 BOARD Table
BOARD
OIS name
Data type
Byte
CI
I
P
Identification number of the Station
(Reference to Table STATION)
lId
int
4
✓
Date/time at which this event occurred. Local
station time
dtTime
datetime
8
✓
Manufactured production lot
strRecipe
nvarchar(128)
256
Name of the setup
strSetup
nvarchar(128)
256
Name of the PCB
strBoard
nvarchar(128)
256
Station internal local number of manufactured
PCB
lBoardNumber
int
4
Conveyor belt 1 / 2
ucConveyor
tinyint
1
Cycle time of PCB
sDuration
smallint
2
Time when production of lot started
dtRecipeStart
datetime
8
Time when setup used for manufacture started
dtSetupStart
datetime
8
PCB barcode
strBarcode
nvarchar(256)
512
PCB status (see definition below)
ucStatus
tinyint
1
Time when the data is written. Local server
time
dtCreated
datetime
8
✓
Number of panels within the board
lPanel
int
4
Conveyor sub-lane
lSubConveyor
int
4
Board side
ucBoardSide
tinyint
1