View - Setting database version

Products

• View
• Spool

Issue/Introduction

I am upgrading View and Deliver from v12.2 to v14.0. 

As per my knowledge, before submitting the job for setting database version from v12.2 to v14 or vice versa, the View SARSTC task should be down and users should not use SAR panels. In general terms no STC or TSO users should use/hold the View database while running SARDBASE VERSION on the database. 

As I noticed, I could see the Spool STC also using/holding View database extents.

1) May I know why the Spool STC is using/holding SAR database?

2) If I want to VERSION the SAR database, should the Spool STC be shut down?

Environment

Release : View 14.0

Resolution

There are 2 possible causes for Spool to be accessing a View database:

 . An automatic backup of the Spool files that can be set up 
 . Nodes defined with TCPDRIV=SAR

The things to look for in Spool, would be these in the ESFPARMs:

 . SAR NAME=SAR.SYSTEM1,START=YES,MAXFILES=10,ADD$WTR=NO
 . TCPDRIV=SAR

In both cases, as the View/Deliver databases are being "VERSIONed", it is suggested to shut down Spool, to avoid that it tries to create any files during the process. 

Here is Spool documentation on the matter:

 . Administrators can use the View interface to move files from Spool to View. 
 . You can transfer, back up, and archive files:

 . . Transfer processing means that the file is moved to View as soon as it is created in Spool. 
 . . The file is then purged from Spool.

 . . Backup processing means that the file is copied to View as soon as it has been created in Spool. 
 . . Normal print processing occurs in Spool.

 . . Archive processing means that the file is moved to View immediately before being purged from Spool. 
 . . Normal print processing occurs in Spool.

Here is the link in the Spool documentation: OM View Interface

This is a very old interface, though it is as recently as being in Spool 14.0, and not many Spool customers use it.