Author Topic: run failed with was/db2  (Read 9896 times)

sorcier

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
run failed with was/db2
« on: November 22, 2019, 04:08:12 AM »
Hi all,
    I deployed the  SPECjApp2004 environment with  WebSphere and DB2 based on the result files of others, I can successfully ping the database in the web console of WebSphere now.  But after executing the run script, an error is reported as follows:




    ......
    Messages from: 192.168.0.18:1010
-> 2019-11-22 03:53:03:731 specwebclient: setting tile ID to 0
-> 2019-11-22 03:53:03:752 Looking up polling host: webserver:8001

Messages from: 192.168.0.18:1091
-> 2019-11-22 03:53:19:564 Starting Agents
-> ---------------//client1:2098/Controller
-> Calling switchLog as master
-> url[0] is : http://specemulator:9081/Emulator/EmulatorServlet?cmd=switchlog
-> url[0] is : http://specemulator:9081/Emulator/EmulatorServlet?cmd=switchlog
-> url[1] is : http://specdelivery:9080/Supplier/DeliveryServlet?cmd=switchlog
-> calling driver.waitMatch(0)...
-> 2019-11-22 03:53:34:622 waiting for: waiting2ramp
-> RunID for this run is : 45
-> Output directory for this run is : /opt/SPECjAppServer2004/output/45
-> loadFactor=5
-> changeRate=30
-> burstyCurve from run.properties=37,72,61,87,132,77,0,49,137,93,187,103,174,138,200,173,153,107,225,44,36,44,48,68,138,125,116,88,38,50
-> scaleFactor=1.0
-> Curve avg txRate = 100.0
-> maxTxRate=225
-> tileNumber=0
-> Will run in bursty mode after rampup/warmup phases. Starting at burstPoint:0
-> WarmUp style = 0 (0=linear only, 1=burstycurve, 2=zigzag)
-> Phase one of warm up (start of transaction activity) will increase IR from 0 to 100 linearly, over 900 seconds.
-> Steady-State IR transition stepRate(ms)=40000
-> Burst Curve StartPoint Tile Multiplier=7
-> smoothFactor=1
-> Using default timeSkewTolerance value: 3
-> Exception encountered in auditor.validateInitialValues(). Aborting.
-> java.rmi.RemoteException: InitialContext failed. javax.naming.NoInitialContextException: Failed to create InitialContext using factory specified in hashtable [Root exception is java.lang.NullPointerException]




    Can someone help me or give me some advice? 
    Thanks.


abond

  • Moderator
  • Newbie
  • *****
  • Posts: 35
  • Karma: +6/-0
Re: run failed with was/db2
« Reply #1 on: November 22, 2019, 11:22:36 PM »
Hey Sorcier,

Have you tried running the curl commands to validate the appserver/dbserver setup and communication?  You can find them in the section "Appserver/Dbserver" of the Technical Support document.

https://spec.org/virt_sc2013/docs/SPECvirt_TechnicalSupport.html#Appserver

Andy

sorcier

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
Re: run failed with was/db2
« Reply #2 on: November 24, 2019, 08:36:30 PM »
hey,Andy
    The curl commands and results are as follows:



[root@client1 ~]# curl http://specdelivery:9080/Supplier/DeliveryServlet?cmd=switchlog
200 OK
[root@client1 ~]# curl http://specemulator:9081/Emulator/EmulatorServlet?cmd=switchlog
200 OK
[root@client1 ~]# curl http://specdelivery:9080/SPECjAppServer/app?action=atomicityTests
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>Atomicity Tests</TITLE>
</HEAD>
<BODY bgcolor="#ffffff" link="#000099" vlink="#000099">

<TABLE width="645" align="left">
                <UL>



                        <FONT size="5" color="#000000"><b>SPECjAppServer2004 Transaction Atomicity Test</b></FONT>
                        <BR></BR>
                </UL>
<P><BR>
</P>
<UL>
        <b>Definition:</b>  The System Under Test must guarantee that all Transactions are atomic; the system will either perform all individual operations on the data, or will assure that no partially-completed operations leave any effects on the data. The tests that were executed with their results below were used to determine if the System Under Test you are operating on meets all the transactional atomicity requirements. If any of the tests have a result of "FAILED" your system is not set up to ensure transaction atomicity
</UL>
<UL>
        <b>Test 1: </b>This test checks to see if the proper transaction atomicity levels are being upheld in transactions associated with the benchmark. This test case drives placing an order for immediate insertion into the dealerships inventory. An exception is raised after placing the order and while adding the inventory to the dealer▒s inventory table. This should cause the transaction changes to be removed from the database and all other items returned to how they existed before the transaction took place. This test case has three steps which are as follows to verify atomicity
        <p>
        1.) Query database to check how many inventory items the dealership has, the dealerships account balance, and the number of orders which have been placed for the dealer inside of the dealer domain. These numbers are the initial metrics that the final test cases should line up with after rolling back the transaction.
        </p>
        2.) Drives the above transaction which causes a transaction rollback exception to occur.
        <p>
        3.) Query database to check how many inventory items the dealership has, the dealerships account balance, and the number of orders which have been placed for the dealer inside of the dealer domain. These numbers should equal those in step 1) for the test case to be successful and the transaction to have been atomic.
        </p>

        <LI>Atomicity Test One: <b><FONT color="#ff0000">PASSED</b></FONT></LI><BR></BR>

        <p></p>
        <b>Test 2: </b>This test transaction simply tests that the application server is working properly and that it is able to insert an order as in Atomicity test 1 but without causing the exception and have it show up in the database.
        <LI>Atomicity Test Two: <b><FONT color="#ff0000">PASSED</b></FONT></LI><BR></BR>

        <p></p>
        <b>Test 3: </b>This test checks to see if the proper transaction atomicity levels are being upheld in transaction associated with the benchmark and specifically the messaging subsystem in this test case. This test case drives placing a order which contains a large order and an item to be insert immediately into the dealerships inventory. An exception is raised after placing the order and while adding the inventory to the dealer▒s inventory table. This should cause the transaction changes to be removed from the database, messages removed from queue and all other items returned to how they existed before the transaction took place. This test case has three steps which are as follows to verify atomicity.
        <p>
        1.) Query database to check how many inventory items the dealership has, the dealerships account balance, and the number of orders which have been placed for the dealer inside of the dealer domain. Also the large order table is queried to check how many large orders exist in the database before we drive the transaction. These numbers are the initial metrics that the final test cases should line up with after rolling back the transaction.
        </p>
        2.) Drives the above listed transaction which causes a transaction rollback exception to occur.
        <p>
        3.) Query database to check how many inventory items the dealership has, the dealerships account balance, and the number of orders which have been placed for the dealer inside of the dealer domain. Also query the large order table to check how many large orders there are in the table. These numbers should equal those in step 1) for the test case to be successful and the transaction to have been atomic.
        </p>
        <LI>Atomicity Test Three: <b><FONT color="#ff0000">FAILED</b></FONT></LI><BR></BR>

</UL>
</TABLE>
</BODY>







    I see that test3 returns a "FAILED",  so the atomicity test of the database failed.
    Next,i think i should modify the transaction atomicity level, am I right ? Or is there anything else I haven't noticed?

    Thanks

abond

  • Moderator
  • Newbie
  • *****
  • Posts: 35
  • Karma: +6/-0
Re: run failed with was/db2
« Reply #3 on: December 04, 2019, 12:19:20 PM »
Hey sorcier,

Were you able to get that third atomicity tests to pass?  That test failing doesn't necessarily mean it is the cause of the original error you reported, but being able to verify that the database is built and functions correctly is a key step to debugging your environment.

Andy

Frederick458

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: run failed with was/db2
« Reply #4 on: January 18, 2021, 05:58:02 AM »
A possible root cause of this error message is that the system has an incompatible VC++ 2008 redistributable package already installed, prior to installation of the Db2 database product.

« Last Edit: June 21, 2021, 10:39:52 AM by lroderic »

Dempsey25

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: run failed with was/db2
« Reply #5 on: February 08, 2021, 12:20:34 AM »
1. go to the log file from the runstat, read the error message, write down all errors
2. db2 connect to (name of database)
3. run the command:
db2 ” RUNSTATS ON TABLE __ ___ WITH DISTRIBUTION AND DETAILED INDEXES ALL ALLOW WRITE ACCESS “

4.if it will take more then 2-5 minutes, then stop it and go to the $home/sqllib/db2dump
5. search errors in the db2diag.log. If this file was compressed, then you can uncompress it in another directory, or simply use command zmore to read db2diag.log.Z file.
6. run the runstat and in the second terminal run the command: tail -f dinpdwh.nfy and wait for the error.

I had problems with the statistic heap size.

Easy solution:

db2 get db cfg for DAWISI show detail | grep -i heap
then you need just to increase the value, e.g.:

db2 “update db cfg using stat_heap_sz 5900 immediate”

I suggest use immediate at the end of statement.

« Last Edit: March 01, 2021, 02:33:18 PM by DavidSchmidt »

Roger7166

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: run failed with was/db2
« Reply #6 on: October 29, 2021, 12:59:04 AM »
Hey Sorcier,

Have you tried running the curl commands to validate the appserver/dbserver setup and communication?  You can find them in the section "Appserver/Dbserver" of the Technical Support document.

https://spec.org/virt_sc2013/docs/SPECvirt_TechnicalSupport.html#Appserver mcdvoice

Andy

Thanks to this article I can learn more. Expand my knowledge and abilities.
« Last Edit: October 29, 2021, 11:56:34 PM by Roger7166 »

jacobhue

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-1
Re: run failed with was/db2
« Reply #7 on: January 20, 2022, 09:02:54 AM »
If you get a run failed with was/db2 message, it means WebSphere Application Server (WAS) or DB2 cannot run the JVM on your computer.

If you are running IBM DB2, WAS requires at least version 6.1 of DB2.

If you are running Oracle, WAS requires at least version 10.2 of Oracle.

The WAS version number can be found in the output of the command "wasadmin list" on the default port.
« Last Edit: January 26, 2022, 06:38:50 PM by DavidSchmidt »

Deondre

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-2
Re: run failed with was/db2
« Reply #8 on: April 11, 2022, 02:42:47 AM »
Verify the SQL syntax using the IBM DB2 SQL Reference for the specific IBM DB2 platform and version. Check if data consumer application is using unsupported delimited object identifiers (e.g. square bracketsas opposed to using supported delimiters