Skip to main content

IT Blogger

Search This Blog

IBM DB2 Drop Schema

on January 06, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

$ db2 "CALL SYSPROC.ADMIN_DROP_SCHEMA('schema_name', NULL, 'ERRORSCHEMA', 'ERRORTABLE')"

Source :

https://dba.stackexchange.com/questions/14526/drop-schema-in-db2

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Android SDK Manager with Command line Tools Only (on Linux Ubuntu)

In this case, I use Linux Ubuntu as current Operating System by using WSL2 (Windows Subsystem Linux v2) with Windows Terminal. Follow this guide, according to my experience today. Open https://developer.android.com/studio Move to part of "Command line tools only". Download as Platform Linux and save as on /home/ubuntu/Downloads/Programs Create new folder. $ sudo mkdir -p /home/ubuntu/Downloads/Programs/android-sdk $ sudo mkdir -p /home/ubuntu/Downloads/Programs/android-sdk/cmdline-tools If file download has finished. Move file to /home/ubuntu/Downloads/Programs/android-sdk/cmdline-tools $ sudo mv -r /home/ubuntu/Downloads/Programs/commandlinetools-linux-8092744_latest.zip /home/ubuntu/Downloads/Programs/android-sdk/cmdline-tools/ Extract the file. $ unzip -q commandlinetools-linux-8092744_latest.zip It will contains folder name Rename folder to "latest". $ sudo mv cmdline-tools latest Then $ cd /home/ubuntu/Downloads/Programs/android-sdk/cmdline-tools/latest/bin S...

Install Multiple JDK on Linux Ubuntu

Hi, in this case I would like to share a little bit knowledge about multiple installation of JDK based on linux os. For example, I use Linux Ubuntu OS v-18.04 LTS or you can use another linux version. Download Oracle JDK 7 (archive) , Oracle JDK 8 (archive) , Oracle JDK 8 (latest) , Oracle JDK 11 and Oracle JDK 17 . To see completely Oracle JDK archives, click here . If you want to get the latest version of Oracle JDK, click here . In your path ~/Downloads you will have 4 files of JDK. jdk-17_linux-x64_bin.tar.gz jdk-11.0.14_linux-x64_bin.tar.gz jdk-8u321-linux-x64.tar.gz jdk-7u80-linux-x64.tar.gz Create new folder by following this command. $ sudo mkdir -p /usr/lib/jvm Next, you can move or copy-paste those files into /usr/lib/jvm $ sudo cp -r jdk-17_linux-x64_bin.tar.gz /usr/lib/jvm $ sudo cp -r jdk-11.0.14_linux-x64_bin.tar.gz /usr/lib/jvm $ sudo cp -r jdk-8u321-linux-x64.tar.gz /usr/lib/jvm $ sudo cp -r jdk-7u80-linux-x64.tar.gz /usr/lib/jvm Now, move to /u...

IBM DB2 Increase LogFileSize for Better Transaction Process

$ db2 "CONNECT TO DBPUBLIC" $ db2 "SET SCHEMA APPCORE" $ db2 "GET DB CFG" $ db2 "TERMINATE" $ db2 "FORCE APPLICATIONS ALL" $ db2 "UPDATE DB CFG FOR DBPUBLIC USING LOGFILSIZ 24576" $ db2 "FORCE APPLICATIONS ALL" $ db2 "CONNECT TO DBPUBLIC" $ db2 "SET SCHEMA APPCORE" Source : https://stackoverflow.com/questions/2599419/db2-transaction-log-is-full-how-to-flush-clear-it

Powered by Blogger

Authorized © Blogger