SQL0670N - The row length of the table exceeded a limit of "32677" bytes

Question : The row length of the table exceeded a limit of "32677" bytes. can you give me some advice on how to deal with this problem? the error code associated with the message is SQLCODE=-670, SQLSTATE=54010 I'm using DB2 9.5.0.3 Answer: Without knowing any extra details , I would guess you are attempting to add a column or extend an existing column which is causing the size to be greater than 32768 bytes. The way you approach the problem will depend on what you are attempting to do. For example, if you are executing a create\alter on a table,... Read more →

Real world experience is the DBA king

Following on from 3 ways to identify an expert , I got into a conversation with a colleague and we discussed whether it is possible to be an “expert” but without real world experience. My argument is that real world experience is the real definition of an expert What is the right amount of real- world experience that makes you a database expert? It depends on the type of experience, but I would say a DBA with 10 – 15 years full time exposure, can legitimately start to be classed an expert. The key is on the type of experience... Read more →

How to add Virtual IP address to existing Tivoli Storage Automation via db2haicu

Question: I have a Failover solution set up for Shared Disk Storage using Tivoli Storage Automation (TSA). DB2 instances & mount points are set up in the correct resource groups and failing over to another node in the same cluster with success. The one missing piece of the TSA solution is the virtual ip address failover. How can I add a virtual ip that will broadcast the ip address from whichever is the Primary Server? Answer: If you already have a TSA set up , then setting up a Virtual IP address can be configured via DB2 using the db2haicu... Read more →

10 most popular posts for dba-db2.com for 2015

I've just published 10 most popular sqlserver-dba posts for 2015 , so I thought I'd publish 10 most popular posts for dba-db2.com for 2015 I've been meaning to publish the 10 most popular posts for dba-db2.com for 2015 since the start of 2016. But I've had a lot of work and being writing about other topics. Mainly I write dba-db2.com posts to document problems and to help me understand what I'm working on. One of the observations about this list is that I also revisit these posts regularly. I use the posts as reference and also edit based on feedback.... Read more →

How to view harvested user defined storage resources for TSAMP

When troubleshooting a db2haicu adding a mountpoint operation , it was necessary to review the resources harvested. This is the first step in trying to figure how TSAMP is viewing the online resources To view the online user defined storage resources harvested use this command: lsrsrc -Ab IBM.AgFileSystem When reviewing the output you'll notice the mount point information. This information is harvested by default from the /etc/fstab details . If a new resource has been added to the system and you want to refresh the IBM.AgFileSystem output use the force method to refresh the list refrsrc IBM.Disk The alternative to... Read more →