DB2 Installation Steps in Linux Server

-

1:Download the Db2 software

 

Eg : db210.5_linux.tar.gz

 

 2.Unzip the above product using the below command

 

gunzip -d db210.5_linux.tar.gz

 

3.Untar the product

 

db2 -xvf db210.5_linux.tar

 

It will extract the files & create the SETUP Directory .

 

4.In the setup directory,u have to run the following command

 

./db2install

 

It will generate the log file,based on the log file u can verify whether it has executed successfully or not.

 

Comments

Post a Comment

Popular posts from this blog

Difference between DB2 Terminate and Connect Reset

-
db2 Terminate  and  db2 connect Reset  both break the connection to a database. Connect Reset breaks a connection to a database, but does not terminate the back-end process. The Terminate command does both  break the connection to a database and terminate the back-end process. db2 list applications Auth Id Application Name Appl. Handle Application Id DB Name # of Agents ------- -------------- ---------- ------------------------------ -------- ----- S1 db2jcc.exe 1 *LOCAL.DB2.10000 EMP 1 TEST db2jcc.exe 2 *LOCAL.DB2.20000 EMP 1 Now you can use  db2 "force applications all"  This command is used to kill all the applications forcefully at instance level . To force a particular application with application handle 1 db2  "force application(1)"
Read more

Database recovery methods

-
 Backup and recovery Following, there are four utilities supported within Db2 to facilitate backing up and restoring a database: The backup utility The restore utility The roll-forward utility The recover utility   The backup utility: The backup utility is used to create images outside the database that can be used to recover the entire database or a portion of it. If the database is an archive logging enabled database, the backup utility can be executed online with multiple concurrent applications connected to the database. The backup utility uses the utility heap to copy the data from the table spaces to the backup image. The utility heap can be controlled via the database configuration parameter UTIL_HEAP_SZ. The backup utility can write the backup image to storage devices on the database server, to a tape device, or can copy the data directly to the TSM storage devices or another vendor-supplied routine. Execute the BACKUP command to start the backup process. The basic syn...
Read more

Pandas in Python

-
Image
Pandas is built on top of the NumPy package, meaning a lot of the structure of NumPy is used or replicated in Pandas. Data in pandas is often used to feed statistical analysis in SciPy, plotting functions from Matplotlib, and machine learning algorithms in Scikit-learn. Jupyter Notebooks offer a good environment for using pandas to do data exploration and modeling, but pandas can also be used in text editors just as easily.   Install and import We can use 2 methods to install pandas   as below   Conda install pandas   Or   !pip3 install pandas   The “!” at the beginning runs cells as if they were in a terminal.   Alternatively, if you're currently viewing this article in a Jupyter notebook you can run this cell:   To import pandas we usually import it with a shorter name since it's used so much:   Import pandas as pd pd is the alias name for the pandas, so that it'll be easy to use that whenever it's required. Th...
Read more