ITPub博客

Stage 1 and stage 2 predicatesRows retrieved for a query go through two stages of processing. Certain predicates can be applied during the first stage of processing, whereas other cannot be applied until the second stage of processing. You can improve the performance of your queries by using predicates that can be applied during the first stagewhenever possible. Predicates that can be applied during the first stage of processing are called Stage 1 predicates. These predicates are also sometimes

http://www-01.ibm.com/support/docview.wss?uid=std36cc3a83530481f00492574890006c57d概要002F03EC【DBRMモジュールを作成したデータセット（仮にDBRMAとする）に対してBIND PLANを実行した場合は正常終了するのですが、作成したDBRMモジュールを別のデータセットにIEBCOPYでコピーしてからコピー先のデータセット（仮にDBRMBとする）に対してBIND PLANを実行するとSQLCODE-818で異常終了しました。】内容/目次<<< QUESTION >>> 2008/06/19 17:48:31 z/OS V1.4, DB2 V7の環境です。 DBRMモジュールを新たに作成

More information:http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=15300107http://www.ibmdatabasemag.com/story/showArticle.jhtml?articleID=17602333The bind process establishes a relationship between an application program and its relational data. This step is necessary before you can execute your program. Currently,DB2 allows you two basic ways of binding a program: to a package, or directly to an application plan. BIND PACKAGE subcommand allows you to bind DBRMs individually. It g

From IBM redbooks, the following information is written.Specifying the edit routine routine To name an edit routine for a table, use the EDITPROC clause of the CREATE TABLE statement, followed by the name of the routine. If you plan to use an edit routine, specify it when you create the table. In operation, the routine is loaded on demand. You cannot add an edit routine to a table that already exists: you must drop the table and re-create it. Also, you cannot alter a table with an edit routine t

今天居然发现了DB2 资料的错误。在DB2 redbook上，有如下表述： ALTER TABLE table-name (1) (2) (3)ADD column-definitionunique-constraintreferential-constraintcheck-constraintadd-partitionpartitioning-clauseRESTRICT ON DROP(4)CLONE clone-table-nameALTER column-alterationpartition-alterationROTATE partition-rotationDROP PRIMARY KEYFOREIGN KEY constraint-nameUNIQUECHECKCONSTRAINTRESTRICT ON DROP(4)CLONEVALIDPROC program-nameNULLAUDIT NONECHANGESALLDATA CAPTURE NONECHANGESCARDINALITYNOT VOLATILEVOLAT

http://en.wikipedia.org/wiki/Data_Language/1IBM Data Language One (DL/1)Data Language/1 (DL/1) is a misnomer that refers to DL/I, the language system used to access IBM’s IMS databases, and its data communication system.It is implemented from any language by making calls to a software stub, DFSLI000. This stub has entry points to handle a variety of programming languages e.g. calling CBLTDLI from a COBOL program. This stub is linked to the calling program, passes on the request to the IMS syste

http://www.dbforums.com/db2/506495-useful-db2-stuff.html[@more@]

University Information Technology Services Database Administration Team DB2 Standards - Glossaryactive log -The portion of the DB2 log to which log records are written as they are generated. The active log always contains the most recent log records, whereas the archive log contains those records that are older and will no longer fit on the active log.application plan -A control structure used by DB2 to process SQL statements during the execution of an application. The application plan is creat

The DB2 directory stores information about the operation and housekeeping of the DB2 environment. In contrast to the DB2 catalog, the directory cannot be accessed using SQL. The DB2 directory contains information required to start DB2, and there are activities and utilities in the DB2 environment that actually do the updating and deleting of table entries in the directory. The DB2 directory contains five tables; SPT01 :skeleton pakage table(SKPT) SCT02: skeleton cursor

FARINDREF : number of active pages which far from original pagesNEARINDREF : number of active pages which near from original pagesthat's happen when tablepsace or indexspace take extents[@more@]

シャドー・データ・セット(shadow data sets) SHRLEVEL REFERENCE または SHRLEVEL CHANGE を用いて REORG ユーティリティーを 実行する場合、ユーティリティーはシャドー・データ・セットを使用します。 ユーザー管理のデータ・セットの場合、SHRLEVEL REFERENCE または SHRLEVEL CHANGE を 用いた REORG を実行する前に、シャドー・データ・セットを事前割り振りしておく必要があります。 表スペース、パーティション、または索引が DB2 管理対象のデータ・セ

http://www.itpub.net/thread-1108225-1-1.html案例: CPU 100%使用率 好久没有发案例文章了，最近元旦，大家相对比较清闲，客户的问题也不是很复杂，终于能够抽出几个小时来写点技术方面的冬冬鸟…… （由于有些内容比较敏感，我在这里不贴任何真实的查询语句与抓到的数据，听俺描述就好了） 今天我们要讨论的是一个比较有趣（诡异？）的性能问题，在俺每一步的推导之前请大家都停下来思考一下：如果自己的公司出现这个问题的话应当如何处理 ：） 因为很多性能问题都类似于这个case，问题的根源往往与现象看起来风马牛不相及，所

在当今经济萧条的环境下，日本也免不了精简机构。其中当然也包括日本IBM。为了缩减机构，日本IBM AMS有把很多业务向中国转移的打算。在这个背景下，我也成为了一个被transfer的对象（很庆幸，自己能在经济危机的环境下有自己的工作，姑且不说薪水）。在跟日本IBM的同事（或者客户吧）工作1.5年后，发现以下现象：（我这里只针对我面向的客户发表评论）1.工作严谨。2.对礼仪和人际关系看得至关重要。3.友好[@more@]

花了半年时间准备JLPT 1考试，结果才258分，没过（合格线：280分），忒不舒服...为了实现自己的目标---DB2 DBA for z/OS， objective为了满足自己的求知欲， curiosity为了与广大网友分享经验和知识, sharing欲与广大志同道合之有志之士共同进步！[@more@]