DBplatz Blog Support

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

postgresql

PostgreSQL - default superuser privileges were removed.

Last week a colleague contacted me about a PostgreSQL installation where the privileges of the postgres user suddenly "disappeared". I searched around a bit and found this really useful article in stackoverflow. However, his server was Windows, so I tried and replicated this issue on a Windows 2019 server. First

databases

SQL Server - SSMS exiting immediately after showing the splash screen.

Last year, I installed SQL Server Management Studio 18.0 on a server tested the connection to the SQL Instance and everything looked OK. SSMS was exiting immediately after showing the splash screen. But months later, I tried again and SSMS was not starting. To troubleshoot this, let's cd to

sqlserver

SQL Server - Could not find the Database Engine Startup handle.

A few weeks ago I had the task to install SQL Server 2014 Express Edition and SQL Server Management Studio (SSMS) 18.4 and what it was going to be no more than an hour ended in a 16 hours change. Actually, I did install successfully one of the servers,

arm

Installing Grafana on Raspberry OS.

In a previous post we’ve installed Prometheus on Raspberry, and this time we are installing Grafana on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB. So, let’s start with downloading the software first from

homelab

Installing Prometheus on Raspberry OS.

In a previous post we’ve installed Prometheus on Ubuntu, and this time we are installing Prometheus on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB. So, let’s start with downloading the software first from

ubuntu

Installing Prometheus 2.22.1 on Ubuntu Server 20.04

What is Prometheus?Prometheus is an open-source systems monitoring and alerting toolkit originally built at SoundCloud. Since its inception in 2012, many companies and organizations have adopted Prometheus, and the project has a very active developer and user community. To download the software we click here, select our Operating System:

mariadb

How To Install MariaDB 10.5.8 on Centos 8.2

In this article we are installing MariaDB 10.5.8 Community Edition on Centos 8.2. MariaDB is free and open source softwareThe MariaDB database server is published as free and open source software under the General Public License version 2. You can download and use it as much as

worldcommunitygrid

We’ve joined the World Community Grid and you can join too!

A few weeks ago I came across a really interesting blog post while searching for articles for dbplatz.com. raspberrypi.org/blog/ibm-world-community-grid/ And actually it was pretty good timing as weeks before we bought a Raspberry Pi 4B 8GB (Ubuntu 20.4 64-bit) as our pre-production server As we

db2

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. [email protected]:~ $ 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

cockroachdb

Install CockroachDB on Ubuntu 16.04.

Every time I read an article about "10 Reasons You Should Start a Blog", there is always something about "learning new skills", and it sounds obvious but it's true. Lately, I'm always thinking about things to write about which makes me search more ... until I find something that gets my

db2

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 EditionSo a few days ago I tried to start my Db2 instance for testing

mssql

How to install SQL Server Management Studio (SSMS).

In this post, we will install SQL Server Management Studio on a Windows Server 2019. We've downloaded the installation from here SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.So once the installation file is on the

mssql

How to install SQL Server 2019 on Windows Server 2019.

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. Photo by Tadas Sar / Unsplash I've download SQL Server Developer Edition from here. However, now you don't get the ISO or installation files anymore, what you get is a downloader. So, If the target server does

db2

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

db2

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