How to list Linux non-system local users

Question: I'd like to capture Linux local users who are not system users and also return the server name and group associated with the local user. What statement can I execute to create this list ? Answer: Linux offers a number of different methods to report on local users and other meta data associated with the user such as groups and permissions . This code snippet will return non-system users and exclude "user1" and "user2". I've added that predicate to give you some flexibility around how you construct the code. Based on the details - the hostname and the group... Read more →

DB2 LUW 11.1 product documentation available in PDF format

For a period of time the DB2 LUW 11.1 documentation was only available online. The good news is it's now available in PDF format and can be downloaded to read through . To download the documentation visit the Db2 Version 11.1 for Linux, UNIX, and Windows English Manuals Read more →

How to create a Date Series in DB2

Question: How can I create a Date Series in DB2 LUW. e.g. 01-01-2017 to 30-01-2017 . ? Answer: There are a number of different ways to create a date series in DB2 LUW.One way is the example used below, which lists the dates from 1st January 2017 - 30 January 2017. : db2 "with tempdateseries (date) as ( select date('01.01.2017') as date from sysibm.sysdummy1 union all select date + 1 day from tempdateseries where date < date('30.01.2017') ) select * from tempdateseries" This method will give you an output example such as : 01/01/2017 02/01/2017 03/01/2017 04/01/2017 05/01/2017 06/01/2017 07/01/2017... Read more →

How to check DB2 LUW load status

Question: How can I check load status in DB2 LUW? Answer: Checking the DB2 LUW load status is achieved by using the load query command. The best way to explain is by demonstrating with a simple example. The DB2 LUW command is used to load data into a DB2 LUW table. The data can be stored in many different forms – including named pipe and tape Starting the load process connect to mydb; create table table2 like table1; load from somedata.del of del insert into table2; While the load process is in flight , create another connection and view the... Read more →

Urban Code Deployment for database deployments feedback required

In my experience of database deployments there are a number of challenges : Critical data is changed incrementally – meaning you’re normally making changes to critical data , as opposed to rebuilding the data from nothing. Order of changes – it is imperative the scripts are in order. CREATE TABLE , add data One execution – data changes – only make once Rollback – safeguard against data integrity corruption I’ve started reviewing IBM Urban Code deployment , with a view to utilising in Database changes. It’s to support a very agile environment . What’s your experience? Skills required for rapid... Read more →