1 / 65

The Scoop: Adabas v5.1 for Open Systems, v8.1 for the Mainframe and Adabas Manager

jana
Download Presentation

The Scoop: Adabas v5.1 for Open Systems, v8.1 for the Mainframe and Adabas Manager

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. The Scoop: Adabas v5.1 for Open Systems, v8.1 for the Mainframe and Adabas Manager Becky Albin August 2005

    2. 26-May-12 Proven Performance & Enterprise-wide Interoperability

    3. 26-May-12

    4. 26-May-12

    5. Adabas v5.1

    6. 26-May-12

    7. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features MU and PE occurrences higher than 191 (32k) Non Descriptor Search capability UNICODE Support Long Alpha (LA option) Fields 16k Descriptors can be upto 1142 bytes

    8. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features LF Command For mainframe compatability SQL DDL support - Create/Drop Table/Column Record counter for SQL Support Faster processing of SELECT COUNT(*) FROM TABLENAME Number of records stored in FCB Backward Compression Main/Upper Indices

    9. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features No limit on File extents SQL CREATE TABLE does not require size Dynamic Hold Queue Tolerate Corrupted Index Rsp code 48 if index is accessed

    10. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features WORK dataset reorganization Part 2 & 3 are combined Parameters removed Allocated from temporary working space WORK is used for Part 1 processing only LP parameter removed Unlimited SORT space for S2/S9 LS parameter removed

    11. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features Automatic extension of temporary Work space Nucleus or Utilities, SORT and TEMP used Dynamically allocated and released Automatic container file extensions ASSO/DATA Expands last extent or New container created ADANUC/ADADBM

    12. 26-May-12 Adabas v5.1 for Open Systems V5.1 Features Utility Changes ADACMP ADADBM ADADCU ADAFDU ADAFRM ADANUC

    13. Adabas Installation via CD CD Delivery for z/OS and VSE

    14. 26-May-12 Adabas for z/OS

    15. 26-May-12 Adabas for z/OS When transferring the Container and Copy.Job file from Windows to z/OS with FTP, then modify the COPY.JOB as follow: Change SAGLIB to a valid high level qualifier Change USER to a current UserID

    16. 26-May-12 Adabas for VSE

    17. 26-May-12 Adabas for VSE Insert CD into CD drive, suppose D: Start Virtual Tape Server on PC On VSE; job TAPESRVR which handles the virtual tape must be on reader queue Jobs which access the AWSTAPE file should include statements to handle virtual tape DVCDN 192 VTAPE START,UNIT=192,LOC=111.111.111.111:2386, X FILE='D:/SAG.T76211',READ DVCUP 192

    18. 26-May-12 Adabas for VSE FTP file SAG.COPY.JOB to VSE Change JCS before submitting job SAGLIB with the name of the library 192 with CUU of virtual tape device 111.111.111.111 with TCPIP address of PC

    19. Adabas v8.1

    20. 26-May-12 Adabas v8 An Adabas V8 nucleus will support and execute all features as supported by a V74 nucleus

    21. 26-May-12 Adabas v8 New Features Lifting Repeating Field Limits Lifting Record Limits Lifting Extent Limits New Field Formats Enhanced Direct Call Interface Adabas System Manager

    22. 26-May-12 Lifting Repeating Field limits MU/PE limits Increase to 2 bytes - 191 to 65,535 occurrences Occurs at the file level Count field in Index Block increased by one byte; re-invert would be required for PE descriptors New Hyper-exit required for expanded MU/PE count Adabas v8 Lifting Limits

    23. 26-May-12 Lifting Repeating Field limits MU/PE limits may result in: Larger records not fitting into one data storage block or The LWP (Work Pool) size definition may need to be increased to accommodate the update a higher count of occurrences. The LP (WORK Part 1) size definition may need to be increased to accommodate the large number of occurrences. The LFP (Internal Format Pool ) size definition may need to be increased because the Internal Format Element has increased. The total format may be as large as 2G. Adabas v8 Lifting Limits

    24. 26-May-12 Lifting Record Limits Large Record Support Compressed Record may exceed one physical Data Storage Block Optional feature that would be set at the file level Logical record will be split at the field level Data Storage will reflect an Expanded Record Primary Record allocated as always Secondary Records allocated with different AC extents Secondary ISN allocation transparent to the application FCB to reflect both AC allocations Impact on the FCB for AC allocations Segment of a logical record may be read/updated independent of other records Adabas v8 Lifting Limits

    25. 26-May-12 Lifting Record Limits Simple Adabas v8 Lifting Limits

    26. 26-May-12 Lifting Record Limits Large Record Support Physical sequential commands will automatically skip the secondary records in the data storage. Read by ISN will be unaffected Primary records are included in top ISN and MAX-ISN. Maximum Record Length, specified for a file, will have no relevance for file supporting this feature. Utilities that report on maximum record length will now state n/a. ISN settings for the utility (e.g. MIN-ISN option with Load) will refer to the primary ISNs only (NOT secondary) Primary ISNs will be counted from MINISN to MAXISN, and secondary ISNs will be counted from MINSEC to MAXSEC A larger NISNHQ parameter may need to be specified for doing updates Adabas v8 Lifting Limits

    27. 26-May-12 Lifting Record Limits Large Record Support Segmentation is done by field unless this is not feasible. Segmentation by byte is done for long alpha fields and long wide fields. All utilities that use compressed or uncompressed data are enhanced to support spanning of the logical record across multiple records on the operating system files. need to be increased since space is needed to store both the before and after image of the spanned record. This can also be for several update threads running in parallel. Space to accommodate a large DVT is also needed (up to 65K occurrences permitted). Adabas v8 Lifting Limits

    28. 26-May-12 Lifting Field Limits Large Object Field Types Single field up to 2G in size Fields may contain any type of date, example: Jpegs AVI files PPT, XCL Large documents Images Fingerprints Separate file entity for LOB field types Requires change to ACB Support for segmented Buffers Permit Length optimization with communication protocol Adabas v8 Lifting Limits

    29. 26-May-12 Adabas v8 Lifting Limits

    30. 26-May-12 Lifting Field Limits Large Object Field Types May have any of the options NU, NC, NN, NV, NB, or MU. NV-option (no conversion) specifies that no conversion is to occur NB-option (no blank compression) for alphanumeric or wide character fields NC-option (SQL Null Value) for Field may contain a null value NN-option (SQL not Null) for Field defined with NC option must always have a value defined Cannot have the options FI (fixed) or LA (long alpha). Cannot be a descriptor or a parent of a special (phonetic, sub-, super-, or hyper-) descriptor. Cannot be specified in a search buffer. May be part of a simple group or a PE-group. Adabas v8 Lifting Limits

    31. 26-May-12 Lifting Field Limits Large Object Field Types Example FDT: 1,L1,0,A,LB,NU ? null-suppressed character LOB 1,L2,0,A,LB,NV,NB,MU ? multiple-value binary LOB 1,GR,PE ? periodic group 2,L3,0,W,LB,MU,NU ? null-suppressed multiple-value wide character LOB in PE-group Adabas v8 Lifting Limits

    32. 26-May-12 Lifting Field Limits Large Object Field Types Example Format Buffer FB=L1. ? LOB field L1 FB=L21. ? Occ 1 of multiple-value LOB field L2 FB=L1,50000,AA,10,A. ? 50,000 bytes for L1, + 10 bytes for AA FB=L1,0,AA,10,A. ? 4-byte length of L1, + L1 field, + AA Adabas v8 Lifting Limits

    33. 26-May-12 Large Object Field Types Length specification New Format Buffer Option xxL xxL in the format buffer returns the compressed field length in binary format Rules: AAL has to be defined in front of AA. AAL can occur as a single field with/without field AA. AAL definition in an update format buffer is ignored. Example: FB=L1L,4,B. ? length element for LOB field L1 FB=L2L1,4,B. ? length element for first value of multiple- value LOB field L2 Adabas v8 Lifting Limits

    34. 26-May-12 Lifting Physical Extent Limits GCB Changes Adabas v8 Lifting Limits

    35. 26-May-12 Lifting Logical Extent Limits FCB Changes Adabas v8 Lifting Limits

    36. 26-May-12 Lifting Logical Extent Limits Adabas V7 Structure Adabas v8 Lifting Limits

    37. 26-May-12 Lifting Logical Extent Limits Adabas V8 Structure Adabas v8 Lifting Limits

    38. 26-May-12 FDT Changes May be larger than 4 blocks Will move from the fixed area to the dynamic area in Asso Increase Field Definition Element size Support new Field data types of Large Object Support only I and S options for LF command new Command Option X to allow the read of the extended FDT Extend Long Alphas to specify lengths > 253 and < 16K Positioned for the future e.g.Date/Time formats Adabas v8 Lifting Limits

    39. 26-May-12 Enhanced Direct Call Interface Needed for RBL > 32K Needed for LOBs Needed for segmented Record Buffers Format Buffers will map the Record Buffers; 1:1 Increased number of Command Option fields Increased number of Additions Field Increased size for User area Positioned for the future Adabas v8 Lifting Limits

    40. 26-May-12 Enhanced Direct Call Interface Adabas Calling Procedure between V7 and V8 Adabas v8 Lifting Limits

    41. 26-May-12 Enhanced Direct Call Interface Adabas Calling Procedure between V7 and V8 User exits 1 and 4 will be replaced by exits 11 and 14 Original ACB will still be supported Nucleus will primarily run in ACBX mode Conversion normally performed during router logic New Adalinks will no longer be provided in source form New ACBX interface required only with new features Adabas v8 Lifting Limits

    42. 26-May-12 Enhanced Direct Calls Interface Adabas v8 Lifting Limits

    43. 26-May-12 Enhanced Direct Calls Interface Adabas v8 Lifting Limits

    44. Adabas System Manager for Simplified DB Administration

    45. 26-May-12 Adabas System Manager features Browser front end for low footprint Web base technology for the central control of: Database and other Administration (AOS/ABS, WCP, REV) Session Monitoring (ADA, REV) Trend analysis (ASF/REV) Single standard interface to manage Adabas, Net-work, Tamino, Entire Communicator and various database add-on tools and utilities similar look and feel across platforms and products Facilities for both mainframe and Workstation products (e.g. Adabas 8 on the mainframe and Adabas 5 on Open systems) Same tool for Adabas on different platforms, hides underlying functionality differences Adabas Manager

    46. 26-May-12 Adabas System Manager features Advancements: Text in colour Use of GUI/GIF images (e.g. Pie, Bar, Curve) Language support Standardized Paging facility Drop Box option for command list or display options Column Sorting Search with page facility Flexible Column selection Icon usage Agent Filtering Standardization in column specification and alignment Adabas Manager

    47. 26-May-12 Adabas Manager

    48. 26-May-12 Adabas Manager

    49. 26-May-12 Adabas Manager

    50. 26-May-12 Adabas Manager

    51. 26-May-12 Adabas Manager

    52. 26-May-12 Adabas Manager

    53. 26-May-12 Adabas Manager

    54. 26-May-12 Adabas Manager

    55. 26-May-12 Adabas Manager

    56. 26-May-12 Adabas Manager

    57. 26-May-12 Adabas Manager

    58. 26-May-12 Adabas Manager

    59. 26-May-12 Adabas Manager

    60. 26-May-12 Adabas Manager

    61. 26-May-12 Adabas Manager

    62. 26-May-12 Adabas Manager

    63. 26-May-12 Adabas Manager This morning, hopefuly you heard Joe Gentry talk about Software AGs ETS line of Business and what are goals are for Enterprise systems. For the ETS line of business, we have 3 areas of focus and for this session we will focus on the first, Data Mgmt. 1 What we are dedicated to for Data Mgmt is the following 24X7 high avialability and scalability High speed mass data processing and more and more Open interfaces and data distribution.This morning, hopefuly you heard Joe Gentry talk about Software AGs ETS line of Business and what are goals are for Enterprise systems. For the ETS line of business, we have 3 areas of focus and for this session we will focus on the first, Data Mgmt. 1 What we are dedicated to for Data Mgmt is the following 24X7 high avialability and scalability High speed mass data processing and more and more Open interfaces and data distribution.

    64. 26-May-12 Adabas Manager

    65. 26-May-12 Adabas v5.1 and v8.1 and thats it for now Questions? Comments?

    66. 26-May-12 Adabas v5.1 and v8.1 and thats it for now Questions? Comments?

More Related