List of Contributions

Erwin Hattingh

Triodos Bank

Contact Details

Triodos Bank

My Content

1 to 20 of 21 total

RE: db2 next

Posted By Erwin Hattingh Fri July 09, 2021 02:04 AM
Found In Egroup: Db2 \ view thread
How is this : 5 webinar sessions : "Db2 11.5.6 Webinar Series Schedule (July 7 - July 22)" https://www.ibm.com/events/event/pages/ibm/0ue4vrmb/1581037797007001PJAd.html Sign up, but hurry (you missed session #1 already) Whats new with Db2 11.5.6 - This session will cover the over-all updates ...

RE: DB2 WH: Unable to restore an offline backup

Posted By Erwin Hattingh Tue September 29, 2020 03:19 AM
Found In Egroup: Cloud Pak for Data \ view thread
Looks like a comparable problem, as submitted in the Db2 IDEAS AHA! portal : 3 jan 2019 "Allow offline backup to automatically force all Allow offline utilities such as backup, restore, rollforward to auconnections" https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-265 (which has status: " plannend ...

RE: Optim support for Db2 v11.5 : When ?

Posted By Erwin Hattingh Tue August 11, 2020 02:18 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Richard, thanks for the update info and link. For what I heard, we patched with iFix 023-A a few weeks ago, to let Optim "tolerate" Db2 v11.5 :-) regards, Erwin ------------------------------ Erwin Hattingh Systems Engineer / Db2 DBA Triodos Bank ------------------------------

RE: Db2 BETA code connect with wrong user and wrong password possible

Posted By Erwin Hattingh Thu April 30, 2020 02:39 AM
Found In Egroup: Db2 \ view thread
very convenient , lol. My oh my Guess there is a new setting for DB2AUTH registry variable ..... :-) db2set DB2AUTH=WHOCARES --------------------------- Erwin Hattingh Systems Engineer / Db2 DBA ------------------------------

RE: Query Archives without DBVisualizer

Posted By Erwin Hattingh Thu March 26, 2020 03:30 AM
Found In Egroup: InfoSphere Optim \ view thread
Not sure if I understand the question / thread correctly, but DBVisualizer can view LOBs in their tool ; just do a normal select (that can include LOB fields) , and for a record, double click on the LOB field, and it will 'try' and make it readable. Also, when f.i. exporting the full result set to an ...

RE: Problem to access a databases after migration to 11.5

Posted By Erwin Hattingh Fri March 20, 2020 03:39 AM
Found In Egroup: Db2 \ view thread
Hi Andres , all is well that ends well. Good to hear your problem was solved ! Scary that things like this can happen at all, with some configuration mismatch in Db2 instance GID (or UID) and a 'centralised' Identity Access Management software solution to integrate Unix/Linux servers with Active ...

RE: IBM Passport Advantage refusing access to licensed DB2

Posted By Erwin Hattingh Fri February 28, 2020 02:52 AM
Found In Egroup: Db2 \ view thread
In my humble opinion "IBM Passport Advantage" should have been called "IBM Passport Challenge" , especially now with Db2's new licensing model / change from PVU to VPC and f.i. customers on Db2 v11.1 wanting / being forced to upgrade to v11.5. Somewhere in between that process, on the Passport portal ...

Db2 11.5 GA - "Special Build 39711 for 11.5.0.0", Security APARs (Release Date 2020/02/08)

Posted By Erwin Hattingh Fri February 21, 2020 08:21 AM
Found In Egroup: Db2 \ view thread
There is a Special Build 39711 for DB2 11.5.0 Fix Pack 0 (V11.5 GA) , Release Date 2020/02/08 (it's the second SB for V11.5 GA : previous Special Build 39398 for DB2 11.5.0 Fix Pack 0 was Released 2019/11/12) Sadly, so far, only the GA version (v.11.5.0.0) is available (through Passport Advantage) ...

RE: Optim Licensing

Posted By Erwin Hattingh Fri February 14, 2020 07:11 AM
Found In Library: InfoSphere Optim
#InfoSphereOptim #Optim

RE: Optim Licensing

Posted By Erwin Hattingh Fri February 14, 2020 07:11 AM
Found In Egroup: InfoSphere Optim \ view thread
I have an official "Optim Solutions Terabyte Compliance Guide.pdf" (from 2013) that we received from IBM in June 2017 around the time we purchased Optim TDM . As they then stated ". It's for DB2 z/OS, but might 'translate' nicely to LUW" see attachement. Problem in our case with Optim TDM, for Db2 ...

Db2 v11.5 Licensing - db2licm : number of processor cores entitlements

Posted By Erwin Hattingh Fri February 07, 2020 07:49 AM
Found In Egroup: Db2 \ view thread
Starting Db2 v11.5 , licensing tool db2licm has the option "-m" , to lower processor core limit ( see https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002451.html ) -m product-identifier num-cores "Updates the number of cores entitlements that the customer ...

RE: Is this a bug? (GROUP BY CUBE)

Posted By Erwin Hattingh Tue January 21, 2020 04:52 AM
Found In Egroup: Db2 \ view thread
Just a quick search (without looking for your specific usecase) with 'INCORRECT RESULTS' shows these APAR's : ( https://www.ibm.com/support/home/search-results/P849948M05373L86/DB2_for_Linux,_UNIX_and_Windows?sortby=-dcdate&filter=DC.Type_avl:CT748&prod=G0&noredir=true ) IT29981: DB2 MAY RETURN ...

RE: How can I export DB2 schema from AS400 and import into Windows?

Posted By Erwin Hattingh Fri January 17, 2020 03:30 AM
Found In Egroup: Db2 \ view thread
you only want the dabase schema (and not the data) ? Have you tried "db2look" ? https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002051.html see this page (for Db2 v11.1) "Mimicking databases using db2look" https://www.ibm.com/support/knowledgecenter ...

RE: Could Apar fix list be accurate ?

Posted By Erwin Hattingh Tue January 14, 2020 02:20 AM
Found In Egroup: Db2 \ view thread
I agree, sure will make life easier for us. it can be annoying, when checking the fixed/included APAR's in a Db2 Modpack/FixPack, the APAR info / page itself isn't always updated ... I do know however, it can be tough for Db2 L2 support / development, while they are (still) working on the APAR's (or ...

RE: Optim support for Db2 v11.5 : When ?

Posted By Erwin Hattingh Mon January 13, 2020 03:47 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Peter, Our Optim TDM software was/is purchased and is under maintenance, with an including Db2 license file for the Optim Directory (meta databases) itself. Please be aware that upcoming Optim's new version, that will support Db2 v11.5, also is shipped with (or customers can get it through IBM's ...

RE: Optim support for Db2 v11.5 : When ?

Posted By Erwin Hattingh Thu January 09, 2020 08:28 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Peter, thanks for the update. Right now we are running Optim v11.3.0.7 with source/targets Db2 v11.1.3.3 Because of Db2 licensing (PVU versus VPC license) and Costs issues, IBM more or less is enforcing us to upgrade from Db2 v11.1 to v11.5 , and this within 3 months. Before that can even happen, ...

RE: Simple bash script to monitor server and db luw - light weight

Posted By Erwin Hattingh Thu January 09, 2020 03:16 AM
Found In Egroup: Db2 \ view thread
Hi Rob, looks very useful, thanks ------------------------------ Erwin Hattingh Systems Engineer / Db2 DBA Triodos Bank ------------------------------

Optim support for Db2 v11.5 : When ?

Posted By Erwin Hattingh Fri January 03, 2020 06:42 AM
Found In Egroup: InfoSphere Optim \ view thread
Optim Test Data Management v11.3 (Optim v11.3.0.7) does NOT support Db2 v11.5 It's even worse: also the latest Fix Pack 8 (released December 2019) does NOT support Db2 11.5 Come on IBM and Optim developers ..... ------------------------------ Erwin Hattingh Systems Engineer / Db2 DBA Triodos ...

Db2 11.5 "GA" versus "Special Build 39398 for 11.5.0.0" : Stabilty ? Security APARs ?

Posted By Erwin Hattingh Fri January 03, 2020 05:53 AM
Found In Egroup: Db2 \ view thread
For planning and testing purposes, I am desperately waiting for the first FixPack for Db2 v 11.5 Sadly, so far, only the GA version (v.11.5.0.0) is available (through Passport Advantage) for on-premise Db2 customers. By coincidence I found out, there is a "Special Build 39398 for DB2 11.5.0 Fix Pack ...

RE: Where can I get Db2 fix pack version 11.1.4.5?

Posted By Erwin Hattingh Tue December 03, 2019 02:55 AM
Found In Egroup: Db2 \ view thread
​Haha... Coincidence or not ... Seems my complaints (initially on twitter, just before this post here started ), did the trick :-) ------------------------------ Erwin Hattingh Systems Engineer / Db2 DBA Triodos Bank ------------------------------