How to copy an entire schema between AIX and Windows:
A few months ago I had the need to setup a standalone environment in my laptop in order to have independency while testing and develop a new system architecture.
The problem was the dB2 schema that I needed was on a AIX machine. So I had to copy it all and move to my Windows machine.
Here’s the step-by-step of how to do it:
On your AIX machine, export data of schema MY_SCHEMA
db2move DBNAME export -sn MY_SCHEMAThe output of this produced is:
EXPORT.out-Contains a summary of the completed action (ASCII).
db2move.lst -Contains a list of original table names, their corresponding PC/IXF file names, and message file names (ASCII).
tabn.ixf -Contains exported data from a user table, identified by n (binary).
tabn.msg -Contains messages about the requested action against a user table, identified by n (ASCII).
tabna.nnn -Contains exported large object (LOB) data for a user table, identified by n. The file name extension is a number ranging from 001 to 999, and a is an alphabetic character.These LOB files, which are created only if the table being exported contains LOB data, are placed in the LOB path directories system.msg
Extracts all DDL statements for database objects (-e) for a specific schema (-z). Also generates tablespaces, databsse partition groups, and bufferpools (-l)
A few days ago we were implementing HMAC SHA-256 algorithm in java accordingly to RFC 2104. At a certain point the question was: “Is that implementation correct?” How could we be sure of it? The following openssl command cleared out the doubts.
echo -n [SAMPLE_INPUT_TEXT] | openssl dgst -sha256 -mac hmac -macopt hexkey:[HEXA_KEY] Putting some value on it we got:
echo -n "TEXT_INPUT_FOR_HMAC" | openssl dgst -sha256 -mac hmac -macopt hexkey:CBA54DBA951FB57F905AC8696BDE3A77D8A525DB3CFC61787F9C13A78C78CBB58D12F7C6
That way we were confident to promote the software into production
First install WSL with a distro you like.
Then follow up this great article explaining step-by-step how to setup the terminator terminal in windows 10.
Last but not the least install tmux on the top of it.
Here’s a snapshot of terminator with tmux under windows 10:
1. CTRL + SHIFT + E : Open another instance adjacent to the one you have, but withou openning a new window. Usefull when you wanna send several commands and hava a one galnce view to all.
2. CTRL + SHIFT + T : Open another instance in a new tab of the same window.
3. CTRL + SHIFT + W : Closes an instance.
4. ALT + A : Broadcast to all tabs of terminator
5. ALT + G : Broadcast to the group of the selected tab
6. ALT + O : Turn off broadcast
7. SUPER + G : Group all windows
8. SHIFT + SUPER + G : Ungroup all windows
9. CTRL + SHIFT + X : Toggle between one tab terminal and all tabs.
10. ALT + F2 : Run a command
Though one thing terminator lacks is how to open an new terminator window while establishing a new ssh connection to a remote host. You can indeed, achieve that with profiles but if you have dozens of remote servers, it can become hard to manage.
In this case consider using tmux.