Tags » 10-5

Upgrade DB2 ESE from 9.7 to 10.5

# v10.5fp7_aix64_server_t.tar 10.5.0.7 media

# as user db2inst1, make sure no invalid objects exist

db2 connect to shinpbdb
db2 connect to shibordb
db2 connect to shinetdb
db2 "SELECT SUBSTR(OBJECTSCHEMA,1,10) OBJECTSCHEMA,
SUBSTR(OBJECTNAME,1,30) OBJECTNAME, 
SUBSTR(ROUTINENAME, 1,30) ROUTINENAME, 
OBJECTTYPE, INVALIDATE_TIME, 
LAST_REGEN_TIME 
FROM SYSCAT.INVALIDOBJECTS"

db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(NULL, NULL, NULL)"
… 1,239 more words
DB2

What’s in the glass tonight November 13th – a medium-sweet Riesling

Allan Scott Riesling Marlborough 2014 – $

10.5% alc, greening pale straw colour.

Sweet apples, sweet apples, sweet apples…!

Tropical fruit aromas, medium-sweet on palate, crisp citrus bookending the sweetness for a fresh attack and mouth-watering finish. 10 more words