SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the restContinue reading »
I ran into this error message recently and thought I’d describe what the issue was.
I was building a new consolidated development database server for a client – moving away from 10 separate database servers to one (big) VM to run their development workloads.… Read the restContinue reading »
I’d like to think that I’m pretty decent at backup and recovery. I’ve done hundreds of restores in my career in a vast array of scenarios for real-world recovery, data movement, and fixing developers’ mistakes. Today I saw an error I’ve never seen before, so I thought I’d share.… Read the restContinue reading »
Loading data into a DB2 database using the LOAD utility has a lot of ins and outs. If a DBA has spent a lot of time working in a database without referential integrity or check constraints, then they may forget to check for tables in a check-pending state after loading data.… Read the restContinue reading »
I recently ran into a couple of db2look problems for different clients, and thought I’d share them in case someone else runs into them.Continue reading »
When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered.… Read the restContinue reading »
This is a topic I have to look up from time to time, and I always go straight to Serge Rielau’s blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much more.
While he’s already covered the topic in great detail, I thought I’d add my own way of looking at it, and a use case or two for DB2 System views.… Read the restContinue reading »
There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would share. If you do not already have a database connection, you can get:
db2 conenct to SAMPLE DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.… Read the rest Continue reading »