Joachim Klassen

#Db2 Consultant and Trainer.
Opinions are my own.

[Joachim Klassen @DB2Joe]

@Db2_Whisperer @globomike Is db2adult the version for grown up #Db2 DBAs? 😎 #IDUGDb2

[Joachim Klassen @DB2Joe]

@ember_crooks Just joined this great Community! thx for the hint @ember_crooks

[Joachim Klassen @DB2Joe]

@ARSDB2 Never touch a running system :-)

[Joachim Klassen @DB2Joe]

@ARSDB2 Can't beat the age - but look how long V8 was running 😱

[Joachim Klassen @DB2Joe]

@erwin_hattingh @LuizSilvaDBA Nice ideas - but not feasible for the customer

[Joachim Klassen @DB2Joe]

Hey #Db2 Cracks out in the wild - need your ideas! 1/4
How to generate an UTC Timestamp in a column during a LOAD?

So far I tried this (#Db2 10.5. and 11.1)
- Defining the column as NOT NULL WITH DEFAULT CURRENT TIMESTAMP - CURRENT TIMEZONE --> gives an SQL0104 Syntax error

[Joachim Klassen @DB2Joe]

@ARSDB2 Cool function - but both ideas result in SQL0548N

[Joachim Klassen @DB2Joe]

@InfoDschanki Load from DEL or ASC

[Joachim Klassen @DB2Joe]

4/4
- A BEFORE Trigger is not an option as LOAD does not fire triggers

Any ideas?
Pls. RT
@globomike @InfoDschanki @maggus_f @ember_crooks @ARSDB2 @MKrafick @maheitka @The_Data_Doctor @erwin_hattingh @raghuontech @mnicolaIBM

[Joachim Klassen @DB2Joe]

3/4
- Defining the column as GENERATED ALWAYS AS ( TIMESTAMP(GET_UNIQUE)) --> does not work as non-deterministic functions are not allowed in a GENERATED clause

[Michael Tiefenbacher @globomike]

26. #DeDUG - the German #Db2 User Group - will be a virtual event on Friday 17.07.2020 - check it out https://t.co/nJAh7pKkd3 #ibmchampion #idug

[Joachim Klassen @DB2Joe]

Yes - #IBMCHAMPION Gifts arrived. My collection of mugs and bottles grows. Thanks to #IBM and @notesgirl

[Joachim Klassen @DB2Joe]

@globomike @erwin_hattingh @ember_crooks @RomanufaKeri @jrockwood @JanttuLindroos @IBM_Paul_Bird @ARSDB2 @The_Data_Doctor @MKrafick @data_henrik @notesgirl @roecken @db2fred 5 former jobs
- newspaper carrier
- working at skate rental counter
- delivery van driver
- COBOL programmer
- DBA
- Consultant
uh - makes six 🤔

[Joachim Klassen @DB2Joe]

YES! Being selected as an #ibmchampion for the third time in a row! Thanks to @notesgirl, #DeDUG and #IDUGdb2 @IBMChampions #ibmdb2

[Joachim Klassen @DB2Joe]

@InfoDschanki @DeDUGDb2 @globomike @ARSDB2 @data_henrik Have fun! I'm not able to be at #DeDUGDb2 today. Cu all next time

[Joachim Klassen @DB2Joe]

#IDUGDb2 #Db2 Expert Panel is about to begin

[Joachim Klassen @DB2Joe]

Heavy Rain this morning in #Rotterdam - streets are flooded 😎 #IDUGDb2 is about to begin

[Joachim Klassen @DB2Joe]

On my way to #Db2 #IDUG2019 - weather in Amsterdam mostly cloudy

[Joachim Klassen @DB2Joe]

@erwin_hattingh Its me @Db2Jerry 🐀