| CLOBs
and BLOBs by Laub |
Bill
Laub, Product Architect
Computer Corporation of America |
|
Introducing
Table E and the Large Object field type! The Large
Object attribute implemented in Model 204 V6R1 will
include support for Character Large Objects (CLOBs)
and Binary Large Objects (BLOBs). This presentation
will discuss the implementation, sizing and usage
of the Large Object attribute in a Model 204 file.
|
| |
|
Enhanced
CCASTAT Security using Password Expiration
|
Gina
Scinta, Senior Technical Consultant
Computer Corporation of America |
|
The
Password Expiration feature enhances the Model 204
CCASTAT security feature to manage password expiration
automatically based on set parameters. This presentation
will discuss the implementation of password expiration,
how to set the parameters for: password expiration,
purging expired user ids and password expiration warning
message. Converting your existing CCASTAT file to
run with the new password expiration features will
also be discussed.
|
| |
|
Dynamic
APSY Support for Extended Application Availability
|
Donna
Goodwin, Senior Systems Engineer
Computer Corporation of America |
|
Model
204 V6R1 provides uninterrupted service for subsystem
users while providing in-flight modification to a
User Language application. You can modify and refresh
precompiled and non-precompiled procedures in files
that participate in procedure locking while the subsystem
is active. This presentation will discuss the implementation
of dynamic APSY support, use of the REFRESH SUBSYSPROC
command, SUSPEND SUBSYSTEM command and the RESUME
SUBSYSTEM command. APSY subsystem, SUBSYSMGMT, will
be used to demonstrate dynamic APSY subsystem attribute
changes.
|
| |
| Perpetual/204:
Automated File Maintenance |
Leonard
Gradus, Product Architect
Computer Corporation of America |
|
Prior
to V6R1, to eliminate or shorten chains of extension
records, you took the file off line and reorganized
the file. Model 204 V6R1 provides a new facility to
delay file reorganization and automatically increase
files when they become full. This presentation will
demonstrate how to run the new Table B dynamic data
compactor, using the COMPACTB command on unordered
files and will show the dynamic reduction in the chain
of extension records, discuss using the new BLDREUSE
command to rebuild a reuse queue, making more pages
in Table B eligible for reuse and how automatic increase
of Tables B and D let you increase files on the fly.
|
| |
|
Journal,
Checkpoint & Recovery Improvements Rock On!
|
Rick
Puszewski, Principle Software Engineer
Computer Corporation of America |
|
With
database sizes increasing dramatically, fast, reliable
journaling and recovery procedures are more vital
than ever before. This presentation will discuss the
following enhancements to Model 204 in this area:
v
Reduced
journal size for faster recovery and easier database
maintenance
v
MERGEJ functional enhancements
and performance improvements
v
Perpetual
journaling to eliminate the need for tape datasets
v
CHKPNTD
dataset under VSE
v
New
CHECKPOINT algorithm to provide more consistent service
|
| |
|
TCP/IP Sockets Interface for Model
204 |
Simon
Rayner, Connectivity Software Engineer
Computer Corporation of America |
|
V6R1
propels Model 204 into the exciting world of new network
technologies by providing native TCP/IP sockets support
in the nucleus. This new feature, available to all
active Model 204 customers, provides the ease and
flexibility of making Model 204 a Web server or a
client simply by writing User Language applications
using TCP/IP socket calls. Sample applications will
be demonstrated during this presentation.
|
| |
|
Model
204, Java and Web Application Servers: Right Now!
|
Steve
Nelson, Director, Connectivity Development
Computer Corporation of America |
|
Because
of its ability to provide instantaneous access to
even the largest databases, Model 204 is an ideal
database server for Web-based applications. JDBC for
Model 204 makes it easy for programmers to take full
advantage of the natural fit between Model 204 and
the Web. This presentation will show how to integrate
Model 204 with product Web services and other Web-based
applications using Java and a variety of Web Applications
Servers. Demonstrations will show the use of different
Web Application Servers such as WebSphere and Tomcat.
|
| |
| CCA
Analytics V3.0: Enhanced Business Intelligence for Model
204 |
|
Kim
Collins, Senior Technical Consultant
Donna Goodwin, Senior Systems Engineer
Computer Corporation of America
|
| Every
year, more and more data is stored in Model 204 databases,
making the need to access, summarize and analyze it
also greater. CCA Analytics is a business intelligence
solution that does just that. It helps users query,
segment, summarize, and analyze their data resources
so that ultimately, they can make better business decisions.
This presentation will review the primary features and
concepts of CCA Analytics, including the role of the
Administrator and each of the key functions available
to the end-user. A demonstration will also be provided.
|
| |
| CCA
Analytics: A Data Warehouse Case Study |
|
Kim
Collins, Senior Technical Consultant
Computer Corporation of America
Sue
Friedman, Memorial Healthcare Systems
|
|
This
presentation will provide an overview of the implementation
of CCA Analytics at Memorial Hospital, a Model 204
customer site. The discussion will include why Memorial
chose to use CCA Analytics as part of their data warehouse
solution, as well as the process they followed in
designing the data models and synchronizing the data
warehouse with their production environment. The implementation
process and user training will also be discussed.
|
| |
| Model
204 V6R1: Best of the Rest |
Don
Cameron, Support Manager,
CCA UK |
|
In
addition to those covered in detail in other Insight
204 sessions, Model 204 V6R1 is packed with many other
new features that will be discussed in this session.
These include:
v
Model 204 nucleus above the 31-bit storage line
v
User Language enhancements
v
Parameters introduced
or revised in V6R1
v
CRAM XDM subsystem name passed via a parameter
v
Commands enhanced in V6R1
v
New and revised messages
|
| |
| Model
204 and JAVA at Harris County |
Jason
Miley
Harris County (J.I.M.S.)
Houston, Texas |
| Harris
County J.I.M.S. (Justice Information Management Systems)
is re-designing and re-writing its entire Justice application
system into a browser-based JAVA/WAS environment using
the Model 204 JDBC interface to access 820+ million
records. This presentation will show how we're approaching
this rather large task and the advantages of using Model
204 as a backend data server while simultaneously maintaining
User Language applications for legacy systems. |
| |
| Faster
File Reorgs! |
Suzanne
Burke
Centura Health
Englewood, CO |
| Are
you often frustrated with long runtimes for M204 file
reorganizations? If you don’t have the luxury of
Sirius® products nor the budget to change that,
there are things you can do to make the jobs finish
faster – by 50-70%! This presentation will share
tips and examples -- strictly using regular JCL and
CCAIN parms – to cut your runtimes and improve
the design and maintenance of your utility JCL. Examples
and explanations will be covered for the relationship
between region size and MAXBUF, LIBUFF and CCAIN parms,
SORTWK files and the file being reorg’ed. This
discussion (for MVS) will include basic and special
JCL design and development practices as well as recommended
and optional CCAIN parms to produce improvements and
allow you to achieve more work in today’s shrinking
windows for DBA work. |
| |
|
Sirius
News
|
Gary
Gregory
Sirius Software |
A
major new release of Sirius products leverages the
exciting features of Model 204 Version 6.1. This
presentation will review what Sirius has accomplished
since the last Insight meeting as well as preview our
plans for the future. Technical issues are treated at
a high level and the presentation will be of interest
to all Model 204 users. |
| |
| XML
Applications using LOBs with Janus |
Alex
Kodat
Sirius Software |
Learn
how the binary and string Large OBjects introduced
by version 6.1 of Model 204 enable exciting new applications
using various Janus components to process XML documents.
This presentation will include a high-level demonstration
of
an application as well as some lower level technical
details
of its implementation. |
| |
| DSS
Interface to Model 204 |
Masao
Okada
Database Communications, Inc. (DCI)
JAPAN |
| DCI
is developing a Data Mining application utilizing its
proprietary DSS (Decision Support System) interface
for Model 204. This application has a powerful data
mining engine which can extract database rules from
large Model 204 files automatically. The DSS application
also has an inference engine which can make predictions
based on a combination of database rules and business
rules specified through human expertise. This presentation
will explain the basic concepts of the interface and
the application, and will provide a demonstration using
a Web browser and a meteorological database. |
| |
| Retiring
the KEY Attribute |
Robert
Waggoner
Nodus, Inc. |
| There
is much functionality to be gained by "modernizing"
indexed fields through conversion of KEY fields to Ordered.
This presentation serves as a workbook for converting
existing M204 file fields from the KEY attribute. The
advantages of the Ordered attribute over the KEY are
discussed, as well as any disadvantages. Considerations
for making decisions with regard to numeric fields,
date fields, invisible fields, and multiply occurring
fields will be discussed, as well as the impact on the
File Manager, and on file reorganizations. |
| |
| Version
6.1 at Centrelink: Early Results and Future Plans |
Rob
Schoenberg
Centrelink |
| Large
Object support in Version 6.1 is probably the most significant
change in Model 204 since the Ordered Index, and it
is one eagerly awaited at Centrelink. Already the Centrelink
M204 files contain a number of 'under the cover' large
objects, where data far more than 255 bytes in size
is passed into and out of standard routines which make
the data 'fit'. The use of C/BLOBs, where appropriate,
is expected to simplify application code and deliver
significant savings in CPU. This presentation will discuss
our work thus far in determining which data fields are
best represented as C/LOBS and what we expect to gain
from the conversion. We will also discuss Centrelink's
use, testing and plans for a number of other features
in 6.1; in particular, the performance enhancements
and our push for extended availability via the COMPACTB
and BLDREUSE commands. |
| |
| IBM
Java Overview and zSeries Update |
Theresa
Tai
IBM |
| This
session will provide an overview of IBM JVM and its
major components. Java is one of the strategic initiatives
of IBM, supporting standard-based J2EE technologies
for Enterprise application deployment on zSeries. IBM
is committed to delivering a market leading JVM as the
foundation of WebSphere Application Server platforms.
The discussion will highlight the Just In Time complier
(JIT), Garbage Collection (GC) and Java heap management,
as well as the new zSeries Application Assist Processor
(zAAP) using IBM JVM. There will also be an update on
what is new for JDK V5 GA in 10/05. |
| |
| What’s
New in z/OS? |
John
Eells
IBM |
| This
presentation provides an overview of the z/OS platform,
including zSeries strengths, key features and functions.
It highlights the new features in z/OS 1.6, including
those related to scalability, integrating new applications,
availability, security, self-maintenance and installation.
It also provides a preview of the new features planned
for 1.7. |
