huojia

Unix:

echo $DB2INSTANCE 能得到 owner name

Windows:

到v95还是未知，据说v97的db2iinfo 可以得到，没实验过。

我原来一直以为Solide DB是关系型数据库的一种类型的名字，今天才知道这个Solid和DB中间有应该是连着的，称之为solidDB. 此数据库产品是solid公司开发的，该公司2008年被IBM收购，所以成为IBM solidDB。最近Lab里面做了好几次这样的讲座，都没有去听。最近听一个v97的培训的时候，老师特别单独拿出来给BP讲，也没听到，只有过了过PPT。

solidDB是所谓的内存数据库产品，特点是绝对的快，绝对的可接触和低投入。 貌似现在在DB2 z/OS 那边在加速使用这种技术来提高传统关系型数据库的性能。不知道有没有在MP上开始。有机会了解一下。

Please collect a JCC Trace. Here are the instructions how to do this:

1) If you are using the datasource, then use the datasource.setTraceFile(TRACEFILE) to enable tracing.

2) If you are using DriverManger, the easiest way will be to set the logWriter on DriverManager before obtaining a connection.
    For example:
         DriverManager.setLogWriter(new PrintWriter(new FileOutputStream("trace.txt")));

3) You can also set the traceFile property on the URL. If traceFile property is specified, by default traceLevel is TRACE_ALL
    String databaseURL = "jdbc:db2://hal:50000/sample:traceFile=c:/temp/foobar.txt;" ;

Please see the following URLs for additional assistance :
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/cjvjcdig.htm
http://www.ibm.com/software/data/pubs/papers/sqlj (Section 3.4 – Trace)

Please collect a DB2 trace. Here are the instructions how to do this:
1) Minimize activity on the server.  Ideally, only the application or query required should be performed while the trace is on.
2) Rename the db2diag.log and if possible upgrade diaglevel to 4 in the DBM CFG:
    db2 update dbm cfg using diaglevel 4

3) Start the trace:
    db2trc on -t -f XXXXX.dmp

4) Recreate the error   -   call the Stored procudure.

5) Turn off the trace:
    db2trc off

6) Format and flow the trace files:
    db2trc flw XXXXX.dmp XXXXX.flw
    db2trc fmt XXXXX.dmp XXXXX.fmt
    db2trc fmt -c XXXXX.dmp XXXXX.fmtc
         (At this stage, the traces should not wrap.)
         Example of a good trace:
              Trace truncated     : NO
              Trace wrapped       : NO
         if trace continues to wrap, please contact me and we can determine whether the trace is usable or not.

7) From the above files generated, you would need to provide us with the .dmp, .flw, .fmt, .fmtc, and db2diag.log files.

Tar or zip the files.  To tar do:
       tar -cvf xxxxx.yyy.zzz.files.tar  <list of files separated by spaces>
       compress xxxxx.yyy.zzz.files.tar
       Then send the xxxxx.yyy.zzz.files.tar.Z

The capabilities that you need to consider include:

• Accessing the data using:
  • Embedded SQL
  • Call Level Interface (CLI)
  • Restructured Extended Executor Language (REXX)
  • Query products
• Controlling data values using:
  • Data types (built-in or user-defined)
  • Table check constraints
  • Referential integrity constraints
  • Views using the CHECK OPTION
  • Application logic and variable types
• Controlling the relationship between data values using:
  • Referential integrity constraints
  • Triggers
  • Application logic
• Executing programs at the server using:
  • Stored procedures
  • User-defined functions
  • Triggers.

$ more ~db2inst1/sqllib/ctrl/.fencedID
db2fenc1

db2 start 遇到 SQL1042c 错误，检查发现打了Fixpack后，没有升级instance.

* To update the instance to acquire a configuration or access to
function run DB2IUPDT <InstName>.
* If the error occurred while trying to connect to a database, get a
trace (instructions below) and call IBM support.

设置 DB2 环境

恰当地设置 DB2 环境非常重要，这是因为它控制着 DB2 操作和活动的方式。DB2 环境由以下几部分构成：

• DB2 配置文件注册库
• 操作系统环境变量
• DB2 数据库管理器配置参数
• DB2 数据库配置参数

（阅读全文……）