[ZBXNEXT-538] add support of DB2 Created: 2010 Oct 19 Updated: 2010 Nov 02 Resolved: 2010 Oct 29 |
|
| Status: | Closed |
| Project: | ZABBIX FEATURE REQUESTS |
| Component/s: | Frontend (F), Server (S) |
| Affects Version/s: | None |
| Fix Version/s: | 1.8.4 |
| Type: | New Feature Request | Priority: | Major |
| Reporter: | Aleksandrs Saveljevs | Assignee: | Artem Suharev (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
In addition to MySQL, PostgreSQL, Oracle, and SQLite, we should also support DB2. |
| Comments |
| Comment by Artem Suharev (Inactive) [ 2010 Oct 20 ] |
|
Frontend uses selects with OFFSET LIMIT statements. TO do so on IBM DB2 we have to set DB variable (db2set) DB2_COMPATIBILITY_VECTOR=3. This enables IBM DB2 compatibility mode with Oracle. |
| Comment by Artem Suharev (Inactive) [ 2010 Oct 20 ] |
|
Another limitation (frontend): We can't specify schema. Used default one for user. |
| Comment by Aleksandrs Saveljevs [ 2010 Oct 20 ] |
|
If used schema is not the same as database name, Apache hangs using 100% CPU. |
| Comment by Aleksandrs Saveljevs [ 2010 Nov 01 ] |
|
Merged into pre-1.8.4 in r15184. |
| Comment by Artem Suharev (Inactive) [ 2010 Nov 02 ] |
|
Merged |