Basis Errors and Solutions

Symptom

This Note describes db2radm.jar versions. The latest version of db2radm.jar is attached to this Note. To get the version info of your
db2radm.jar, run:
java -cp /db2radm.jar InstallUtilities.Version
Old versions of db2radm.jar do not support Version info printing.
Other terms

db2radm.jar DB2
Reason and Prerequisites

Program error
Solution ————————————————————————

Fixes aplied before db2radm.jar versioning was introduced:
Update DB2 Catalog Statistics using ‘Stored Procedure DSNACCMO’
sun.io.ByteToCharSingleByte.convert(ByteToCharSingleByte. java:277)

————————————————————————
Changelog

Version 1) Start of db2radm versioning.
Version 2) SAMPLE on RUNSTATS. Now db2radm.jar accepts user properties for
statistics sampling. Please specify DSNACCMO_SAMPLE=5
in user properties file(file db2radmjar_user.properties,
path (/tmp, C:\tmp) or user home directory).
RUNSTATS SAMPLE 5 is ised by default for non lob table
spaces.
Version 3) UpdateStatisticsSuggested and UpgradeAction
class UpdateStatisticsSuggested can now be called with “-n” to
skip DSNACCMO call. Table spaces suggested for RUNSTATS are
printed to stdout. class UpgradeAction does now support
UpdateStatisticsSuggested and UpdateStatisticsSuggestedNoCatalog.
UserProperty RefSchemafromUrl was introduced to force RUNSTATS
on schema from Url instead of property Schema. UpdateStatistics[*]
does now append SYSPRINT to OutputFile if the file already exists.
Version 4) UpdateStatiscs and UpdateStatisticsAll Exclude all tablespaces which do have the value -1 in column space of
catalog table sysibm.systablepart. The value is -1 if the table space
was defined with the DEFINE NO clause, which defers the physical
creation of the data sets until data is first inserted into one of
the partitions, and data has yet to be inserted.
Allow specification of DSNACCMO max-parallel input value with user
properties. See version 2 SAMPLE on RUNSTATS for information how to
specify user properties. The property for max-parallel is
DSNACCMO_MaxParallel.
Example for /tmp/db2radmjar_user.properties:
DSNACCMO_MaxParallel=20
DSNACCMO_SAMPLE=10
Version 5) UpdateStatistics* Use INDEX(ALL) option for lob table spaces. Use TABLE(ALL)
and INDEX(ALL) option for catalog table spaces.
Version 6) SetLocksize Perform commit after every 5th ALTER statement instead of
after every 100th ALTER statement.
Version 7) UpdateStatistics Update Statistics on all DB2 catalog tables and indexes (in DSNDB06).
Sort table spaces to start RUNSTATS with catalog table spaces, then
largest SAP table spaces first. The size is taken from the NACTIVE
row on table SYSIBM.SYSTABLESPACESTATS (V9) or
SYSIBM.TABLESPACESTATS (V8).
Version VerifyVCAT New function to verify the VCAT during the installation process.
It’s required for NW702 based installations.
Version 9) UpgradeAction, JdbcVersionPrinter, UpdateStatistics, UpdateStatisticsDSNUTILS, GrantingAuthorizationsNew
Get Jdbc driver version. Print properties file with versions to
OutputFile. This class needs a db connect. Fix nactive/bytes sort in
UpdateStatistics. Add UpdateStatisticsDSNUTILS.
GrantingAuthorizationsNew does not need an input file, it uses
resource j2ee_grants.txt from jar.
————————————————————————
Applying db2radm.jar patches

The following is valid for older instalaltion master DVDs. For newer installation master DVDs see patch proc3ess below. On newer installationmaster DVDs db2radm.jar is on the DVD in directory COMMON/DB/DB2.
Old installation media
The jar file db2radm. jar is extracted by SAPinst into $TMP/sapinst_exe. /JAR directory. Copying a patched version of db2radm.jar into this directory is accident-prone because SAPinst extracts the db2radm.jar from the sapinst executable every time you start SAPinst, for example after an error.
The best solution to use an updated version of db2radm. jar is to update the sapinst self extracting zip file:Make a copy of the Installation Master DVD. Exchange the file JAR/db2radm.jar in the sapinst executable for your platform:Unix/Linux
This can be done for example on Linux platforms with the zip command. On AIX install the zip utility available as rpm package on the linux toolbox cd.mkdir JAR; copy /db2radm.jar JAR/mv sapinst sapinst.zipzip -u sapinst JAR/db2radm.jarmv sapinst.zip sapinstWindows
On Windows, you can exchange the db2radm.jar with compression tools that have zip compression functionality (WinZip, WinRAR).New installation media
The jar file db2radm. jar is located on the installation master DVD in the folder COMMON/DB/DB2.
The best solution to us an updated version of db2radm. jar is to update the file on the DVD.Make a copy of the Installation Master DVD. Exchange the file COMMON/DB/DB2/db2radm.jar with the new patch.