IBM eserver i5 - Iseries ODBC Driver for Linux (5733-L01)

To Next Page

To Previous Page

5486LPAccess.fm Draft Document for Review October 18, 2004

734 IBM Eserver i5 and iSeries System Handbook

iSeries ODBC Driver for Linux (5733-L01)

The iSeries ODBC Driver for Linux is an ODBC driver that allows you to access

the iSeries database from a Linux client. Linux applications written to the ODBC

API can use this driver to connect to an iSeries server to access the database.

iSeries ODBC Driver for Linux (5733-L01)

Product number 5733-L01

Minimum operating

system level

V5R1

Related products iSeries Access for Windows (5722-XE1) and iSeries Access for Web

(5722-XH2)

Client code This product is client code

Replaces product

Further information http://www-1.ibm.com/servers/eserver/iseries/linux/odbc

Main Page

Default Chapter1
- Front Cover1
- Table of Contents5
Notices25
- Trademarks26
Preface29
- The Team that Wrote this Redbook30
- Become a Published Author33
- Comments Welcome33
Chapter 1. The Next Generation Iseries37
- Simplicity in an on Demand World38
- Looking Toward the Future40
  - I5 and Iseries43
Chapter 2 . Iseries Architecture: Fundamental Strength of the IBM ^44
- System Concepts44
- Iseries Architecture45
- Iseries Integration with the Windows Server58
- Reliable, Managed Availability59
- Virtualization Technology62
- AIX 5L for Eserver I564
  - AIX 5L Version 5.365
    - AIX 5L Version 5.265
    - AIX 5L and Logical Partitions66
- Linux for Iseries and Eserver I567
- IBM I5/Os67
  - Object-Based68
  - DB2 Universal Database69
- Java and E-Business for Iseries69
- Iseries Web Serving70
- Lotus Domino for Iseries70
- Iseries Advanced User Interface70
- Summary73
Chapter 3. Workload, Capacity, and Performance75
- Commercial Processing Workload76
  - 5250 Cpw76
  - 5250 Devices77
- Communication WAN Restrictions78
- Iseries Server Structure and Terminology78
  - Server Feature78
  - Single Address78
- Simultaneous Multithreading Explained79
- Iseries for Domino Performance Terminology80
- Capacity on Demand80
- Workload Measurement and Sizing Tools87
- Iseries Editions92
  - Solution Edition94
Chapter 4. Iseries Direction101
- Product Previews102
  - Product Previews: Open102
  - Product Previews: Closed105
- Statement of Direction105
  - Statement of Direction: Open105
  - Statement of Direction: Closed106
- Planning Information107
- Withdrawn Products110
  - Features and Devices Not Supported with V5R3111
  - Features and Devices Not Supported with V5R2111
Chapter 5. Summary of Today's Iseries115
- Table 1: Summary of the Iseries Model 520117
- Summary of the Iseries Expansion Units and Towers139
- Notes for All Summary Tables141
- Notes for All Summary Tables142
Chapter 6. Iseries Model 520145
- Model Overview146
- Processor Features151
- Main Storage152
- 9406 Model 520 Schematics153
- Model 520 PCI Cards and Features157
- External Towers158
- Model 520 Upgrades158
Chapter 7. Iseries Model 550159
- Model Overview160
- Processor Features164
- Main Storage164
- 9406 Model 550 Schematics165
- Model 550 PCI Cards and Features169
- External Towers170
- Model 550 Upgrades170
- On Demand Features170
Chapter 8. Iseries Model 570173
- Model Overview174
- Processor Features179
- Main Storage180
- 9406 Model 570 Schematics183
  - 9406 Model 570 System Unit Front, Rear, and Top Views183
  - Model 570183
- High-Speed Link for Model 570186
- Model 570 PCI Cards and Features187
- External Towers187
- Model 570 Upgrades188
- On Demand Features188
Chapter 9. Iseries Model 595193
- Model Overview194
- Processor Features199
- Main Storage200
  - Memory Placement201
- 9194 Base PCI-X Expansion Tower201
  - 5168 30-Disk Expansion for #9194 Tower202
  - 8294 Optional Base 1.8M Rack203
- 8294 Optional Base 1.8M Rack Schematic204
- High-Speed Link for Model 595210
- Model 595 PCI Cards and Features211
- External Towers212
- Model 595 Upgrades212
- On Demand Features212
Chapter 10. Iseries Model 800215
- Model Overview216
- Processor Features220
- Main Storage221
- 9406 Model 800 Schematics221
- High-Speed Link on Model 800224
- Model 800 PCI Cards and Features224
- External Towers225
- Model 800 Upgrades225
Chapter 11. Iseries Model 810227
- Model Overview228
- Processor Features232
- Main Storage233
- 9406 Model 810 Schematics234
  - Model 810234
  - 9406 Model 810 System Unit235
- High-Speed Link on Model 810237
- Model 810 PCI Cards and Features237
- External Towers238
- Model 810 Upgrades238
Chapter 12. Iseries Model 825239
- Model Overview240
- Processor Features244
- Main Storage244
- 9406 Model 825 Schematics245
  - Model 825245
  - 9406 Model 825 System Unit246
- High-Speed Link on Model 825247
- Model 825 PCI Cards and Features248
- External Towers248
- Model 825 Upgrades249
- On Demand Features249
Chapter 13. Iseries Model 870251
- Model Overview252
- Processor Features256
  - Standby Processor256
- Main Storage257
- 9094 Base PCI I/O Enclosure259
- 9406 Model 870 Schematics261
- High-Speed Link on Model 870267
- Model 870 PCI Cards and Features267
- External Towers268
- Model 870 Upgrades268
- On Demand Features268
Chapter 14. Iseries Model 890271
- Model Overview272
- Processor Features276
- Main Storage277
- 9094 Base PCI I/O Enclosure279
- 9406 Model 890 Schematics283
- High-Speed Link on Model 890289
- Model 890 PCI Cards and Features289
- External Towers290
- Model 890 Upgrades290
- On Demand Features290
Chapter 15. Towers, Racks, and High-Speed Link293
- PCI and PCI-X Expansion Towers294
- Racks319
- High-Speed Link327
Chapter 16. Upgrades to Iseries Servers341
- Upgrade Considerations343
- 5250 OLTP Considerations344
- Hardware Migration Considerations344
  - Capacity on Demand Upgrades347
- Edition Upgrades348
- RISC-To-RISC Data Migration (#0205)349
- Migration Towers349
  - SPD Expansion Towers349
- Upgrade Options for Expansion Towers350
Chapter 17. Iseries I/O Processors353
- System Unit Hardware (PCI)354
- Migration Tower PCI Hardware367
- Migration Tower SPD Hardware369
Chapter 18. Iseries I/O Adapters and Controllers373
- PCI Card Technology374
- System Unit Hardware (PCI)379
- Migration Tower PCI Hardware407
- Migration Tower SPD Hardware408
- Homologation409
Chapter 19 . Internal Disk, Tape, CD-ROM, DVD-RAM, DVD-ROM Storage 381416
- PCI Disk Units416
- Disk Storage Specifications Comparison417
- Disk Unit Conversion418
- RPQ 847102 10K RPM DASD to PCI Tower Mounting418
- Load Source Specify Features419
- Disk Protection and Hardware Compression419
- Internal Tape, CD-ROM, DVD-RAM, and DVD-ROM422
  - Internal Tape Device Specifications424
  - Tape Device Technology426
- Internal Tape Features428
- Internal CD-ROM, DVD-RAM, and DVD-ROM Drives430
Chapter 20 . External Tape, DVD-RAM, Optical, Disk Storage, and SAN440
- External Storage Tape440
- External Tape Storage Automated Library Specifications453
  - Tape Device Terminology456
- Magnetic Media Controller Transfer Rates457
- External Storage DVD-RAM457
  - IBM 7210 Model 025 External DVD-RAM Drive457
  - IBM 7210 Model 030 External DVD-RAM Drive458
- External Optical Storage459
  - IBM 3995 Optical Library CXX Models459
- External Disk Storage Devices460
- Storage Area Network Components464
  - IBM SAN Switches and Directors for IBM Eserver I5 and Iseries465
Chapter 21. I/O Devices and Other Components471
- Iseries Printers472
- Iseries Workgroup Printers474
- Multifunction Printing Options480
- Iseries Departmental and Production Printers480
Chapter 22. Customer Install Features493
- OS/400 Features Supported on Iseries Servers494
- Model 520, 550, 570, 595 System Unit and Tower Features495
- Model 800, 810, 825, 870, #2497/#2498 890 System Unit, Tower Features507
- Model 250, 270, 820, 830, 840, #2487/#2488 890 System Unit, Tower Features518
Chapter 23. I5/Os and OS/400 (5722-SS1): Architecture537
- Linux for Iseries540
- SSTAR Technology540
- XML Enablers544
- IBM Java for Iseries545
- New Processor Resource Functions with I5/Os V5R3546
  - I5/Os and OS/400 Base Functions547
- I5/Os and OS/400 Integrated Functions548
- Integrated File System564
- Ease of Installation, Use, and Maintenance with I5/Os and OS/400567
- Availability and Recovery572
- GUI Management and Administration585
Chapter 24. I5/Os (5722-SS1): Operating System Licensed Products591
- New with V5R3592
- IBM I5/Os Overview593
- National Language and Multilingual Support594
- Options and Licensed Programs Offered with IBM I5/Os597
- Programs Within IBM I5/Os597
- IBM I5/Os V5R3 Options609
- Supported Upgrade Paths625
- OS/400 Single Step Upgrades626
- Current Release to Previous Release Support626
  - Single-Step Upgrades626
Chapter 25. Software Terms627
- Software Maintenance for Iseries628
- Software License and Upgrades628
- OS/400 Terms and Conditions Changes635
- Keyed Stamped Media Distribution638
  - Keyed Stamped Media Distribution for V5R3638
- Software Keys and Guidance for LPAR System Upgrades639
Chapter 26. IBM Licensed Programs: Database Accessories643
- DB2 OLAP Server for Iseries V8.1 (5724-B78)644
  - Solutions and Benefits646
- IBM DB2 Datapropagator for Iseries V8.1 (5722-DP4)647
  - Solutions and Benefits648
  - New with Version 8.1648
- IBM Query for Iseries (5722-QU1)649
- IBM DB2 Query Manager and SQL Development Kit for Iseries (5722-ST1)650
- IBM DB2 QMF Distributed Edition for Multiplatforms V8.1 (5724-E86)653
- IBM System/38 Utilities for AS/400 (5722-DB1)654
- DB2 Spatial Extender Version 8 (5765-F40)655
- DB2 Table Editor for Iseries, V4.3 (5697-G84)655
- IBM DB2 Web Query Tool for Iseries V1.3 (5697-G85)657
- IBM DB2 Universal Database Extenders for Iseries V8 (5722-DE1)659
- IBM DB2 UDB Workgroup Server Edition for Linux (5733-LD1)661
Chapter 27. Websphere and on Demand Business for Iseries665
- Product Positioning: Websphere Application Server and Jakarta Tomcat668
- IBM Websphere Application Server - Express for Iseries (5722-E51)668
- IBM Web Enablement for Iseries (5722-WE1)672
  - Benefits673
- IBM Business Solutions Version 1.0 (5722-BZ1)673
- IBM Websphere Application Server Version 5.1 for Iseries (5733-W51)676
- IBM Websphere Application Server Version 5.1 for Iseries Developer Edition679
  - (5724-D18)679
  - Solutions and Benefits680
- IBM Websphere Commerce for Iseries, Version 5.6680
- IBM Connect for Iseries Version 2.0 (5733-CO2)684
  - Solutions and Benefits685
  - New with Version 2.0686
- IBM Websphere Portal - Express, IBM Websphere Portal - Express Plus for Multiplatforms, Version 5 (5724-E77)687
- IBM Grid Toolbox V3 for OS/400 (5733-GT1)689
  - Solutions and Benefits690
  - Features691
Chapter 28. Lotus Products for Iseries693
- Domino on Iseries694
- Domino Server Options695
- IBM Lotus Domino 6.5 for Iseries (5733-L65)696
- Domino Notes Client Choices698
  - New with Lotus Domino Clients 6.5699
- IBM Lotus Enterprise Integrator for Iseries (5733-LEI)700
  - New with Lotus Enterprise Integrator 6.5701
- IBM Lotus Instant Messaging and Web Conferencing (5733-LST)702
  - Features and Benefits703
- IBM Lotus Team Workplace (5733-LQP)703
  - Features and Benefits704
- IBM Lotus Domino Document Manager (5769-LDD)705
  - Features and Benefits706
- IBM Integrated Domino Fax for Iseries (5733-FXD)706
  - Features and Benefits707
Chapter 29. IBM LPP Application Development Products709
- IBM CICS Transaction Server for Iseries (5722-DFH)710
  - New with V5R3711
  - Features711
- IBM Toolbox for Java (5722-JC1)713
- IBM Developer Kit for Java (5722-JV1)719
- System/36 Migration Aid (5727-MG1)719
- System/38 Migration Aid (5714-MG1)720
- IBM Application Program Driver for AS/400 (5722-PD1)720
  - Solutions and Benefits721
  - Features721
- IBM Visualage Generator Server for AS/400 (5769-VG1)722
- IBM Websphere Development Studio for Iseries (5722-WDS)722
  - Solutions and Benefits723
- Server Components of 5722-WDS724
- Workstation Components of 5722-WDS731
  - XML Toolkit for Iseries (5733-XT1)736
Chapter 30. IBM Licensed Programs: Networking Products739
- IBM Cryptographic Access Provider 128-Bit for Iseries (5722-AC3)740
- IBM Eserver Iseries Client Encryption (128-Bit) (5722-CE3)741
- IBM Cryptographic Support for AS/400 (5722-CR1)741
- IBM Communications Utilities for Iseries (5722-CM1)742
- IBM Distributed Computing Environment des Library Routines for744
  - 5769-Dc3744
- IBM Websphere MQ for Iseries, V5.3 (5724-B41)744
- IBM Mqseries for Iseries, V5.2 (5733-A38)746
- IBM Mqseries Integrator for Iseries and DB2 Version 1.1 (5697-F49)747
- IBM Websphere Host Integration Solution for Iseries V4.1 (5724-F84/F86)747
Chapter 31. IBM Eserver Iseries Access Products749
- IBM Eserver Iseries Access Family (5722-XW1)750
  - Components751
- IBM Eserver Iseries Access for Windows (5722-XE1)751
- IBM Eserver Iseries Access for Web (5722-XH2)757
- IBM Eserver Iseries Access for Linux (5722-XL1)763
- IBM Websphere Host Access Transformation Server Limited Edition (5724-F97-01)764
  - Features and Benefits765
- IBM Eserver Iseries Access for Wireless (5722-XP1)765
  - Solutions and Benefits766
  - Features767
- Iseries ODBC Driver for Linux (5733-L01)768
  - Services769
Chapter 32 . IBM Licensed Programs: System Management Products and770
- Iseries Operations Console: Direct Attach, LAN, Remote, and HMC770
- IBM Eserver Technical Support Advantage777
  - IBM Tivoli Storage Manager Extended Edition (5698-A11)778
    - Benefits779
- IBM Backup Recovery and Media Services for Iseries (5722-BR1)779
- IBM Advanced Job Scheduler for Iseries (5722-JS1)786
- IBM Managed System Services for Iseries (5722-MG1)786
  - Benefits787
  - New with V5R3788
- IBM System Manager for Iseries (5722-SM1)788
- IBM Software Integration Assistant for Iseries (5722-IA1)791
  - Benefits792
  - Features792
- IBM Intelligent Communications Trace Analyzer for Iseries, Version792
  - (5733-Az1)792
- IBM Performance Tools for Iseries (5722-PT1)793
  - Features794
- PATROL for Iseries - Predict (5620-FIF)795
  - Products799
Chapter 33 . IBM Licensed Programs: Printing and Document Handling800
- IBM Advanced Function Printing Utilities for Iseries (5722-AF1)800
  - Solutions and Benefits801
  - Features801
- IBM Advanced DBCS Printer Support for Iseries (5722-AP1)802
  - Features802
- IBM AFP Font Collection for Workstations and OS/400 (5648-B45)804
- IBM Dictionary and Linguistics Tools for AS/400 (5769-DL1)805
  - Solutions and Benefits806
  - Features806
- IBM Business Graphics Utility for AS/400 (5722-DS1)807
  - Solutions and Benefits807
  - Features807
- IBM Infoprint Fonts for Multiplatforms (5648-E76)808
- IBM Facsimile Support for Iseries (5798-FAX)809
  - Solutions and Benefits810
  - Features810
- IBM Advanced Function Printing Fonts for AS/400 (5769-FNT)811
- IBM Advanced Function Printing DBCS Fonts for AS/400 (5769-FN1)812
- IBM Infoprint Designer for Iseries (5733-ID1)813
- Infoprint Server for Iseries (5722-IP1)816
- IBM Content Manager for Iseries (5722-VI1)822
  - Solutions and Benefits823
  - Features823
- IBM Print Services Facility for Iseries (PSF/400)824
Chapter 34. Summary of Earlier AS/400, As/400E, and Iseries Models831
- CISC Systems832
- RISC Servers832
- Iseries and As/400E Servers833
- Notes for All Summary Tables866
Appendix A. Referenced Lists869
- Communication References870
- Options Included in OS/400 V5R2872
- Features and Devices Not Supported with V5R1873
- Products and Features no Longer Marketed by IBM874
  - Hardware no Longer Marketed by IBM874
- Software End-Of-Support Dates897
Abbreviations and Acronyms899
- Simultaneous Multithreading904
Related Publications907
- IBM Redbooks907
  - Other Resources908
  - Iseries Model908
- Referenced Web Sites909
- How to Get IBM Redbooks913
- Help from IBM914
Index915
- Schematic927
- Model 100 798927
- Model 170 798927
- Model 200 798927
- Model 20S 798927
- Model 236 798927
- Model 30S 798927
- Model 400 798927
- Model 40S 798927
- Model 436 798927
- Model 600 798928
- Model 620 798928
- Model 640 798928
- Model 650 798928
- Model S10 798929
- Model S20 798929
- Model S20 Custom Mixed-Mode Server 798929
- Model S30 798929
- Model S40 798929
- Features930

IBM eserver i5 - Iseries ODBC Driver for Linux (5733-L01)

Table of Contents

Other manuals for IBM eserver i5

Related product manuals