db2advis

I am new to db2. I am trying to run db2advis on a sql statement in my lab and facing the following error:
db2advis -d sodev -f test -o sample

Error Invalid Command-Line option [-e]

0 solutions were evaluated by the advisor

exiting with error code [-804]

I also tried the following:

db2advis -d sodev -i test.in -t 5

Using user id as default schema name. Use -n option to specify schema
Explain tables not set up properly for schema so1872
The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-219]

It would be great if some one can help me out..

db2advis error

sirwhy it is giving errordb2advis -d database_name -t 10 -i input_file -o output fileselect distinct s.san_date,d.san_no,d.sl_no,r.item_code,i.descript ion,d.acc_qty,d.landed_cost,d.sale_price from stores_acceptance_note s,stores_acceptance_note_det d,stores_receipt_det r,item_master i where s.bd_co ...

db2advis and stored procedure help required (imp)

While using db2advis toll to get recomended idexes ,sometimes we get 10 or less indexes. Are we supposed to create all the indexes suggested by the tool or we need to select few of them or only only...kindly suggestor provide information regarding document which suggests the same2.My requirement is ...

db2advis error

We're at udb 8.2 64 bit on AIX 5.2 . I'm logged in as instance owner.>db2advis -d dxdmis01 -i xxx1.sql -m IMCP -o xxx1.outNo catalog node table space name has been specified on the command line. Using defaultUsing user id as default schema name. Use -n option to specify schemaSQL0805N Package ...

db2advis and db2diag.log

I executed db2advis on UDBV8.2 (PTF7a). And At the time, I saw the db2diag.log for warning and error.But, I got the result of db2advis about query or file.Never I do see the warn, but I continually see the db2diag.log after apply PTF7a on UDB V8.1.6.See below for references about the db2diag.log .== ...

Any experience with Design Advisor or db2advis ?

Greeting All,Did you ever use Design Advisor (GUI) or db2advis (cmd line)? 1. They gave me different recommendations on the same WORKLOAD. 2. db2advis gave me two similar indexes: CREATE UNIQUE INDEX ON "IN_PAGES" ("PAGE_CD" DESC) ALLOW REVERSE SCANS ;CREATE UNIQUE INDEX ON ...

My db2advis can't execute

I am trying to run DB2ADVIS but I have this error:Database is reporting the following error:error. The db2advis tool needs the explain tables andthe advise tables to exist. Please create themusing the EXPLAIN.DDL script in the misc subdirectoryof the sqllib directory.But I have created all the table ...

db2advis and explain options

Is there a way that I can simulate an index and explain the SQL to get the access plan if the index actually existed?What I want to do is use db2advis and get a recommendation to create and index. Then do an explain on the SQL, as if the index exists. I don't want to create the index and then do the ...

can db2advis be told a non default schema?

My environment:db2level: "DB2 v8.1.0.48", "s040212", "MI00069", FixPak "5".db2licm -l: DB2 Enterprise Server Editionuname -a: Linux 2.6.17-1.2187_FC5smpMy question:I am trying to run db2advis o a third party DB (restored by db2move). The schema for this db doe ...

control center in unix, db2advis tool

1. I want to run the db2 control center in UNIX server. I issued db2cc command and it's giving the following error.Exception in thread "main" java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironmentat java.lang.Class.forName1(Native Method)at java.lang.Class.forName(Class.java:177)at ...

db2advis error code [-106]

9.1 FP4a on AIX 5.3Hey guys I keep getting an error -106 on some SQLs swhen I try and use the db2advisor on them. I've seen the APAR about TABS but there's no tabs in these SQLs (others work fine).Here's an exampleselect * from asset where location = 'CUST1' and siteid= 'MAIN' and status not in ( 'D ...

db2advis Run on Client Side?

Server: DB2 9.1 Win2003Client: WinXp installed with DB2 9.1 clientIs it possible to invoke "db2advis" on client side?When I try invoke the command on command line, it just gives below error:'db2advis' is not recognized as an internal or external command,operable program or batch file.I did ...

db2advis start-date

We are fairly new to DB2. We love the db2advis command, but would like to bounce it off queries captured by WLM. We aren't sure how to use it with the '-start-time' and '-end-time' option. Specifically, what date format do you give it. Such as yyyy-mm-dd HH:MM, or whatever. The documentation we have ...

do we follow the advice of db2advis?

They've just executed my request to run "db2advis" using the whole package-cache as input. Scanning through the index-advices I notice some weird things: - include columns are nice, but including each & every column? I am pretty sure that some columns are never part of a "where ...

db2advis 8.2 error

I currently test 8.2 Enterprise eval.When i run "db2advis -d testowa -m I -f -i c:\zap.sql" all is ok and i get index recomendation.When i run "db2advis -d testowa -m IM -f -i c:\zap.sql" ( to show recommended MQTs) i get information (sorry from poor translation from polish)SQL0104N Founds unexpecte ...

db2advis crash the instance

I'm running DB2 V8.1 (FP9) on Linux and when trying to execute advise for a workload with -m MIC (MQT,Index,Clusterd Tables) my instance crashes. I have tried the three options separately and it seems to crash only on MQT advise.Is there any APAR on this? can be fixed? ...

DB2ADVIS error

This is the command i used:db2advis -d CRMSTG -i db2advis.in -a crm88dev/crmstg -l -1 -t 0Error message that I get:execution started at timestamp 2006-07-24-11.35.32.503000found[1] SQL statements from the input fileexcluding statement[0] from the workload.No valid statements were found in this input ...

db2advis fails on DB2 UDB V8.1 FixPack 10

I'm trying to use db2advis and it does not work. The errors received are as follows:Using user id as default schema name. Use -n option to specify schemaCALL SYSPROC.GET_DBSIZE_INFO failed (workaround - use -l)SQL1042C An unexpected system error occurred. SQLSTATE=58004****************************** ...

DBA2193: "Design Advisor" cannot run without "db2advis".

"Design Advisor" cannot run without "db2advis". Ensure that the Database Tools subcomponent is installed.We are trying to run design advisor against databases on remote AIX servers which are cataloged on local Windows desktops. Design advisor works against certain servers, on others it produces the ...

db2advis & reorgchk

I am new to this forum, but still very much impressed when I see interesting postings on this forum.I would like to start a topic on db2advis and want you people to share your valuable comments. Please share the reason if you are supporting or if you are not supporting the below mentioned statement. ...

db2advis & reorgchk

I am new to this forum, but still very much impressed when I see interesting postings on this forum.I would like to start a topic on db2advis and want you people to share your valuable comments. Please share the reason if you are supporting or if you are not supporting the below mentioned statement. ...

db2advis fails for valid statement

When using db2advis to recommend access path, it fails for a valid SQL statement that executes successfully without any syntax errors. I'm getting the following message from db2advis.execution started at timestamp 2011-02-04-19.17.50.851482Using the default table space name USERSPACE1I'm having trou ...

DB2ADVIS

I am trying to run DB2ADVIS but I have this error:Database is reporting the following error:error. The db2advis tool needs the explain tables andthe advise tables to exist. Please create themusing the EXPLAIN.DDL script in the misc subdirectoryof the sqllib directory.Even if I have created all the t ...

DB2ADVIS ERROR

This is the command i used:db2advis -d CRMSTG -i db2advis.in -a crm88dev/crmstg -l -1 -t 0Error message that I get:execution started at timestamp 2006-07-24-11.35.32.503000found[1] SQL statements from the input fileexcluding statement[0] from the workload.No valid statements were found in this input ...

Error in db2advis

I am using DB2 v8.1. While using db2advis I am getting -601 error (which has no documentation to explain reasoning). I am running the following command: db2advis -d dbname -a userid/pwd -g -m MICP -o adviseAnd following is the text which gets generated:*********************************************** ...