PI Data Archive

1
PI Data Archive

• Ray Verhoeff Roger Humphrey

2
PI Data Archive

• PI 3.2 Service Release 1
• New Features
• Enhancements
• Plans for Service Release 2
• Summer, 1999

3
Current Release

• PI 3.2 Build 357.8
• available for download
• submitted to manufacturing
• documentation complete
• also available from OSI Support website

4
PI 3.2 SR1 New Features

• Alarm Subsystem
• Backup Script

5
Supported Operating Systems

• Windows NT SP3 and SP4
• Intel and Alpha
• HP-UX 10.10 and 10.20
• Solaris 2.5 and 2.6
• DEC UNIX 3.2 and 4.0
• IBM AIX 4.2

6
Operating Systems Discontinued

• HP-UX 9.x
• Sun Solaris and IBM AIX
• removed from price list
• existing sites supported indefinitely
• DEC UNIX 3.2 at next release?

7
Enhancements

• PI-Batch
• Merge Consecutive option
• More detail in PI-Batch presentation

8
Enhancements

• Snapshot Subsystem
• pibasess -snapfix for complete rebuild

9
Enhancements

• Archive Subsystem
• Problem time specs unclear
• start and end time of archive
• start and end time of data
• Reworked Off-Line Archive
• start and end time specs
• fixed, or timestamp from data
• time filters

10
Enhancements

• Archive Subsystem
• disable shift
• read-only archives
• CD-based archives mountable
• bug on HP-UX Error 30 Read-only file system

11
Enhancements

• Archive Shift Problem
• Archive subsystem stopped archiving data in order
  to initialize archive
• Disconnection from PINetMgr sometimes occurred

12
Archive Shift Improvement

• Archive Initialization Optimized
• done in advance by PI Base Subsystem
• actual switch of archive file roles is lt 1 second

13
Enhancements

• pigetmsg utility
• -mc maximum message count
• -dc display count
• -f continuous mode
• new command-line arguments
• original 5 command-line arguments still supported

14
Enhancements

• Database-level security
• Provides standard access string for database
  itself
• Allows other users to add and delete entries
• Implemented for
• pipoint, piuser, pids

15
Enhancements

• Duplicate subsystem startup detection
• Better staggering of subsystem startups
• Microsoft Version 6 Run-Time Library

16
Enhancements

• Windows NT WaitToKillService
• NT Service Manager will wait this long for
  service to shut down
• PI install increases this from the 20 second
  default to 5 minutes
• objective is to protect PI data
• increases system shutdown time when PI is running

17
Time

• A Brief History of Time at OSI
• No discussion about time is ever short
• Concepts such as now and 1 hour difference
  become complex
• Every discussion about time decays into this

18
Windows NT Time Issues

• Time bug in Microsoft Run-Time Library for
  non-DST zones
• 01-Apr-2001 bug
• U.S. rules
• The last hour of DST before ST

19
Time Enhancements
Daylight Savings Time
0000 DST
100 DST
200 DST
300 DST


100 ST
200 ST
0000 ST
2300 ST
Standard Time
Standard Time starts here
130 ?
20
Timezone Information Table

• Windows NT
• constructed from NTs rules
• all years have the same rule
• override by setting TZ variable
• UNIX
• constructed from run-time library
• pidiag -tz
• view time zone information

21
Time Enhancements
Translating 130...
0000 DST
100 DST
200 DST
300 DST


100 ST
200 ST
0000 ST
2300 ST
Current time in daylight...
Current time in standard...
130 DST
130 ST
22
Time Enhancements

• Specify ST/DST in time string
• 31-Oct-99 0130 PDT
• 31-Oct-99 0130 D
• 31-Oct-99 0130 Pacific Daylight Time
• Windows NT only

23
PIdiag -tz
D\PI\admgtpidiag -tz TZ environment variable
ltnot setgt Standard Time Name Pacific
Standard Time (PST) starts 1 second after
31-Oct-99 015959 PDT (Last Sun in Oct)
Daylight Time Name Pacific Daylight Time (PDT)
starts 1 second after 4-Apr-99 015959 PST (1st
Sun in April)
24
Alarm Subsystem

• Alarm points are digital points
• Points are organized into groups arranged in a
  single hierarchy
• One Alarm point monitors one source tag
• Support for Alarm Client

25
Alarm Subsystem

• If Testx condition is true, then state is set
  to Actionx
• Up to 4 Test/Action pairs supported

26
Alarm Digital States

• Encode three parameters
• Condition (Hihi, Low, Moving )
• Priority (a reasonable number of levels)
• Acknowledge Status
• Sites can define new sets

27
Configuring Alarm Tests

• Numeric source tags
• Value comparison GT, LT, EQ, NE
• Single move up/down StepGT, StepLT
• Rate of change up/down RateGT, RateLT

28
Configuring Alarm Tests

• Digital and string source tags
• Substring or state list Is_in, Includes
• String match EQ, NE

29
Example Alarm Test Configurations

• Typical DCS style four level alarm

Test1 GT( 95 ) -gt Action1 Hihi 3 Test2
GT( 85 ) -gt Action2 Hi 2 Test3 LT( 30 )
-gt Action3 Low 2 Test4 LT( 20 ) -gt
Action4 Lolo 3
30
Example Alarm Test Configurations

• Dynamic alarm Limits

Test1 GT( 23F-101.Hilim ) -gt Action1 Hi
2 Test2 LT( 23F-101.Lolim ) -gt Action2
Low 2
31
Example Alarm Test Configurations

• Overtemp with time qualifiers

Test1 GT( metal_limit ) 2m -gt Action1
Hihi 3 Test2 GT( metal_run ) 20m -gt
Action2 Hi 2 Test3 GT( metal_run ) 30s
-gt Action3 Hi 0
32
Alarm Groups

• Each point assigned to a group
• Each groups may be arranged in a single hierarchy
• Points may be configured to display the number of
  alarms in each group by priority and acknowledge
  status

33
Alarms Future Developments

• Alarm Cutout
• Alarm notification and filtering by group
• Alarm notification via E-mail

34
Alarms Future Developments

• PI-PE functions to encode/decode alarm states
• User-defined groups for individualized alarm
  signup

35
Great Bug Fixes

• PINetMgr on Multiprocessor NT
• PIMsgss debottlenecking
• Windows NT file cache optimization
• Corrected sub-second timestamp resolution

36
Great Gotchas

• Build 354 Internal protocol change
• avoids RPC table mismatch error
• Build 332 cannot remotely access SR1
• affects PI-SMT configured for remote access

37
Great Gotchas

• Sense of Totalizer FilterEqn
• if expression is FALSE, reject data value
• this is a return to PI 3.2 Build 332
• manual has been corrected
• consistent with PI-API and PI-Datalink

38
Great Gotchas

• Alarm Subsystem needs Point Source G
• needed for Alarm Groups
• Cant use multiple-letter source
• PI-API
• addition of new points by interface

39
Hardware Considerations

• Intel vs. Alpha NT
• recommend SP4 for Alpha NT
• Multiple Processors
• UNIX
• Windows NT

40
New Development

• Performance Equations
• Multi-threaded subsystem shell
• overall schedule less sensitive to time-consuming
  calculations
• Natural Scheduling
• based on some or all input tags

41
Performance Equations

• Add Visual Basic modules
• VB Script or Visual Basic for Applications (VBA)
• Implements Formula Library and User-written
  Functions

42
PI-PE with Visual Basic

• Built-in interface to COM objects
• Expanded access to PI data using PI-SDK
• includes the Equipment database
• Preserve existing PI-PE language

43
New Development

• Performance Equations
• Recalculation Engine
• Handle edits and insertion of old data
• Handle reconnection of PInet nodes
• Manually initiate recalculation

44
Non-Resident PI points

• Developers can implement COM object to exchange
  data
• methods exchange data with non-PI data source
• get snapshot
• put snapshot
• get archive values

45
Non-Resident PI points

• Developers COM object will provide access to
  external data sources
• Relational databases
• Simulation systems
• Calculation only
• Third-party historians

46
Non-Resident PI points

• Gives PI clients transparent access to
  non-resident data
• provides migration path from legacy systems

47
New Development

• SQL Processing
• Sub-second times and string tags
• demonstration Tuesday p.m.
• Insert, Update keywords

48
New Development

• Real-Time SQC
• no PI-SQC Server as such
• Functions will be added to Totalizer, Alarm
  Subsystem and PI-PE

49
New Development

• Edit point type, point class
• Windows NT clustering
• cold switchover initially

50
Windows NT Performance Monitor

• Standard tool for short-time system monitoring
• Support for vendor-specific counters

51
NT Performance Monitor
52
PI Interface to Performance Monitor

• collect data from any counter and store in PI
• enhances Performance Monitor to provide long term
  trending
• expose PI System counters
• Makes an ideal tool for system tuning and
  capacity planning

53
PI Performance Monitor Data
54
PI-SDK

• Full access to internals of PI
• PI System Management Tools
• Will become primary management interface

55
Some Web Addresses

• OSI Tech Support
• http//support.osisoft.com
• PI-SMT Upgrade
• http//www.osisoft.com/products/pismt_public/pi3re
  mins.htm
• Microsoft 01-Apr-2001 article
• http//msdn.microsoft.com/visualc/headlines/2001.a
  sp

56
Questions?