主页 / dba / 问题

问题[db2](dba)

Martin Hope
folow
Asked: 2024-10-17 18:34:54 +0800 CST
  • 7

在 Linux 上的 Db2 v11.5 上，如果我执行命令来检查数据库实例是否启动并正在运行：

ps -e -o command | grep db2sysc

输出为：

db2sysc 0

数字 0 代表什么？我问这个是因为也许在 bash 脚本中用到它会很有用。

db2
Martin Hope
Lennart - Slava Ukraini
Asked: 2024-01-25 20:34:50 +0800 CST
  • 5

我注意到导入截断的数据只会引发警告。T 认为通过处理程序捕获该警告并发出错误信号会很简单，但我似乎无法做到这一点。有什么建议么？

CREATE OR REPLACE PROCEDURE FILE_IMPORT_HANDLER(filename VARCHAR(255), tablename 
VARCHAR(255))
LANGUAGE SQL
BEGIN
    DECLARE EXIT HANDLER FOR SQLSTATE '22001'
        SIGNAL SQLSTATE '75002'
            SET MESSAGE_TEXT = '...';

    CALL ADMIN_CMD('import from ' || filename || ' of del insert into ' || tablename);
END @

如果遇到22001我愿意努力失败。从某种意义上说，提高导入过程中数据截断的严重性

db2
Martin Hope
Lennart - Slava Ukraini
Asked: 2024-01-08 19:37:01 +0800 CST
  • 5

在我意识到存在重新验证对象的过程（SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS）之前，我编写了自己的过程。现在，我尝试将其替换为标准的，但似乎对 SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS 的调用破坏了我正在循环的游标。旧程序示例：

db2 -td@ +c "BEGIN FOR v AS c1 CURSOR FOR SELECT SCHEMANAME FROM NYA.VALIDATION_SCHEMAS DO CALL TOOLBOX.COMPILE_SCHEMA2(v.schemaname); END FOR; END @"
DB20000I  The SQL command completed successfully.

使用 ADMISN_REVALIDATE_DB_OBJECTS 的示例

db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(object_schema=>'TMP')"
Return Status = 0
db2 "CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(object_schema=>'TMP')"
Return Status = 0

尝试在光标上循环使用它：

db2 -td@ +c "BEGIN FOR v AS c1 CURSOR FOR SELECT SCHEMANAME FROM NYA.VALIDATION_SCHEMAS DO CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(object_schema=>v.schemaname); END FOR; END @"
DB21034E  The command was processed as an SQL statement because it was not a 
valid Command Line Processor command.  During SQL processing it returned:
SQL0501N  The cursor specified in a FETCH statement or CLOSE statement is not 
open or a cursor variable in a cursor scalar function reference is not open.  
SQLSTATE=24501

请注意，它对硬连接架构没有帮助：

db2 -td@ +c "BEGIN FOR v AS c1 CURSOR FOR SELECT SCHEMANAME FROM NYA.VALIDATION_SCHEMAS DO CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(object_schema=>'TMP')
[...]

也会产生错误。我尝试了在光标上循环的变体：

BEGIN
    DECLARE s VARCHAR(128);
    DECLARE v_at_end INTEGER default 0;
    DECLARE not_found CONDITION FOR SQLSTATE '02000';
    DECLARE C1 CURSOR for
        SELECT SCHEMANAME FROM NYA.VALIDATION_SCHEMAS;
    DECLARE CONTINUE HANDLER FOR not_found  SET v_at_end = 1 ;

    OPEN C1;
    fetch_loop:
    LOOP
        FETCH FROM C1 INTO s;
        IF v_at_end <>0 THEN LEAVE fetch_loop; END IF;
        CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS(object_schema=>s);
    END LOOP;
    CLOSE C1;
END
@

但它也不起作用。任何线索，需要做什么才能在循环中调用 ADMIN_REVALIDATE_DB_OBJECTS ？

db2
Martin Hope
folow
Asked: 2023-12-06 14:55:48 +0800 CST
  • 5

在我们的计算机上安装了 Db2 v11.5.8.0 Linux/x86-64。我想安装新的修复程序作为定期更新，特别是部署安全修复程序。

几周前发布了新的修复包 11.5.9.0。但现在我看到累积特殊构建也列在下载 Db2 修复包网页上。查看CSB网页的详细信息，有信息：“CSB是累积的，每个CSB包含先前CSB中提供的所有修复。” 如果我理解正确，CSB 不应安装在 v11.5.9.0 之上，而应安装在以前的 CSB 之上（如果安装在 Db2 服务器上）。它是否正确？

CSB 的首要目的是什么？仅包含安全和故障修复而没有新功能？应用CSB后Db2的发布是什么？

谢谢

db2
Martin Hope
folow
Asked: 2023-11-17 18:04:20 +0800 CST
  • 6

在 Red Hat 8.8 上，我安装了 Db2 v11.5.8.0 并且数据库工作正常。

  1. 今天我下载了v11.5.9.0并解压了tar文件。
  2. 我执行了db2prereqcheck并且满足了所有先决条件。成功的。
  3. 使用db2_install命令安装 Db2。成功的。
  4. 使用命令升级实例db2iupdt。成功的。
  5. 然后我尝试启动一个实例，并db2start出现错误：db2start：加载共享库时出错：libaws-cpp-sdk-transfer.so：无法打开共享对象文件：没有这样的文件或目录

看起来有些库丢失了。我尝试在网上搜索，但找不到如何安装该库。任何想法？

db2
Martin Hope
Sarov
Asked: 2023-09-07 04:18:04 +0800 CST
  • 5

我正在尝试将生成的列添加到 IBM DB2 V7R3 中的表中：

ALTER TABLE MYLIB.MYTABLE
    ADD COLUMN NEW_COL VARCHAR(255) GENERATED ALWAYS AS (
        COALESCE(
            CASE
                WHEN ENV = 'A' THEN (SELECT GUIDE_URL FROM MYLIBA.PROGRAM WHERE CODE = PGM)
                WHEN ENV = 'B' THEN (SELECT GUIDE_URL FROM MYLIBB.PROGRAM WHERE CODE = PGM)
                ELSE (SELECT GUIDE_URL FROM MYLIBC.PROGRAM WHERE CODE = PGM)
            END
            , URL
        )
    )

但它给出了以下错误：

 SQL 状态：42601 供应商代码：-199 消息：[SQL0199] 不需要关键字 WHEN。有效令牌： . ACCTNG 用户 ID 应用程序名称 程序 WRKSTNNAME。原因 。。。。。：此处不需要关键字 WHEN。在关键字 WHEN 处检测到语法错误。有效令牌的部分列表是 。ACCTNG 用户 ID 应用程序名称 程序 WRKSTNNAME。此列表假定语句在意外关键字之前都是正确的。该错误可能出现在语句的前面，但到目前为止该语句的语法似乎是有效的。恢复 。。。：检查指定关键字区域的SQL语句。冒号或 SQL 分隔符可能会丢失。SQL 要求保留字在用作名称时进行分隔。更正 SQL 语句并再次尝试请求。

难道我做错了什么？或者在 7.3 中创建这样的生成列是不可能的吗？升级到 7.5 有帮助吗？我试图找到有关可以在哪些版本中生成哪些生成的列的详细信息，但在文档中找不到任何内容。

db2
Martin Hope
Sarov
Asked: 2023-08-05 03:03:40 +0800 CST
  • 4

尝试计算 FIFO 报告的值。有没有一种方法使用 SQL 对数据进行分组，以便将特定值的总和与每个组的不同值进行比较，包括在必要时仅取行的一部分？

请求：对于每个商品编号，按日期对已购买商品进行降序排序，并获取最大金额，使数量总和 = 该商品编号的已售出金额，如有必要，仅取最后一行的一部分获得匹配的数量。然后输出未售出剩余库存的结果，其中包含 ItemNumber、NumShipments 和 CostSum（CostPer 与 Quantity 的乘积之和）。

例如，考虑以下架构：

CREATE TABLE MYLIB.TOTAL_ITEM_SOLD (ITEM_NUMBER VARCHAR(15) NOT NULL NOT HIDDEN , QUANTITY_SOLD DECIMAL(5, 2) NOT HIDDEN , PRIMARY KEY (ITEM_NUMBER)  ) NOT VOLATILE UNIT ANY KEEP IN MEMORY NO ;

CREATE TABLE MYLIB.ITEM_PURCHASE (ITEM_NUMBER VARCHAR(15) NOT NULL NOT HIDDEN , DATE_ORDERED TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL NOT HIDDEN , QUANTITY DECIMAL(4, 2) NOT NULL NOT HIDDEN , COST_PER DECIMAL(10, 2) NOT NULL NOT HIDDEN , PRIMARY KEY (DATE_ORDERED, ITEM_NUMBER) ) NOT VOLATILE UNIT ANY KEEP IN MEMORY NO ;

INSERT INTO MYLIB.TOTAL_ITEM_SOLD (ITEM_NUMBER, QUANTITY_SOLD) VALUES ('APPLE', 5);

INSERT INTO MYLIB.ITEM_PURCHASE (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 2, 1.23);
INSERT INTO MYLIB.ITEM_PURCHASE (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 4, 2.34);
INSERT INTO MYLIB.ITEM_PURCHASE (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 2, 5.55);

预期结果：

{ITEM_NUMBER: "APPLE", QTY_REMAINING: 3, COST_SUM: 13.44}

因为 5.55+5.55+2.34 = 13.44。

db2
Martin Hope
Sarov
Asked: 2023-08-02 05:55:03 +0800 CST
  • 5

有没有一种方法使用 SQL 对数据进行分组，以便将特定值的总和与每个组的不同值进行比较？

例如，考虑以下架构：

Table: ITEM
Columns:
    ITEM_NUMBER (VARCHAR(15))
    QUANTITY_ON_HAND (DECIMAL(5,2))
Primary Key: ITEM_NUMBER

Table: ORDER_ITEM_REQUIREMENTS
Columns:
    ITEM_NUMBER (VARCHAR(15), Foreign Key to ITEM)
    DATE_ORDERED (TIMESTAMP)
    QUANTITY (DECIMAL(4,2))
    COST_PER (DECIMAL(10,2))
Primary Key: ITEM_NUMBER+DATE

请求：对于每个项目编号，按日期升序排列订单项目要求，并获取最大数量，使数量总和 <= 该项目编号的现有数量（如果总和为 1，则获取所有订单项目要求）小于现有数量）。然后输出包含 ItemNumber、NumShipments、QtySum 和 CostSum（CostPer 与 Quantity 的乘积之和）的结果。

如果重要的话，我们正在使用 IBM DB2 Version 7 Revision 3。

例如，给定以下数据：

{ITEM_NUMBER: "APPLE", QUANTITY_ON_HAND: 5}
{ITEM_NUMBER: "APPLE", DATE_ORDERED: Jan 1, 12:01, QUANTITY: 2, COST_PER: 1.23}
{ITEM_NUMBER: "APPLE", DATE_ORDERED: Jan 1, 12:02, QUANTITY: 2, COST_PER: 2.34}
{ITEM_NUMBER: "APPLE", DATE_ORDERED: Jan 2, 12:03, QUANTITY: 2, COST_PER: 5.55}

或者用 SQL 来说：

CREATE TABLE MYLIB.ITEM (ITEM_NUMBER VARCHAR(15) NOT NULL NOT HIDDEN , QUANTITY_ON_HAND DECIMAL(5, 2) NOT HIDDEN , PRIMARY KEY (ITEM_NUMBER)  ) NOT VOLATILE UNIT ANY KEEP IN MEMORY NO ;

CREATE TABLE MYLIB.ORDER_ITEM_REQUIREMENTS (ITEM_NUMBER VARCHAR(15) NOT NULL NOT HIDDEN , DATE_ORDERED TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL NOT HIDDEN , QUANTITY DECIMAL(4, 2) NOT NULL NOT HIDDEN , COST_PER DECIMAL(10, 2) NOT NULL NOT HIDDEN , PRIMARY KEY (DATE_ORDERED, ITEM_NUMBER) , FOREIGN KEY (ITEM_NUMBER) REFERENCES MYLIB.ITEM (ITEM_NUMBER) ON DELETE NO ACTION ON UPDATE NO ACTION  ) NOT VOLATILE UNIT ANY KEEP IN MEMORY NO ;

INSERT INTO MYLIB.ITEM (ITEM_NUMBER, QUANTITY_ON_HAND) VALUES ('APPLE', 5);

INSERT INTO MYLIB.ORDER_ITEM_REQUIREMENTS (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 2, 1.23);
INSERT INTO MYLIB.ORDER_ITEM_REQUIREMENTS (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 2, 2.34);
INSERT INTO MYLIB.ORDER_ITEM_REQUIREMENTS (ITEM_NUMBER, QUANTITY, COST_PER) VALUES ('APPLE', 2, 5.55);

我想要以下结果：

{ITEM_NUMBER: "APPLE", NUM_SHIPMENTS: 2, QTY_SUM: 4, COST_SUM: 7.14}
db2
Martin Hope
database_adm
Asked: 2023-06-12 19:49:35 +0800 CST
  • 5

当我跑步时

./db2prereqcheck -i -v 11.5.8.0

服务器没有回复。它挂起并且没有响应。

可能是什么问题？

该机器运行在 AIX 7.2 上。

当我运行时有相同的效果（没有响应）：

db2 list applications

但是，如果我运行：

db2 list db directory

或者

db2pd -db DBNAME -apinfo

我得到了预期的输出。我用export LC_ALL运行它，结果是一样的：

14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
Reading DB2 prerequisites from DB2prereqs.xml
Scanning line :   <MinPowerLevel>7</MinPowerLevel>
 ==>Adding  PREREQ[MinPowerLevel]=7
Scanning line :   <MinOSVersion>7</MinOSVersion>
 ==>Adding  PREREQ[MinOSVersion]=7
Scanning line :   <MinOSRelease>2</MinOSRelease>
 ==>Adding  PREREQ[MinOSRelease]=2
Scanning line :   <TLSP value="OSVersion = 7 OSRelease = 2">
   Evaluate for PREREQ[TLSP]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[TLSP]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
Scanning line :   <MinTL>3</MinTL>
 ==>Adding  PREREQ[MinTL]=3
Scanning line :   <MinSP>3</MinSP>
 ==>Adding  PREREQ[MinSP]=3
Scanning line :   </TLSP>
Scanning line :   <DDRIBFirmware>0x2000021</DDRIBFirmware>
 ==>Adding  PREREQ[DDRIBFirmware]=0x2000021
Scanning line :   <QDRIBFirmware>0x0000</QDRIBFirmware>
 ==>Adding  PREREQ[QDRIBFirmware]=0x0000
Scanning line :   <QDRIBDeviceID>b3153c67</QDRIBDeviceID>
 ==>Adding  PREREQ[QDRIBDeviceID]=b3153c67
Scanning line :   <MinQDRIBROM>000200091000</MinQDRIBROM>
 ==>Adding  PREREQ[MinQDRIBROM]=000200091000
Scanning line :   <RoceCX340GDeviceID>b31503101410b504</RoceCX340GDeviceID>
 ==>Adding  PREREQ[RoceCX340GDeviceID]=b31503101410b504
Scanning line :   <RoceCX310GDeviceID>b31507101410e704</RoceCX310GDeviceID>
 ==>Adding  PREREQ[RoceCX310GDeviceID]=b31507101410e704
Scanning line :   <MinRoceCX340GROM>000200325100</MinRoceCX340GROM>
 ==>Adding  PREREQ[MinRoceCX340GROM]=000200325100
Scanning line :   <MinRoceCX310GROM>000200325310</MinRoceCX310GROM>
 ==>Adding  PREREQ[MinRoceCX310GROM]=000200325310
Scanning line :   <RoceCX2Firmware>0x0000</RoceCX2Firmware>
 ==>Adding  PREREQ[RoceCX2Firmware]=0x0000
Scanning line :   <RoceCX2FlexDeviceID>b3155067b3157265</RoceCX2FlexDeviceID>
 ==>Adding  PREREQ[RoceCX2FlexDeviceID]=b3155067b3157265
Scanning line :   <RoceCX2DeviceID>b315506714101604</RoceCX2DeviceID>
 ==>Adding  PREREQ[RoceCX2DeviceID]=b315506714101604
Scanning line :   <MinRoceCX2FlexROM>00200091302</MinRoceCX2FlexROM>
 ==>Adding  PREREQ[MinRoceCX2FlexROM]=00200091302
Scanning line :   <MinRoceCX2ROM>000200091316</MinRoceCX2ROM>
 ==>Adding  PREREQ[MinRoceCX2ROM]=000200091316
Scanning line :   <xlcPackage>
Scanning line :   <xlcPackageName>xlC.rte</xlcPackageName>
 ==>Adding  PREREQ[xlcPackageName]=xlC.rte
Scanning line :   <xlcLabel>XL C/C++ Runtime</xlcLabel>
 ==>Adding  PREREQ[xlcLabel]=XL C/C++ Runtime
Scanning line :   <xlcVersion>13</xlcVersion>
 ==>Adding  PREREQ[xlcVersion]=13
Scanning line :   <xlcMajorRelease>1</xlcMajorRelease>
 ==>Adding  PREREQ[xlcMajorRelease]=1
Scanning line :   <xlcMinorRelease>2</xlcMinorRelease>
 ==>Adding  PREREQ[xlcMinorRelease]=2
Scanning line :   <xlcMinorRelease2>0</xlcMinorRelease2>
 ==>Adding  PREREQ[xlcMinorRelease2]=0
Scanning line :   </xlcPackage>
Scanning line :   <uDAPLLabel>uDAPL</uDAPLLabel>
 ==>Adding  PREREQ[uDAPLLabel]=uDAPL
Scanning line :   <uDAPLPackage>udapl.rte</uDAPLPackage>
 ==>Adding  PREREQ[uDAPLPackage]=udapl.rte
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 3">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 3
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>3</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>3</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 4">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 4
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>4</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>4</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 5">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 5
   Evaluate PREREQ[TL] current value= 5
   condition matched
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
 ==>Adding  PREREQ[uDAPLVersion]=7
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
 ==>Adding  PREREQ[uDAPLMajorRel]=2
Scanning line :   <uDAPLMinorRel>4</uDAPLMinorRel>
 ==>Adding  PREREQ[uDAPLMinorRel]=4
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
 ==>Adding  PREREQ[uDAPLMinorRel2]=0
Scanning line :   </uDAPL>
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 6">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 6
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>6</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>6</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 3 TL = 0">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 3
   Evaluate PREREQ[OSRelease] current value= 2
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>3</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>3</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>0</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>0</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <pureScale>
=== Skip tag BEGIN ===
   Pushing XML Tag to stack pureScale
   Skipping =>  <pureScale>
Scanning line :   <MinOSVersion>7</MinOSVersion>
   Skipping =>  <MinOSVersion>7</MinOSVersion>
Scanning line :   <MinOSRelease>2</MinOSRelease>
   Skipping =>  <MinOSRelease>2</MinOSRelease>
Scanning line :   <TLSP value="OSVersion = 7 OSRelease = 2">
   Skipping =>  <TLSP value="OSVersion = 7 OSRelease = 2">
Scanning line :   <MinTL>3</MinTL>
   Skipping =>  <MinTL>3</MinTL>
Scanning line :   <MinSP>3</MinSP>
   Skipping =>  <MinSP>3</MinSP>
Scanning line :   </TLSP>
   Skipping =>  </TLSP>
Scanning line :   </pureScale>
=== END skip tag RESUME ===
Finishing reading XML for platform </platform>
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
sqloCheckForIOPorts ENTRY
szCmd ---> lslpp -lc bos.iocp.rte >> /dev/null  2>&1 > /tmp/db2prereqcheck.10420674
 IO Ports installed
szCmd ---> LANG=C /usr/sbin/lsdev -Cc iocp >> /dev/null  2>&1 > /tmp/db2prereqcheck.10420674
IO Ports not Available
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
sqloCheckForIOPorts EXIT
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
resetEtcHosts ENTRY
resetEtcHosts EXIT
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
db2