Midrange News for the IBM i Community

Posted by: WestCoastGuy
DB2 on the Iseries
has no ratings.
Published: 09 Nov 2011
Revised: 23 Jan 2013 - 4138 days ago
Last viewed on: 22 May 2024 (5798 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

DB2 on the Iseries Published by: WestCoastGuy on 09 Nov 2011 view comments(2)

How do I verify that my Iseries has DB2? Isnt DB2 already loaded on the Iseries?

Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: WestCoastGuy
Premium member *
Comment on: DB2 on the Iseries
Posted: 12 years 6 months 14 days 15 hours 22 minutes ago

Sorry, I should have looked at the licensed programs on my Iseries first. The command , WRKLICINF, shows the DB2 edition loaded already.

Posted by: DaleB
Premium member *
Reading, PA
Comment on: DB2 on the Iseries
Posted: 12 years 6 months 14 days 13 hours 58 minutes ago

Not sure what you're looking at WestCoastGuy. DB2 is part of SS1. It is not a separate feature, it is not separately installable, and it does not show up in WRKLICINF or as a line anywhere in GO LICPGM options. Don't be confused by other items that have DB2 in the name. They are add ons to provide additional capability, enhanced performance, and the like.

For example, 57xxST1, DB2 Query Mgr and SQL DevKit, gives you Query Manager, interactive SQL (STRSQL command), and the precompilers for using embedded SQL in HLL's. ST1 does not provide the run time; the run time is just the OS (SS1). An SQL RPG program (that was compiled elsewhere, perhaps) will run just fine even if ST1 is not installed.