IBM Db2 is a family of data management products for enterprise workloads, available on-premises, in containers, and across cloud platforms.
Installation
Required packages: ibm_db_sa
Drivers
ibm_db_sa (with LIMIT)Recommended
ibm_db_sa (without LIMIT syntax)
db2+ibm_db://{username}:{password}@{hostname}:{port}/{database}Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 38/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Compatible Databases
The following databases are compatible with the IBM Db2 for i driver:
IBM Db2 for i (AS/400)Db2 for i is a fully integrated database engine on IBM i (AS/400) systems. Uses a different SQLAlchemy driver optimized for IBM i.
ibmi://{username}:{password}@{host}/{database}Parameters:
| Parameter | Description |
|---|---|
| username | IBM i username |
| password | IBM i password |
| host | IBM i system host |
| database | Library/schema name |
Resources