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 →

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 →

DIA8400C A bad page was encountered

Question: The DIA8400C A bad page was encountered message appeared in the db2diag.log file MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad" DIA8400C A bad page was encountered. Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes Obj: {pool:5;obj:5;type:0} Parent={5;5} How can I investigate further ? Answer: From the information provided , the first thing is to check the database object in question. In the example you’ve presented – It’s the TablespaceID = 5 and TableId = 5 . This query will display the database object db2 "select char(tabname,20), char(tabschema,20) from syscat.tables where tableid=5 and tbspaceid=5" Once you’ve identified the object – there are two utilities... Read more →

Check DB2 instance status

How to check for the DB2 Instance Status? There are multiple methods of checking the DB2 instance status. The method is usually dependant on the requirements. These are some examples of different situations where the DB2 instance status is required Server reboot – Has the DB2 instance started OK?Maybe auto start failed or an underlying disk issue. Connection troubleshooting – Is the DB2 instance available? Disaster Recovery – On a site failover , has the DB2 instance started OK? Typically a DBA may go beyond checking just the DB2 instance status. They may want to check database connections , tablespaces... Read more →

Top 10 most active posts for DBA-DB2.com in 2015

2015 has been a great year. I’ve enjoyed very much working as a DB2 DBA . My main focus this year has been on performance and tuning. I’ve worked on some large scaling projects , dealing with very large transactional growth. There's also been an increase in security audit projects I’ve tried to post regularly on sqlserver-dba.com and dba-db2.com. Page views have increased steadily over the year. I’d like to thank the readers for some excellent feedback and questions. If you’d like to ask any questions , please contact me. The 10 most active posts this year on DBA-DB2.com are:... Read more →