db2 - DBplatz

db2

A collection of 7 posts

IBM Db2 restore redirect

IBM Db2 restore redirect

In the last article we installed IBM Db2 11.5 on Red Hat, and we also created the SAMPLE database using the db2sampl command, so in this article we will see how to use the restore redirect script to move that database to a different location. So let's connect to

Installing IBM Db2 11.5 on Red Hat.

Installing IBM Db2 11.5 on Red Hat.

In this article we are installing IBM Db2 on Red Hat linux. We can download Db2 from here - A free IBM account is required to download Db2 software. Once we've downloaded the software from the IBM website and uploaded to the Red Hat VM. root@redhat:/root> $ ls -lrt

SQL1022C There is not enough memory available to process the command.

SQL1022C There is not enough memory available to process the command.

Last week, I was trying to check the version of my Db2 client on my laptop and I got an unexpected error message. This was odd as my laptop had plenty of memory, so I tried a couple more commands. C:\WINDOWS\system32>db2licm -l Product name: "IBM DB2 Developer-C

SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "106".

SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "106".

A few days ago I had this issue while running a Db2 online backup to TSM. db2inst1@ubusrvdb2:~ $ db2 "backup db SAMPLE online use TSM compress" SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code :"106" so I executed db2 ? SQLXXXX to

SQL1397N The Db2 service failed to logon.

SQL1397N The Db2 service failed to logon.

I always install a free version of Db2 on my laptop so I can play a bit in a really safe environment without breaking the real ones. Db2 Express-c has been replaced by the Db2 Community Edition So a few days ago I tried to start my Db2 instance for

Creating a Db2 v11.5 instance and the sample database.

Creating a Db2 v11.5 instance and the sample database.

In the last post I installed Db2 11.5 on Ubuntu 16.4 and here I'll show how to create a Db2 instance and the SAMPLE database. But first, I'll create the db2inst1 user (Db2 Instance user). # Create the dba group groupadd dba # Create the db2inst1 user and assign it

How to install IBM Db2 Database v11.5 on Ubuntu 16.4.

How to install IBM Db2 Database v11.5 on Ubuntu 16.4.

This is the first blog post of a series to try to install as many databases SQL and NoSQL (#useThemAll) as possible on VMs at home (Lab @ Home) in order to learn more about them. So let's start installing IBM Db2 on Ubuntu using Virtual Box So we go to