Tag Info

Hot 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".


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 ...



Only top voted, non community-wiki answers of a minimum length are eligible