IBM Db2 for i (AS/400) with DBine
How to connect DBine to IBM Db2 for i (AS/400) and what you can do once it's connected. This page is written from what the IBM Db2 for i (AS/400) driver says about itself, so it matches the version of DBine you download.
Connect
- In DBine, open New connection.
- Pick IBM Db2 for i (AS/400) in the list of engines.
- Fill in the fields below, press Test connection and then Save.
Default port: 8471.
General
| Field | Description |
|---|---|
| Server required | Example: localhost |
| Default library | |
| User | |
| Password | Kept in the system keychain, never in DBine's files. |
| ODBC driver | ODBC driver name as shown in odbcinst.ini. It comes with IBM i Access Client Solutions (“Application Package” for Windows, Linux or macOS), downloadable from the IBM site. Default: IBM i Access ODBC Driver |
| Read-only | On or off. |
SSH tunnel. The connection can go through an SSH server, even through a chain of bastions, with a password, a private key or the SSH agent. The server's fingerprint is checked against known_hosts or confirmed the first time.
Advanced
| Field | Description |
|---|---|
| Additional attributes | They are appended to the end of the ODBC connection string and replace the ones with the same name (TLS, timeouts, character set, Kerberos or Windows integrated security…). Example: Key=Value;OtherKey=Value |
| Script sending | How a script is sent to the server. If the engine accepts several statements per request, “All text at once” keeps blocks such as BEGIN … END intact. Options: One statement at a time (separated by ;), Blocks separated by GO, All the text at once Default: One statement at a time (separated by ;) |
| ODBC library | Path to the ODBC driver manager (libodbc.2.dylib, libodbc.so.2 or odbc32.dll), only if it isn't found in the usual paths. A file on this computer. |
What the explorer shows
The objects appear right under the connection:
- Tables
- Views
- Procedures
- Functions
- Sequences
- Synonyms
Query editor
The editor uses SQL, with completion for the connection's objects. Statements and commands run against the database selected in the tab.
Ready-made templates for new objects:
- New view
- New procedure
- New function
- New trigger
- New sequence
Tools for IBM Db2 for i (AS/400)
Available
- Server monitor
- Sessions and running queries
- Cancel another session's query from the sessions list
- Manual transactions (commit and rollback)
- Index usage
- Relations in the ER diagram
- Visual designer for new objects
- Rename objects
- Compare and sync schemas
- Native bulk load when migrating data
- Users and permissions
- Backups
Not available for IBM Db2 for i (AS/400)
- Graphical execution plans
- Live query profiler
- End a session
- Locks: who blocks whom
- Create databases
- Drop databases
- Database properties
- Clone tables
Why a tool doesn't apply to an engine, and the details of each one, are in the engine support reference.
Generated from the IBM Db2 for i (AS/400) driver 0.1.11, which DBine downloads the first time you connect to IBM Db2 for i (AS/400).