ponedeljek, 11. september 2017

Sort on open/save dialog in Google Chrome on Ubuntu

If you want the sort to work so that the directories are displayed first you have to do the following:
- sudo apt install dconf-editor
- dconf-editor
- go to org - gtk - settings and set sort-directories-first to true

You can also set sort-column and sort-order there.

torek, 21. marec 2017

XFCE4 reset panels

xfce4-panel --quit ; pkill xfconfd ; rm -rf ~/.config/xfce4/panel ~/.config/xfce4/xfconf/xfce-perchannel-xml/xfce4-panel.xml ; xfce4-panel;

ponedeljek, 13. februar 2017

DB2 Terminate LOAD

What tables are in Load Pending State:
SELECT TABSCHEMA, TABNAME, LOAD_STATUS FROM SYSIBMADM.ADMINTABINFO WHERE LOAD_STATUS = 'PENDING'
How to get TABSCHEMA.TABNAME table out of Load Pending State:
db2 "LOAD FROM /dev/null OF DEL TERMINATE INTO TABSCHEMA.TABNAME NONRECOVERABLE"
db2 "SET INTEGRITY FOR TABSCHEMA.TABNAME IMMEDIATE CHECKED"

četrtek, 09. februar 2017

DB2 LOAD from CURSOR

You can do a LOAD from CURSOR in command line. Example is taken from Fast and easy data movement using DB2's LOAD FROM CURSOR feature:

db2 "DECLARE C1 CURSOR FOR SELECT * FROM FECHNER.SALES"
db2 "LOAD FROM C1 OF CURSOR MESSAGES C:\load_sales_tmp.msg INSERT INTO FECHNER.SALES_TMP NONRECOVERABLE"

ponedeljek, 06. februar 2017

How to tell Maven to disregard SSL errors (and trusting all certs)?

Answer at StackOverflow and copied here if it gets removed:
You can disable SSL certificate checking by adding one or more of these command line parameters:

-Dmaven.wagon.http.ssl.insecure=true - enable use of relaxed SSL check for user generated certificates.
-Dmaven.wagon.http.ssl.allowall=true - enable match of the server's X.509 certificate with hostname. If disabled, a browser like check will be used.
-Dmaven.wagon.http.ssl.ignore.validity.dates=true - ignore issues with certificate dates.

Official documentation: http://maven.apache.org/wagon/wagon-providers/wagon-http/

Here's the oneliner for an easy copy-and-paste:
-Dmaven.wagon.http.ssl.insecure=true -Dmaven.wagon.http.ssl.allowall=true -Dmaven.wagon.http.ssl.ignore.validity.dates=true