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 ...

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 .== ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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? ...

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 ...

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****************************** ...

"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 ...

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. ...

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. ...

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 ...

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 ...

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 ...

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:*********************************************** ...