Tag Info

New answers tagged

2

As Tom V's answer notes, db2level is the simplest means of learning the version of a DB2 instance, but there are a couple of issues with it: firstly that one must have shell access to the server, and secondly, one must be careful that the appropriate db2profile environment is sourced when running db2level (it's entirely possible, even common in my ...


2

If you follow this link there are several ways. One of them shows you the architecture. From that page: $ db2level DB21085I Instance "db2inst5" uses "64" bits and DB2 code release "SQL09071" with level identifier "08020107". Informational tokens are "DB2 v9.7.0.1", "s091114", "IP23034", and Fix Pack "1". Product is installed at "/opt/ibm/db2/V9.7".


0

It is logarchive problem pass this command in primary system1. 1. db2 update db cfg for using LOGARCHMETH1 LOGRETAIN It will enable to database for log archiving and keep the logs in the same active log directory. This will also place the db in backup pending state. Take an offline backup. db2 "backup database " Setting up HADR cfg parameters on Primary ...


1

The COMMIT is fairly obvious; it's committing the effects of the prior ALTER TABLE DETACH... statement (and any statements prior to that and the preceding COMMIT/ROLLBACK - transactions are implicitly started in DB2). I assume there's a bit more to that DETACH statement but that it's omitted for brevity. The SET INTEGRITY statement (I'd strongly recommend ...


1

The communication buffer size for remote clients is determined by the RQRIOBLK database configuration parameter (more info in the manual). However, the statement you quote is overly simplistic and does not make much sense for DB2 configuration. Firstly, DB2 will perform direct disk I/O, so the OS read-ahead setting, if such thing even exists, will not have ...


0

Is this what you want? select OLDEST_TX_LSN from table(sysproc.MON_GET_TRANSACTION_LOG(-1))


0

So to adjust your UPDATE statements, they should look like this UPDATE t1 SET a = (SELECT a FROM t2 WHERE t2.b = t.b ) WHERE b in (SELECT b FROM t2 ) And the statement for updating multiple columns could look like this: UPDATE t1 SET ( x, y, z ) = (SELECT x, y, z FROM t2 ...



Top 50 recent answers are included