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 - 1611 days ago
Last viewed on: 21 Jun 2017 (3492 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)

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: 5 years 7 months 14 days 3 hours 41 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: 5 years 7 months 14 days 2 hours 18 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.