Hopefully by now you’re familiar with…
… to determine what version of Java you have installed, but sometimes you may want to know if you’re running a 32 bit or 64 bit version because you get an error like this…
Can't load AMD 64-bit .dll on a IA 32-bit platform
… to find out just run this variation of the command…
java -d64 -version
… if you have a 64 bit version you’ll get typical output. If not, you’ll get an error similar to this…
This Java instance does not support a 64-bit JVM.
Please install the desired version.
If you’ve ever had to do a recursive query in DB2 to get a hierarchy of records, feel free to use this as a starting point…
WITH LINKS (PARENT_ID, CHILD_ID, UPDATED_TS) AS
SELECT ROOT.PARENT_ID, ROOT.CHILD_ID, ROOT.UPDATED_TS
FROM XX.EVENTS ROOT
WHERE ROOT.CHILD_ID = '234ASDFASDF'
SELECT CHILD.PARENT_ID, CHILD.CHILD_ID, CHILD.UPDATED_TS
FROM LINKS PARENT, XX.EVENTS CHILD
WHERE PARENT.PARENT_ID = CHILD.CHILD_ID
SELECT PARENT_ID, CHILD_ID, UPDATED_TS
ORDER BY UPDATED_TS
FOR READ ONLY WITH UR
… yes, newer versions of DB2 have this ability built in but you’re not always using the most recent version are you??
Thanks to this page for pointing me in the right direction.
If you’ve ever had the need to remove the duplicate lines from a long list of entries like so…
… and are looking for this…
You can use the find/replace feature in Notepad++ to do it if you use the regex funcationality. Here’s the find string…
Just replace with a zero length string.
If you’d like to read up on the details I found this tip here