db2 11.1 backup restore

$ db2 backup db demo

$ db2 restore db demo

SQL2539W  The specified name of the backup image to restore is the same as the
name of the target database.  Restoring to an existing database that is the
same as the backup image database will cause the current database to be
overwritten by the backup version.
Do you want to continue ? (y/n) y
 

Debian 9 1c Failed to load module “canberra-gtk-module”

Пакет libcanberra является реализацией спецификаций звуковых тем XDG Sound Theme and Name Specifications, используемых на свободных рабочих столах, таких как GNOME, для воспроизведения звуковых сигналов в случае возникновения событий.

1cv8[2124]: Failed to load module "canberra-gtk-module"
sudo apt-get install libcanberra-gtk3-module
sudo apt-get install libcanberra-gtk-module:i386

Failed to load module “canberra-gtk-module”


sudo ln -s /usr/lib/x86_64-linux-gnu/gtk-3.0/modules/libcanberra-gtk3-module.so /usr/lib/x86_64-linux-gnu/gtk-2.0/modules/libcanberra-gtk-module.so

  $ nano start_1c.sh

 LD_LIBRARY_PATH=/usr/lib/x86_64-linux-gnu/gtk-3.0/modules:$LD_LIBRARY_PATH /opt/1C/v8.3/x86_64/1cestart

 $ ./start_1c.sh

(1cestart:7163): Gtk-WARNING **: GTK+ module libcanberra-gtk-module.so cannot be loaded.
GTK+ 2.x symbols detected. Using GTK+ 2.x and GTK+ 3 in the same process is not supported.
Gtk-Message: Failed to load module "canberra-gtk-module"

Debian 9 Gnome VM takes two minutes to shutdown, why?

Debian 9 Gnome VM takes two minutes to shutdown, why?
[SOLVED] Can not shut down or reboot in GNOME 3.8.4/Jessie

Настройка kernel parameters db2

Требования к параметрам ядра (Linux)
Modifying kernel parameters (Linux)

$ ipcs -l

------ Messages Limits --------
max queues system wide = 32000    // MSGMNI
max size of message (bytes) = 8192    // MSGMAX
default max size of queue (bytes) = 16384    // MSGMNB

------ Shared Memory Limits --------
max number of segments = 4096            // SHMMNI
max seg size (kbytes) = 18014398509465599    // SHMMAX
max total shared memory (kbytes) = 18014398442373116    // SHMALL
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 32000        // SEMMNI
max semaphores per array = 32000    // SEMMSL
max semaphores system wide = 1024000000 // SEMMNS
max ops per semop call = 500        // SEMOPM
semaphore max value = 32767


Требования к параметрам ядра (Linux)
В версии db2 11.1 параметры ядра настраиваются автоматически,
однако  целесообразно настроить:
vm.swappiness=0 

ниже относится к db2 9.7
$ sudo nano /etc/sysctl.conf

#Example for a computer with 16GB of RAM:
kernel.shmmni=4096
kernel.shmmax=17179869184
kernel.shmall=8208903
#kernel.sem=<SEMMSL> <SEMMNS> <SEMOPM> <SEMMNI>
kernel.sem=32000 1024000000 500 32000
kernel.msgmni=16384
kernel.msgmax=65536
kernel.msgmnb=65536
vm.swappiness=0


$ sudo sysctl -p

Фиксим rdpKeyboard.c

setxkbmap -layout "us,ru(winkeys)" -model "pc105" -option "grp:alt_shift_toggle"

keyboard layout set only to "us" after reconnect session instead "us,ru" 

$ cd /home/user/xorgxrdp/xrdpkeyb

$ nano /home/user/xorgxrdp/xrdpkeyb/rdpKeyboard.c

Ищем set.model

Находим rdpkeybControl(DeviceIntPtr device, int what) 

/******************************************************************************/
static int
rdpkeybControl(DeviceIntPtr device, int what)
{
    KeySymsRec keySyms;
    CARD8 modMap[MAP_LENGTH];
    DevicePtr pDev;
    XkbRMLVOSet set;
    rdpPtr dev;

    LLOGLN(0, ("rdpkeybControl: what %d", what));
    pDev = (DevicePtr)device;

    switch (what)
    {
        case DEVICE_INIT:
            rdpkeybDeviceInit(device, &keySyms, modMap);
            memset(&set, 0, sizeof(set));
            set.rules = g_base_str;
            // BEGIN-FIX
            //set.model = g_pc104_str;
            //set.layout = g_us_str;
            //set.variant = g_empty_str;
            //set.options = g_empty_str;
            set.model = "pc105";
            set.layout = "us,ru";
            set.variant = "";
            set.options = "grp:alt_shift_toggle";
            // END-FIX

Находим rdpLoadLayout(rdpKeyboard *keyboard, struct xrdp_client_info *client_info)

/******************************************************************************/
static int
rdpLoadLayout(rdpKeyboard *keyboard, struct xrdp_client_info *client_info)
{
    XkbRMLVOSet set;

    int keylayout = client_info->keylayout;

    LLOGLN(0, ("rdpLoadLayout: keylayout 0x%8.8x variant %s display %s",
               keylayout, client_info->variant, display));
    memset(&set, 0, sizeof(set));
    set.rules = g_base_str;
    // BEGIN-FIX
    //set.model = g_pc104_str;
    //set.layout = g_us_str;
    //set.variant = g_empty_str;
    //set.options = g_empty_str;
    set.model = "pc105";
    set.layout = "us,ru";
    set.variant = "";
    set.options = "grp:alt_shift_toggle";
    // END-FIX

Debian 9 gnome

Что бы не забыть, какие расширения включить:

Компиляция remmina на Debian 9

Quick and dirty guide for compiling remmina on Debian 9
For users with a distro that supports Snap packages, including Ubuntu and debian
Remmina в Debian 9
$ sudo apt install snapd
$ snap find remmina
Name     Version         Developer  Notes  Summary
remmina  1.2.0-rcgit-20  remmina    -      The GTK+ Remote Desktop Client
До перезагрузки долго висела по sudo snap install remmina --edge
$ sudo reboot
$ sudo snap install remmina --edge
Не запоминает настройки.
-------------------------------------------------------------------------------------------
$ sudo apt purge libssl-dev
$ sudo apt install build-essential git-core libssh-dev cmake libx11-dev libxext-dev libxinerama-dev libxdamage-dev libxv-dev libxkbfile-dev libasound2-dev libcups2-dev libxml2 libxml2-dev libxrandr-dev libgstreamer1.0-dev libgstreamer-plugins-base1.0-dev libxi-dev libavutil-dev libavcodec-dev libxtst-dev libgtk-3-dev libgcrypt11-dev libpulse-dev libvte-2.91-dev libxkbfile-dev libtelepathy-glib-dev libjpeg-dev libgnutls28-dev libgnome-keyring-dev libavahi-ui-gtk3-dev libvncserver-dev libappindicator3-dev intltool libsecret-1-dev libwebkit2gtk-4.0-dev libsystemd-dev -y
$ sudo apt purge "remmina*" "libfreerdp*" "libwinpr*" "freerdp*"
$ mkdir ~/remmina_devel
$ cd ~/remmina_devel
$ git clone https://github.com/FreeRDP/FreeRDP.git
$ cd FreeRDP
$ cmake -DCMAKE_BUILD_TYPE=Debug -DWITH_SSE2=ON -DWITH_CUPS=on -DWITH_PULSE=on -DCMAKE_INSTALL_PREFIX:PATH=/opt/remmina_devel/freerdp .
$ make && sudo make install
$ echo /opt/remmina_devel/freerdp/lib | sudo tee /etc/ld.so.conf.d/freerdp_devel.conf > /dev/null
$ sudo ldconfig

$ sudo ln -s /opt/remmina_devel/freerdp/bin/xfreerdp /usr/local/bin/
Проверка:
!!!$ xfreerdp +clipboard /sound:rate:44100,channel:2 /v:192.168.1.162 /u:user
$ cd ~/remmina_devel
$ git clone https://github.com/FreeRDP/Remmina.git -b next
$ cd Remmina
$ cmake -DCMAKE_BUILD_TYPE=Debug -DCMAKE_INSTALL_PREFIX:PATH=/opt/remmina_devel/remmina -DCMAKE_PREFIX_PATH=/opt/remmina_devel/freerdp --build=build .
$ make && sudo make install
$ sudo ln -s /opt/remmina_devel/remmina/bin/remmina /usr/local/bin/