Transcript Got Mainframe? What’s new for the Mainframe?

Got Mainframe?
What’s New With iWay for the Mainframe?
Nick Cosenza
Information Builders
Copyright 2007, Information Builders. Slide 1
Presentation Information




Author: Nick Cosenza
Company: iWay Software
Presentation Title: Got Mainframe? What’s New for the Mainframe?
Presentation Abstract: Join us for this presentation and see what iWay Software
has been up to on the mainframe! Learn what’s new with iWay’s Data server and
CICS and IMS transaction system access and other important new capabilities.
iWay Software, in its endeavor to be the world's largest integration software
provider, has developed new and improved mainframe technologies. This session,
which will include a live demonstration, may prove to be the one-stop shop for
customers interested in unlocking information held within their mainframe
transactional-based systems. The discussion will delve into the adapter offerings
within the iWay Universal Adapter framework and the adapters offered within the
iWay Server 7.x product line.
Copyright 2007, Information Builders. Slide 2
Got Mainframe?
Agenda
 Mainframe Data Adapter Updates
(The iWay Data Server)
 Mainframe Java Adapter Updates
(The iWay Adapter Factory)
 iWay Service Manager (iSM)
 Demonstration
Copyright 2007, Information Builders. Slide 3
Mainframe Data Adapter Updates
Copyright 2007, Information Builders. Slide 4
Got Mainframe?
Adabas/DB
 Connection Pooling support
 Last opened databases will be closed when


agent is disconnected or closed
MU/PE derived sub/super descriptors
Support for field’s SQL options
Copyright 2007, Information Builders. Slide 5
Got Mainframe?
Adabas/DB
 Postponed Database closing
 Databases participating in the request remain
opened until it changes one of the following
 Database
 File
 Database open mode
 Access mode (read/write)
Copyright 2007, Information Builders. Slide 6
Got Mainframe?
Adabas/Natural
Two ways to access natural programs
 Invoke natural from CICS
 Uses CICS Adapter to call natural
 CICS configurations required
 Transactional in nature
 Natural batch adapter
 Runs natural batch programs
 No changes to the natural program
Copyright 2007, Information Builders. Slide 7
Got Mainframe?
DB2
DB2
 DB2 UNICODE Support
 Multiple Language Support
 BLOB data type for Update/Insert
 DB2 Nickname support
Copyright 2007, Information Builders. Slide 8
Got Mainframe?
IMS/DB
IMS/DB
 Automatic IMS region reconnect feature
 New parameter IMSRECOM in the IMS special
service definition block
 Time interval in min between attempts to reconnect to IMS region via DBCTL
 Inserting data into non-keyed segment
 Handle data insert into the non- keyed
segments
 Create synonym for logical DB
Copyright 2007, Information Builders. Slide 9
Got Mainframe?
IMS/TM Via the iWay Data Server
Usability
 Table file IMS
 Select from IMS transaction
 WebFOCUS
Copyright 2007, Information Builders. Slide 10
Got Mainframe?
CICS Via the iWay Data Server
Usability
 Table file CICS
 Select from CICS program
 WebFOCUS
 Compatibility with older CICS solutions
Copyright 2007, Information Builders. Slide 11
Got Mainframe?
VSAM
RRDS support in VSAM Adapter
 Stage 1: Supported
 Stage 2: Adapter can utilize user provided
hash routine to generate RRN value for
READ/WRITE operations
 VSAM files under CICS control
 Read/write support
 Dirty reads avoided
Copyright 2007, Information Builders. Slide 12
Got Mainframe?
Datacom/DB
Access File Attributes
 TRACE={ YES | NO | CBS } (file level) (YES is





obsolete, supported for compatibility)
SEQACCESS={ YES | NO } (file level)
FOUNDLIMIT=nnnnnn (segment and file level)
REJECTLIMIT=nnnnnn (segment and file level)
KEYNAME=eeeee (segment level)
FIELD=<fieldname>, SIGN=<sign>, TYPE=C
Copyright 2007, Information Builders. Slide 13
Got Mainframe?
Datacom/DB
New adapter enhancements
 Adapter is reentrant
 Only elements that contain active fields are
requested from Datacom
 Any field defined in the master file may be used for
joining
 Read in physical sequence by commands
GSETP/GETPS is used if parameter KEYNAME has
no value for the Root segment and sequential access
is chosen
 Connection or URT
 Create synonym from Web console
Copyright 2007, Information Builders. Slide 14
Got Mainframe?
IDMS/SQL
New adapter enhancements
 Foreign key support
 Multi-segment master files
 Create synonym from Web console
Copyright 2007, Information Builders. Slide 15
Got Mainframe?
LDAP Via the iWay Data Server
New Adapter for LDAP
 CR SYN and TABLE support for stored procedures
 Using DBMS temporary files as HOLD Samedb feature
Copyright 2007, Information Builders. Slide 16
Got Mainframe?
samedb
Example
TABLE FILE STXT31T
SUM F02CHAR10 BY F01INT
ON TABLE HOLD AS TEMP FORMAT SAMEDB PERSISTENCE
GLOBAL_TEMPORARY
IF READLIMIT EQ 10
END
SELECT T1."F01INT", MAX(T1."F02CHAR_10") FROM TTXT31T T1
WHERE ROWNUM <= 10 GROUP BY T1."F01INT";
CREATE GLOBAL TEMPORARY TABLE
TEMP ("F01INT" INTEGER NOT NULL ,
"F02CHAR10" CHAR(10) ,PRIMARY KEY("F01INT") ) ;
INSERT INTO TEMP SELECT T1."F01INT", MAX(T1."F02CHAR10")
FROM TTXT31T T1 WHERE ROWNUM <= 10 GROUP BY T1."F01INT";
Copyright 2007, Information Builders. Slide 17
Got Mainframe?
JDBC Via the iWay Data Server
 JDBC – Certified list on adapter tree
Copyright 2007, Information Builders. Slide 18
Got Mainframe?
iWay Data Server Update and More Info
Unified server

Clear diagnostics for ALL Adapters
 Migration path for all SSCTL server customers

Tony Hurrell Presentation:
Copyright 2007, Information Builders. Slide 19
Mainframe Java Adapter Updates
Copyright 2007, Information Builders. Slide 20
Got Mainframe?
Mainframe Java Adapter Updates
Current IMS and CICS Java Adapters:
Local Transaction Support
 CICS via extended call
 IMS/TM via IMS Connect
 LUW extended
 Application control via process flow
Copyright 2007, Information Builders. Slide 21
Got Mainframe?
Mainframe Java Adapter Updates
Future IMS and CICS Java Adapters:
Global transaction support
 Coordinator is J2ee application server
 Adapter is resource manager
 iWay “remote APPC” on mainframe
 Two phase commit
 Recovery
 Migration path for BEA/JAM customers
Copyright 2007, Information Builders. Slide 22
Got Mainframe?
Mainframe Java Adapter Updates
Mainframe Events for CICS
Current
 TCPIP sockets
 Byte string to XML using Cobol
Future
 EXEC CICS LINK program name
 CICS program name is remote system
 Program name could be iSM!
Copyright 2007, Information Builders. Slide 23
Mainframe Java Adapter Updates
iWay Service Manager (iSM)
Copyright 2007, Information Builders. Slide 24
Got Mainframe?
iWay Service Manager (iSM)
 New iWay tooling
 iWay Service Designer Workbench
 iWay process flow
 Application explorer
 Mainframe connections
 Web Services
 Demo: Integration example for
 CICS
 IMS/TM
 RDBMS: iWay adapter that accesses all your
database adapters
Copyright 2007, Information Builders. Slide 25