Home > IT Answers > How to check DBI version on IBMi v7r1
jailall101
725 pts.
 How to check DBI version on IBMi v7r1
DBI, IBMi, Zend Server
Hi I would like to know how to check the version of DBI that we are running. We have IBMi v7r1 and zend server 5.6.0.

Software/Hardware used:
IBMi V7R1, Zend Server 5.6.0
ASKED: January 31, 2013  6:51 PM
UPDATED: January 31, 2013  7:28 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by jailall101 (Question Asker)

Does "DBI" mean "DB2"? If it does and you have i 7.1, then the version of DB2 is 7.1 or V7R1M0. The DB2 version on i is always the same version as the OS. The version of DB2 for i is not the same as any version of DB2 running on other platforms. DB2 on i is integrated with the OS. -- Tom

ANSWERED:  Feb 1, 2013  1:03 AM (GMT)  by jailall101
 
Other Answers:
Last Wiki Answer Submitted:  January 31, 2013  7:28 pm  by  Michael Tidmarsh   11,410 pts.
Latest Answer Wiki Contributors:  Michael Tidmarsh   11,410 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks tom for clearing that up. Can you tell me the difference between Zend DBi and DB2 for i. Are they the same thing? Its a bit confusing. 

jailall101
 725 pts.
 

Zend DBi… Okay, I understand. Sorry, I misunderstood. That’s a MySQL build for i that is compiled for Power systems and supplied by Zend. It was made available after Oracle announced that MySQL would no longer be compiled for Power a couple years ago. Included is the DB2 Storage Engine that uses DB2 as the underlying storage while keeping MySQL interfaces for PHP. On the outside, it looks like MySQL is doing everything. The released version of Zend DBi is 5.1.59, but I’ll have to do some checking to see what methods are available to query the version from DBi. — Tom

TomLiotta
 108,260 pts.