System
1032
Questions and Answers
by Tym Stegner
Question: Can
I use the new OpenVMS Alpha feature HYPERSORT with System 1032?
Answer: OpenVMS
V7 on Alpha has a new high- performance sorter available, called HYPERSORT,
which sorts immensely faster than the default sorter, albeit using greatly
increased disk and memory quotas. At this time, however, System 1032
does not support HYPERSORT.
Question: Since
upgrading to OpenVMS Alpha V7.1, why is the data in System 1032 not being
sorted correctly?
Answer: HYPERSORT
might be spoiling your results. To determine if HYPERSORT is enabled on
your system, translate the logical name SORTSHR. If defined, and if it points
to the HYPERSORT.EXE image, deassign this logical for System 1032 processing.
See HELP SORT on OpenVMS
for more information on HYPERSORT.
Responding to sorting
errors
Question:
I'm sure I have enough disk space, but when I try to do a sort operation
using System 1032, I get one or more of the error messages in Figure 1.
Figure 1. Sort error
messages.
%S1032-F-INSMEM, *
* INTERN * * insufficient memory to allocate dynamic area
A call to allocate dynamic memory, from %Xhhhhhhhh, for ? bytes, failed.
%S1032-E-SRTFAIL, sort
operation didn't complete
-SORT-E-OPENOUT, error opening <disk:[dir]file.TMP> as output
-RMS-E-PRV, insufficient privilege or file protection violation
%S1032-F-ERRMAPSEC,
error mapping section file <disk:[dir]file.DMT>
-SYSTEM-F-VASFULL, virtual address space is full
%DEBUGBOOT-W-VASFULL, virtual address space is full
%S1032-E-EXHERR, * * INTERN * * error in exit handler at PC %Xhhhhhhhh
-SYSTEM-F-IVCHNLSEC, invalid channel for create and map section
%S1032-F-ERRUPDSEC,
error updating section file <disk:[dir]file.DMT>
-SYSTEM-F-EXQUOTA, exceeded quota
%S1032-E-EXHERR, * * INTERN * * error in exit handler at PC %Xhhhhhhhh
-SYSTEM-F-IVCHNLSEC, invalid channel for create and map section
%S1032-E-SRTFAIL, sort
operation didn't complete
-SORT-W-SYSERROR, system service error
-LIB-F-INSVIRMEM, insufficient virtual memory
%S1032-F-INSMEM, insufficient
memory to allocate cluster area
-S1032-I-RELOC, dynamic core undergoing relocation
Answer: Check
the disk quota and/or write privileges you have against the DEFAULT directory
you are in during the sort operation.
While System 1032 uses
the SORTWORKn logicals to acquire temporary sort space, the result
file from the sort is always written to your current default directory.
If you have no disk quota on that default directory's drive, or do not have
write access to the directory, the sort operation fails.
In most every other
case, the problem is one of insufficient process pagefile quota, working
set, pagefile space, or VIRTUALPAGECNT. See the June, 1997 CCAprint
article, "Maximizing Sort Space for System 1032," for the steps
necessary to properly adjust these process and system quotas.
In upgrading to both
OpenVMS V6 and V7, System 1032 users have reported the need to upgrade process
quotas to sorts that had worked before the upgrade. This is due to resource
requirements of the OpenVMS sorter, not to any change in System 1032.
Running VAX or Alpha
Question: How
can I determine if I'm running on VAX or Alpha from within System 1032?
Answer: There
are several methods to accomplish this, but the easiest is to use the ARCH*
qualities of LIB$GETSYI:
Open library S1032_UTL
in s1032_tools read
Procedure WHICHVMS(WVMS: Output Text) -
Comment "Determine if running on Vax or
Alpha"
@s1032_tools:getsyi.dmc !GETSYI item codes
Variable R_TXT Text Varying init missing
Variable R_INT, R_CID Integer init 0
Variable R_DAT Date_Time init missing
Let WVMS = Missing
!initialize output
Call GETSYI(R_TXT,
R_INT, R_DAT,
SYI_ARCH_TYPE, R_CID)
if r_int eq 1 then
let WVMS="VAX"
else_if r_int eq 2
then
let WVMS="ALPHA"
end_if
End_Procedure
To execute the procedure:
1032> USE <filespec>
1032> Variable
HW Text Varying
1032> Call WHICHVMS(
HW )
1032> WRITE HW
(returns VAX or ALPHA)
DCL form of the
procedure:
$ vms_arch=""
$ if F$GETSYI("ARCH_TYPE").eq.1
then -
_$ vms_arch = "VAX"
$ if F$GETSYI("ARCH_TYPE").eq.2
then -
_$ vms_arch = "ALPHA"
$ write sys$output
vms_arch
$ exit
$ @WHICHVMS
(returns VAX or ALPHA)
Note: If you
have OpenVMS V6.0 or greater, you can use the ARCH_NAME parameter, which
returns the architecture name directly.
ODBC Driver update
error message
Question: When
I try to create an update application in MS Access using the ODBC Driver,
I get an error from Access stating that another user has changed the record,
but I'm the only one with the datasets open. What does this mean?
Answer: The
"other user" accessing the record you are trying to update/add
is your own process.
The situation is caused
by the System 1032 primary key and how MS Access determines whether a record
has been updated. Once a user has updated a record and committed the change,
Access passes the data to ODBC, which updates the record and passes the
updated record back. Access then compares this updated record to what it
sent. If the records do not match exactly, Access thinks that someone else
has updated the record.
Now, the primary key
for any System 1032 record is the system attribute $ID, which is automatically
updated by the system. When Access sends a record to ODBC, the corresponding
Access field is blank, but comes back from ODBC filled in; therefore, the
record is always different when Access gets the record back. This
situation is aggravated when any of the System 1032 special datatypes are
present such as Integer of ID, Date, User of Entry, Change, or Update.
Our tests show that
the data is correctly updated to the System 1032 dataset, and that a subsequent
read of the record displays the proper data. Only the automatic posting
and retrieval by Access does not work correctly.
The situation comes
about due to a feature limitation of the ODBC engine that the System 1032
ODBC driver uses. Infrastructure exists in the ODBC interface specification
to allow this kind of datatype (known as an autoincrement), but the infrastructure
is not yet implemented by the ODBC engine. System 1032 development is working
to improve this situation in a later release.
Suggestions welcome
Question: How
can I submit my questions to be answered in this column, or suggest an article
topic of interest to me?
Answer: Questions
deemed of interest to the entire customer base are extracted from the support
system records and answered. If you have particular questions you would
like us to answer, or if you want to suggest a topic for a System 1032 CCAprint
article,
contact us via email.
Model
204
Documentation at your fingertips
by Ann Hulsing
The documentation set
for Model 204 V4R1.1 comprises 32 titles. You probably have dog-eared copies
of a few of these manuals that you consult routinely, but from time to time
you might need to refer to another manual, but you aren’t sure which
one—where do you begin?
The convenient solution
is to have the books online, with a sturdy search capability. In the customer
survey conducted at Regional Technical Meetings, CCA proposed several online
formats, which were favored as follows:
- AdobeÆ
AcrobatÆ won 57% of the votes.
- BookManagerÆ
came in with 14% of the tally.
- HTML was endorsed
by 13% of the votes.
So, as requested by
the majority of our users, we have created the Model 204 Documentation
Library CD-ROM using Adobe Acrobat software. Included on the CD are:
- PDF files of 32
Model 204 books
- CATALOG.PDF file
that identifies and is linked to open each book
- LIBRARY.PDX file,
the index to search all the books
- Adobe Acrobat Reader
with Search 3.01 for both 16- and 32-bit PCs
- Various folders
for the Acrobat Search facility
- Readme.txt file
Choosing a location
for the library
You can put the CD-ROM
library into the CD drive on your PC whenever you want to view the manuals,
or you can download all the documents to a network server.
Note: If you
download the manuals to a network server, you must copy all the files
and folders and retain the directory structure as shipped to you.
Installing Acrobat
Reader with Search
Insert the Model 204
Documentation CD-ROM into your CD drive.
Note: You must
install a copy of Acrobat Reader with Search, which is supplied on the CD,
on each PC from which you want to view the manuals. If you already have
a copy of the Reader installed, check that it is version 3.01. You must
delete older versions and reinstall version 3.01 of the Reader to take advantage
of the Search facility. If you already have version 3.01 installed, you
can skip to "Linking the index to the manuals."
To install the Acrobat
Reader, follow the directions for your Windows platform:
For Windows 3.1
and Windows NT 3.5x
From the Windows Program
Manager, choose Run from the File menu.
- For Windows 3.1,
type:
[drive]:\RDR_SRCH\16bit\Setup.exe
- For Windows NT 3.5x,
type:
[drive]:\RDR_SRCH\32bit\Setup.exe
For Windows 95
and Windows NT 4.x
- Select the Start
button, choose Run, and type:
[drive]:\RDR_SRCH\32bit\Setup.exe
Click OK, and then
follow the installation instructions as they appear on your screen.
Linking the index
to the manuals
Once you have successfully
installed the Reader, double-click on the CATALOG.PDF file to activate the
Reader and open the Model 204 Catalog. You can use the arrow keys on the
Acrobat Reader toolbar to advance through the Catalog, which lists and is
linked to all the books in the Model 204 Library.
To activate the Search
facility, you must make a one-time-only link between the LIBRARY.PDX file
and the manuals, as follows:
- On the Acrobat Reader
toolbar, select Tools > Search > Indexes.
- Click the Add button.
- Select LIBRARY.PDX
and click the Open button.
- Select the Model
204 Documentation Library. A check mark appears in the box next to the
library name.
- Click the OK button.
The search index is
now available.
Searching the documentation
library
To search the Model
204 Documentation Library:
- On the Acrobat Reader
toolbar, select Tools > Search > Query.
- In the Adobe Acrobat
Search dialog box, type a search string and click the Search button.
The Search Results
dialog box displays a list of the books that contain the search string you
requested. The list reflects the frequency of occurrence of the search
string. Double-click on a title; the manual opens to the page with
the first occurrence of the text string in that manual. The occurrence is
highlighted.
You can advance from
one occurrence to the next by clicking on the arrow-with-page icon on the
far- right side of the Acrobat toolbar. You can continue to view occurrences
throughout the library, or return to the Search dialog box and either type
in a new search string or refine your original search.
For more information
on the Search facility
On the Acrobat toolbar,
open the Adobe Acrobat Search Online Guide by selecting Help >
Search Online Guide. This guide acquaints you with the Acrobat toolbar icons
and assists you in refining your search with Boolean expressions and other
Acrobat techniques. We recommend it to you.
System
1032
Share the Excitement at US’99
by Nancy Diettrich
The response to the
System 1032 Users’ Symposium (US’99) scheduled for March 28-30,
1999 has been very enthusiastic. Indications are that we will have the biggest
turnout in years.
We are still looking
for presentations from the user community. Here’s your chance to dazzle
us with your applications and broaden the horizons of other System 1032
users. Don’t forget that CCA will pay for your hotel accommodation,
if you make a presentation at the Symposium.
Hope to see you here
in March!
Education
Course Schedule
Space is still
available for these upcoming CCA Education Services classes:
|
Model
204
|
|
|
System
Performance & Tuning
(Teacher: Jim Damon)
|
1/20-22
|
McLean
|
|
Programmer's
User Language
|
1/25-29
|
McLean
|
|
Intro.
to User Language
|
1/27-29
|
Framingham
|
|
Intro.
to System Management
|
2/9-11
|
McLean
|
|
Model 204
V4R1 Update Class
|
2/12
|
McLean
|
|
Programmer's
User Language
|
2/22-26
|
McLean
|
Year
2000 ... 387 days to go!
Are you on top of your
Year 2000 project?
By now you should have
Model 204 V4.1 or 4.1.1 installed and be most—if not all—the way
done with your application code changes.
Remember to leave plenty
of time for testing.
If you are concerned
about getting your Year 2000 work wrapped up in the next few months, please
call CCA now. We have a highly experienced Y2K Remediation Factory
with the ability to amend, test, and document your applications for Year
2000 compliance. We can also run time-warp testing for you.
For more details, call
your Account Representative or Bruce Needle at 508-270-6666 ext. 563.
