“a mainframe evolution” - cbl · vsam catalog reports vsam dataset reports vsam tuning reports...

“A Mainframe Evolution”

David Austin Technical Liaison Manager Compute (Bridgend) Ltd

Compute (Bridgend) Ltd 8 Merthyr Mawr Road BRIDGEND, CF31 3NH

+44 1656 65222 www.cbl.com

with CBLiCBLi

29 October, 2007

Compute (Bridgend) Ltd

�� SELCOPY is a Cross platform toolSELCOPY is a Cross platform tool. .

�� MainframeMainframe, , UNIXUNIX, , Windows and iSeriesWindows and iSeries..

�� Read dataRead data, , manipulate itmanipulate it, , write outwrite out..

�� Extensive syntax can be as simple or complex as Extensive syntax can be as simple or complex as

requiredrequired. .

�� No compilation but very fastNo compilation but very fast..

�� Programs written in minutes instead of daysPrograms written in minutes instead of days..

�� CBLi is inCBLi is incclluded as an enhancement to our mainframe uded as an enhancement to our mainframe

SELCOPY productSELCOPY product..

SELCOPY Introduction SELCOPY Introduction


�� CBLi operates under TSOCBLi operates under TSO, , ISPF and as VTAM ISPF and as VTAM application on MVSapplication on MVS..

�� Also operates under VMAlso operates under VM//CMS or as VTAM CMS or as VTAM application on VSEapplication on VSE..

�� CBLi Centres on the CBLe editorCBLi Centres on the CBLe editor..

�� Designed to increase individual productivityDesigned to increase individual productivity.. �� Improving edit capabilities while maintaining familiar Improving edit capabilities while maintaining familiar ISPF feelISPF feel..

�� Integrating system navigation toolsIntegrating system navigation tools..

�� Maximizing intuitive point and shoot capabilitiesMaximizing intuitive point and shoot capabilities..

�� Using a fully flexible multi windowed display systemUsing a fully flexible multi windowed display system..

CBLi CBLi –– Introduction Introduction


�� As a developers aidAs a developers aid:: �� Provides tools in a general working environment that Provides tools in a general working environment that will increase productivitywill increase productivity..

�� SELCOPY interactive debugSELCOPY interactive debug �� Just a small part of what CBLi providesJust a small part of what CBLi provides..

�� CBLi will revolutionize the way you workCBLi will revolutionize the way you work..

�� Used extensively by our developersUsed extensively by our developers..

�� Best results using Large Screen Best results using Large Screen 32703270..

�� It saves time and moneyIt saves time and money..

CBLi CBLi –– Introduction Introduction continuedcontinued

All windows can be: minimized, maximized and resized as required.


�� Unique FeatureUnique Feature �� Commonly used commands stored in a home file Commonly used commands stored in a home file called the Command Centre called the Command Centre ((CMX suffixCMX suffix).).

�� Commands can beCommands can be: :

�� Grouped so they can be found more easily as the Grouped so they can be found more easily as the list growslist grows..

�� Executed by pressing PFExecuted by pressing PF44 on the commandon the command..

�� Across multiple linesAcross multiple lines..

�� Combined together as a single executionCombined together as a single execution, , also over also over multiple linesmultiple lines..

CBLi CBLi –– Command CentreCommand Centre


�� Unique FeatureUnique Feature

�� Issue commands directly to TSOIssue commands directly to TSO, , ISPFISPF, , CMS or VSECMS or VSE..

�� Commands can be executed immediately or Commands can be executed immediately or

promptedprompted. .

�� System symbolsSystem symbols, , user defined symbols and CBLi user defined symbols and CBLi

standard variables can be embedded in any standard variables can be embedded in any

commandcommand..

�� Grouping commands also allowsGrouping commands also allows::

�� Software Installs to be simplified and speeded upSoftware Installs to be simplified and speeded up..

�� Operations control to be simplifiedOperations control to be simplified. .

CBLi CBLi –– Command Centre Command Centre continuedcontinued

Variables can be used to tailor tasks

Common Operator Commands Common System Configuration

TCPIP Configuration

Grouping of commonly used commands helps Operators, Systems Programmers and Developers be more productive.

Command Centre File

Commands Imbedded In JCL.

Drop down Menus

List Window

PF4 immediate exec

Prompt before exec

JCL Colours

System Info

Lists can be Sorted by clicking on column headings

Utilities Menu


�� Integrated File Editor Integrated File Editor ((CBLeCBLe)) �� ISPF and XEDIT modesISPF and XEDIT modes..

�� Compatible with Windows Style Multiple Document Compatible with Windows Style Multiple Document Interface Interface ((MDIMDI..

�� LineLine//Block copyBlock copy//cutcut//paste between all windowspaste between all windows..

�� Multiple UNDOMultiple UNDO//REDO for all edit windowsREDO for all edit windows. .

CBLi CBLi –– EditorEditor


�� Integrated File Editor Integrated File Editor ((CBLeCBLe)) �� ColourColour--highlightshighlights..

�� Editor will colour fields JCLEditor will colour fields JCL, , REXX etcREXX etc

�� CustomizableCustomizable..

�� Hot key between windowsHot key between windows..

�� Context sensitive editing of Dataset NamesContext sensitive editing of Dataset Names. .

�� CTRLCTRL--X on a file DSN will invoke editor to edit that X on a file DSN will invoke editor to edit that filefile..

CBLi CBLi –– Editor Editor continuedcontinued

Sophisticated File searches

Library Copy Panel

Copy/Cut past block/line

Library list window

Note 3270 screen size


�� The original concept for CBLi developmentThe original concept for CBLi development..

�� Interactive SELCOPY DebugInteractive SELCOPY Debug �� Set Break PointsSet Break Points..

�� Track pointer variablesTrack pointer variables..

�� Watch data change as you step through the control Watch data change as you step through the control statementsstatements..

�� Modify program and rerunModify program and rerun. .

�� Multiple windows to show codeMultiple windows to show code, , storagestorage, , work areawork area, , output listingoutput listing..

�� SELCOPY Interactive demo available for SELCOPY Interactive demo available for download on CBL website at wwwdownload on CBL website at www..cblcbl..comcom

Interactive SELCOPYInteractive SELCOPY

Source Code Window

Output window

Storage Display

Console Log

Trace window

Current Step

Control keys

Track @ pointer in Red

Storage Window


�� Interactive SELCOPY DebugInteractive SELCOPY Debug

�� JCLCMX macro supplied to convert batch JCL to JCLCMX macro supplied to convert batch JCL to

interactive ALLOC statementsinteractive ALLOC statements..

�� After testing the modified code can be reAfter testing the modified code can be re--integrated integrated

with JCLwith JCL. .

�� Creates tidy up commands tooCreates tidy up commands too..

Interactive SELCOPY Interactive SELCOPY continuedcontinued


�� Integrated with CBLVCAT productIntegrated with CBLVCAT product

�� CBLVCAT providesCBLVCAT provides::--

�� VSAM Catalog reports VSAM Catalog reports

�� VSAM Dataset reportsVSAM Dataset reports

�� VSAM Tuning reportsVSAM Tuning reports

�� Reports integrated into CBLi List windowsReports integrated into CBLi List windows..

�� With colour added to improve readabilityWith colour added to improve readability. .

�� Reports can be piped to REXX variables for further Reports can be piped to REXX variables for further

processingprocessing. .

�� Edit prefix Edit prefix ‘‘ee’’ command allows editing of filescommand allows editing of files. .

CBLi with CBLVCATCBLi with CBLVCAT

CBLVCAT Job

CBLVCAT Output Window

Coloured Report

VSAM edit prefix command

VSAM KSDS File Contents window

KSDS Key Data

Note the KEY is shown in a different colour

Give it new dataset name after data changed.

Save the new file

Save starts a define panel

Click Define

Output window

Shows any errors

PF3 to return

CBLVCAT Tune Report


�� VSAM FeaturesVSAM Features..

�� Browse or Edit VSAM filesBrowse or Edit VSAM files

�� Can be modified and written backCan be modified and written back..

�� VSAM file definition dialogsVSAM file definition dialogs..

�� First save triggers VSAM definition dialogFirst save triggers VSAM definition dialog..

CBLi CBLi –– VSAM VSAM


�� Sophisticated FileSophisticated File//Library SearchesLibrary Searches..

�� Uses SQL type syntax with multiple search criteriaUses SQL type syntax with multiple search criteria. .

�� Select Select

�� WhereWhere

�� sortsort

�� PrefixPrefix''s results with instant edit commands results with instant edit command..

CBLi CBLi –– SearchesSearches

Multi line Search Command with subsets

Results Window

Different colour for each Library

Instant Edit commands (PF4)

Strings Found


�� SELCOPY has supported DBSELCOPY has supported DB//22 for yearsfor years..

�� Now itNow it’’s interactive with CBLis interactive with CBLi..

�� DBDB//22 SQL InteractiveSQL Interactive..

�� Build DBBuild DB//22 SQL queries on the flySQL queries on the fly..

�� Panel drivenPanel driven

�� Queries can be saved to command centreQueries can be saved to command centre

�� Query output window can be saved as a file for Query output window can be saved as a file for

future referencefuture reference..

CBLi CBLi –– DBDB//22

SQL List Output Window

SQL Commands

Sort on column headings

‘e’ command creates editable file

PF10/PF11 to view right/left more headings

Edit window can be saved for future reference


�� IDCAMSIDCAMS

�� Panels to build IDCAMS streamsPanels to build IDCAMS streams

�� IDCAMS can be executed directly from command IDCAMS can be executed directly from command

centre filecentre file..

CBLi CBLi –– IDCAMSIDCAMS

Click CBLi File menu option

Choose Define KSDS

Give the dataset a name

Define Dataset Panel

Keys

Cluster Data Index

Click Define to run it

Click Job to create DEFINE Deck

IDCAMS DEFINE JCL Created

‘jobcard’ macro

‘Jobcard’ macro generates jobcard sets colours.

Embedded sub and go to o/p queue

Any Errors?

Sample Interactive IDCAMS DEFINE Command

Interactive DELETE


�� Panels to Allocate datasetsPanels to Allocate datasets..

�� Automatic when new fileAutomatic when new file..

�� Library copiesLibrary copies..

�� Use to generate JCL tooUse to generate JCL too..

CBLi CBLi –– Dataset AllocationDataset Allocation

‘C’ Copy Prefix

Execute Library List

Copy Results in an IEBCOPY panel

New Name

Select Member range

Copy in Foreground

Generate JCL deck

JCL Deck Generated

‘q’ prefix can be used to show who is enqueued on file.

List my datasets

Enqueues list window


�� Intuitive drill down capability forIntuitive drill down capability for::

�� DASD ListsDASD Lists..

�� VTOC ListsVTOC Lists..

�� Dataset ListsDataset Lists..

�� Library ListsLibrary Lists..

�� Each with extended functionality forEach with extended functionality for::

�� SelectSelect, , subset and sort syntaxsubset and sort syntax

CBLi CBLi –– NavigationNavigation


�� Sorted listsSorted lists..

�� Click on column headingsClick on column headings..

�� Selection parameters include sort optionSelection parameters include sort option..

ExampleExample::

List all libraries starting with sysList all libraries starting with sys11, , with organisation PO with organisation PO

and RECFMand RECFM==V or VBV or VB::--

<< ld sysld sys11 ; ; where ORGwhere ORG==PO and PO and ((RECFMRECFM==‘‘VV’’ or RECFMor RECFM==‘‘VBVB’’) )

CBLi CBLi –– Navigation Navigation continuedcontinued

Execute

Results Window

Refine the search further

New list with selected columns

Browse back/forw between Selections.

List views

Sort headings


�� System MacrosSystem Macros..

�� Extend capabilities of CBLiExtend capabilities of CBLi..

�� Customers can add their own new functionsCustomers can add their own new functions..

�� REXX basedREXX based..

�� Samples providedSamples provided..

CBLi CBLi –– CustomisationCustomisation


�� Keyboard MappingKeyboard Mapping..

�� Extends the power of CBLiExtends the power of CBLi’’s productivitys productivity..

�� Most keys can be remappedMost keys can be remapped. .

�� Multiple functionsMultiple functions, , CtrlCtrl++, , AltAlt++, , ShiftShift+ + for most for most

keyskeys. .

�� Keymap files available for common tnKeymap files available for common tn32703270 clientsclients..

�� Customizable by customerCustomizable by customer..

CBLi CBLi –– Customisation Customisation continuedcontinued


�� Extensive FIRSTUSE tutorial with first accessExtensive FIRSTUSE tutorial with first access..

�� Guides the user through some commands and Guides the user through some commands and facilitiesfacilities..

�� This forms basis for users command centre fileThis forms basis for users command centre file..

�� User can then add their own commandsUser can then add their own commands..

�� HTML based HELP menusHTML based HELP menus. .

�� Telephone demoTelephone demo’’s available from CBLs available from CBL..

�� WEBEX demonstrations on request for multiple people WEBEX demonstrations on request for multiple people ((Max Max 1414 per sessionper session). ).

�� CBLi training courses in progressCBLi training courses in progress..

CBLi CBLi –– EducationEducation


�� The following links to a recorded audioThe following links to a recorded audio//visual playback visual playback of a CBLi demo presentationof a CBLi demo presentation..

�� httpshttps://://cblcbl..webexwebex..comcom//cblcbl//lsrlsr..phpphp??ATAT==dwdw&&SPSP==MCMC&&rIDrID==14191419

46524652&&rKeyrKey==CBDCBD10124071012407ECEC6464AA55

�� When viewing the playback of the demoWhen viewing the playback of the demo, , speakers or speakers or headphones are requiredheadphones are required..

�� AlsoAlso, , doubledouble--clicking the viewing area to maximise the clicking the viewing area to maximise the display will improve the video qualitydisplay will improve the video quality. .

CBLi CBLi –– EducationEducation


�� These slides provide only a limited sample of the CBLi These slides provide only a limited sample of the CBLi interfaceinterface. . Browse to Browse to wwwwww..cblcbl..comcom toto::

�� Download CBLi manualsDownload CBLi manuals..

�� Request a free trialRequest a free trial..

�� A sample list of customersA sample list of customers..

�� Links to Training PartnersLinks to Training Partners..

�� CBL support is free to all licensed customersCBL support is free to all licensed customers..

�� We are happy to assist customers with special coding We are happy to assist customers with special coding requirementsrequirements..

�� We welcome any feedbackWe welcome any feedback..

CBLi CBLi –– MiscellaneousMiscellaneous

“A Mainframe Evolution”

David Austin Technical Liaison Manager Compute (Bridgend) Ltd

Thank you

Compute (Bridgend) Ltd 8 Merthyr Mawr Road BRIDGEND, CF31 3NH

+44 1656 65222 www.cbl.com

with CBLiCBLi

29 October, 2007

“a mainframe evolution” - cbl · vsam catalog reports vsam dataset reports vsam tuning reports...

Documents