Reputation
3,481
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
4 18 47
Impact
~416k people reached

17h
comment what problems can arise switching database from db2 9.7 to 10.1
The online documentation (ibm.com/support/knowledgecenter/SSEPGG/welcome) will explain what to look for. Are you working with Express-C that you aren't migrating the instance and database? Just curious. Because you could otherwise migrate your instance. Or install a new instance and then migrate the database over other ways.
17h
comment See Full Exception String In Error Message
You can also use db2 ? <errorcode> on the command line to get DB2 to write out some specifics related to the error code. But you have to transform the "negative" codes. Prepend SQL. Make the number positive. Prefix zeros if less than four numbers. And add an N to the end. So in your case it would be db2 ? SQL4302N.
Apr
27
comment Special Characters from DB2 database are getting distorted in Java
Check the codepage and collation. Sometimes what is used on the screen and what is used in the database can be two totally different things and this can lead to strangeness in data on "green screen" vs via JDBC driver. See Ember Crook's blog entry on an example of this: db2commerce.com/2013/03/27/the-basics-of-code-pages-in-db2
Apr
22
comment IBM i Access ODBC driver returning only first letter of column names
Which version of i5/OS are you on? that may be affecting things, as DB2 for i is actually integrated with the OS and only upgraded as the OS is upgraded.
Apr
21
comment non-optimal use of index
Did you REBIND? That recompiles the plan based on the changed stats. You would essentially force a REBIND by dropping and recreating the index. Or you could issue the REBIND command or use the db2rbind utility to rebind your packages and plans. You could also try flushing the plan cache after RUNSTATS and what not too.
Apr
21
comment non-optimal use of index
Never rely on automatic runstats and/or reorgs. They never happen when you want and can affect performance of the system. They should be run during maintenance windows if possible. First REORG the table to clean up the tables and/or indexes (makes them more efficient by placing data next to them). Then run RUNSTATS to gather statistics over the data as it is now organized. Then run REBINDs. This will inform the optimizer of how your data actually looks. Otherwise you are running with old stats and plans and unoptimized tables/indexes.
Apr
21
comment non-optimal use of index
Perhaps that means you are not running REORG's and RUNSTATS often enough?
Apr
17
awarded  Notable Question
Mar
29
awarded  Yearling
Mar
22
comment How do you generate the DDL that created a db2 luw database?
@RobertEJohnson - here is the link for the documentation on db2look. Multiple parameters depending on what you want: ibm.com/support/knowledgecenter/SSEPGG_10.5.0/… Be careful as some of the parameters don't match together or order may matter. See Ember Crooks blog (db2commerce.com) on db2look.
Mar
22
comment How do you generate the DDL that created a db2 luw database?
@MaxVernon - you have the DB2 for z link. OP is asking for LUW.
Mar
22
comment How do you generate the DDL that created a db2 luw database?
There are options on db2look that let you generate those commands if I remember correctly.
Mar
17
comment What does 'quiesce' stand for?
"from creating any external connection through any application" - not exactly true. If you have QUIESCE CONNECT authority assigned to that ID, then it can connect, even if the database is quiesced. Although, in general, that is the intent of quiesce.
Mar
15
comment AS/400 + DB2 to MongoDB?
One option would be to export your data to CSV and then import it to MongoDB. Another would be to use an ETL tool.
Feb
19
revised Transaction Log Backups Serial or Parallel?
added 3 characters in body
Feb
19
awarded  Nice Question
Feb
16
accepted Transaction Log Backups Serial or Parallel?
Feb
5
comment Transaction Log Backups Serial or Parallel?
@MaxVernon - perhaps. But some opinion based questions are valid. I try to ask questions that make sense to ask, rather than just starting flame wars. Plus I have tended to be Accidental/Junior DBA at all of my jobs. First DB2 and now SQL Server. So I don't have a senior to learn from. My only resource is the community. So I think a question like this is fair. It allows myself and other accidental/juniors to learn from it.
Feb
5
asked Transaction Log Backups Serial or Parallel?
Feb
3
comment How to Start DB2 10.5 HADR on the Standby Database
Be aware that LOGRETAIN will retain logs forever. It will not clean them up for you, even if you use AUTO_DEL_REC_OBJ. For this reason, I have avoided LOGRETAIN and gone with DISK. This allows me to specify where I want the archived logs to go to, and to enable auto-pruning through AUTO_DEL_REC_OBJ.