Concatenate Strings from a Column Into a Single Row

Sometimes there is a need to concatenate strings from a column into a single row. Some databases already provide a solution with the GROUP_CONCAT() aggregate function, such as SQLite and MySQL. In DB2 you can use the XMLAGG() function to Continue reading Concatenate Strings from a Column Into a Single Row

Cannot start DB2 instance after installation on Linux

You just installed DB2 as non-root user on Linux and when you attempt to start your instance with the db2start command, you get the following message: “SQL1220N The database manager shared memory set cannot be allocated.” Depending on which version Continue reading Cannot start DB2 instance after installation on Linux