Home

QueryOptimizer

1. Within the User view you have the possibility to display queries which have been assigned to a prior defined user respectively a group 6 1 Display User Query You can also start this function by using command QRYOPTUSR which can be fed with the parameter USER The pre occupation of AUTO means that the User ID of the registered users will be taken over The command is suitable in a ideal manner for the integration into existing applications Herewith for example you can display his queries to the users which have been assigned by the administrator out of the application The search via Query 400 is unnecessary for the user Abfragen ausf hren User 2030000 15 01 02 11 39 15 Auswahl treffen und Eingabe dr cken R Query ausf hren X Query im Hintergrund ausf hren E Optionen einstellen Asw Bibliothek Name Beschreibung S Ausf hrungsoptionen ndern mit E AGXFOY XQ21000 Liste f r Programm XQ21000 F3 Verlassen F5 Aktualisieren Fll Infos anzeigen F12 Abbrechen F15 Suchen User view on Queries By using the selection line as well as key F15 the user has also the possibility to use the extensive Search and Restriction features 6 1 1 Adjust Options In order to enable a user to carry out certain settings regardless of other users it is possible to change the execution option by selecting E prior to a query The User settings are being memorised separately from each other and alterations can be made indep
2. Enter choice or command gt F3 Verl F4 Bed frg F9 Auffinden F12 Abbrechen F13 Unterst tzende Informationen F16 AS 400 Hauptment Main menu QueryOptimizer Administer View The menu is being subdivided in 4 sections 1 Sector Commands At this point the existing queries are being taken over into the management of the QueryOptimizer the CPU capacity of the queries are being determined queries are being optimized and the Index information of the queries is being updated For these actions the following commands are available QRYOPTMDB Analize Query CRIOPTQRY Optimize Query GETQRYCPU Determine query for CPU capacity UPDOPT Update Index Information Handbuch QueryOptimizer Seite 13 2 Sector Administration Within the Query Administration the queries are being displayed and managed by query or file name without library limit 3 Sector User view On using the user view you can either assign a query to one user or to a group of users as well as have the query displayed To your availability is the following command QRYOPTUSR which enables you to integrate the display of user queries into own applications or Start programs The user views can either be pulled up by menu options 5 6 and 7 or changed into out of the menu points by using function key FLO 4 Sector Other This function enables you to display the actual installed version of the QueryOptimizer within the status line Foll
3. Liste f r Programm D 2 F 8 S 2 D 1 F 14 D 1 F 23 Sortierung nach Query Name Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY P Performance A Analyse 4 L schen Q Query auf Display U Benutzer V Variablen A Bibliothek Name F3 Verlassen F6 Neu F10 Dateisort F11 Sicht 4 F12 Abbrechen Fl7 Text ffnen F21 Befehlseingabe AGXFQY AGXFQY AGXFQY AGXFQY QSYS QSYS XQ10000 XQ20000 XQ21000 XQ40000 QSECAF QSECCA F20 Liste drucken Beschreibung Typ Ersteller Liste f r Programm ORYDFN GOERING Liste f r Programm ORYDFN GOERING Liste f r Programm ORYDFN GOERING Liste f r Programm ORYDFN GOERING ORYDFN IBM ORYDFN IBM Sortierung nach Query Name Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY P Performance A Analyse 4 L schen Q Query auf Display U Benutzer V Variablen A Bibliothek Name F3 Verlassen F6 Neu F10 Dateisort F11 Sicht 5 F12 Abbrechen Fl7 Text ffnen F21 Befehlseingabe Handbuch QueryOptimizer AGXFQY AGXFQY AGXFQY AGXFQY Ders QSYS XQ10000 XQ20000 XQ21000 XQ40000 QSECAF QSECCA F20 Liste drucken Beschreibung CPU vorher Liste f r Programm Liste f r Programm Liste f r Programm Liste f r Programm 0 3 0 2 CPU nachher XQ10000 0 2 XQ20000 0 4 2021000 XQ40000 Er
4. SOLLE ln e EE 32 SOrLIEFUNG SEENEN 24 Sortierung nach Benutzemame err eer renan en er enc r an re area ana anee aerea r encrenca een re nana 29 Sortierung nach REN ln oasis ain ds een 21 Sortierung nach Dalel Name EE 23 Sortierung nach Ouerv Name nenn nenn EEEE EEEE 23 26 DA en ee ee een ee 10 SOL ENTAO eege 16 SUCH ADE DO EE 30 SHS ONIN SCI an EE 26 Technische Voraussetzungen esses cdnceasensenaacenee cucu nennen nennen eher 6 END go EX COPPE NRO DU RE NNE RD DTD DN CI O EN Bill Zeie E Updal vom V Cl Le RE 10 MIO 6 6 gt EE 13 21 BEE 29 VAN AD E EE 32 Verl ngerung der Testoertode eee eerer nenne nenne nnnnnnnnn nenne nnnnennnnnnnnnnnnnnnnnennnnnn nennen 6 Verwendete Dateien 30 Venwendeteteider 0000000 era ea nano ann nnnunnnnnnennnnnnennnnnnennnnnnennnnnnennnnnnnennnnnne nenne 31 NEIE 38 Seite 50 Handbuch QueryOptimizer EE 35 ZICISSI ZUG und NULO BEE 5 Handbuch QueryOptimizer Seite 51
5. 21 JOD VN AllESCHIANGE ee een ae rain 17 19 20 21 Seite 48 Handbuch QueryOptimizer FTI ON ee oh 0 2 eege 2 HES UT SO e E ee ee nee ee ee RIR RODE E O reise een Letzte QUER EI a lo MB TO BE 28 LTR ER en ehe Se en ee ee 38 LINK MOOS ee A 38 CODR ON WEE 9 LOSON RE 35 AOD S e e ciate cattle tepid ad T WE e Ee ran ee ee ee NITRO EE 27 NULZUNGSDEAINGUNGEN EE 5 OPUNE UNG EE lte SINS tole EE BT UVM RD Ep COPE RIDERS RR RR SEA RSRS ee AR SRA RED ESA UR AR AE E IN E 15 17 20 OOP ORI seca ae E SN RS E E UN RENNEN E E OR EE 13 QRYOPTMDB ee 13 QRYOPTUSR areia eae aaa a arara Rara RARA aaa aaa arena ana ana na nara a 14 Query analysieren seen ne dai a Pee ao Sd td 15 IR auf RTE ER EIERE EE 41 Query CPU Belastung ermitteln ccccccececececceeceeeeeceseeeeesseeeessaeeeseaeeeseaeeeseeessesesseessaeeeeesaneeees 19 Query im Hintergrund ausf hren e eee eerea nun u nnnne nenne nnnnennnn aerea nnnne nenne nnnnnnnnnennnne 41 UTS ON E EEN 17 Query Informationen ermitteln nenne nnnnnnnnn anne nenne nenne nnnnnnnnn nenne nnnnnnnnnnennnne 10 QUEFY OPBIMIELUNGSIATIEN nennen eier 10 Handbuch QueryOptimizer Seite 49 PONOR I E PBMR GE eE E IS US a E EET ED ee ee ER RR E O T e EECHER tee eege eebe 31 Separate Datenbibliothek ccc ceccseccesccceeeeececeeeceeceeeceeeseeeseeteeteeeteeecseeeeeeseueeeueeseeesueesueeseeeseeesaeees 10 SOHWATE INS All AO en ea en ee 9 EIERE 14
6. Created since Changed since Last Use Please enter here the date limitation of which the queries have been created changed or last used n days used Here you are able to filter how many days the to be displayed queries have been used Running time in sec With the use of this limitation you can determine the CPU Killer Queries After the simulation of the CPU capacity the value of the running time is to your availability which you can limit here in order to display for example all queries with a running time of more then 300 seconds Used files Here you can limit the display of queries which are defined with particular files by using 4 with OR terms combined fields Seite 30 Handbuch QueryOptimizer Used fields Here you can limit the display of queries which are defined with particular fields by using 4 with or terms combined fields Amount of Files Fields Through choosing from until you can limit the display of the queries on a basis of amount of used files fields selections sorting fields groupings assigned User variables and indexes 5 6 Choices As choice function a row of functions are to your availability for the menu points 5 and 6 whereas you can mark more then one query By pressing the F12 key the information of the next marked query will be displayed 9 6 1 Files By using selection D before a query you will be displayed the information of the used files verwendete Dateien anzeigen x011
7. In case of an Update please make sure that nobody is working with the QueryOptimizer or is active in the menu Insert the CD ROM into the according unit and type in the following command LODRUN DEV xXX For xxx please enter the name of your installation unit e g OPTO1 The command LODRUN is installing the objects on the iSeries You will be informed of the installation progress in the status line After the installation of the objects the following installation mask will appear QueryOptimizer Installation QRYOPTINS Make choice and press enter Language EN DE separate Data library NO YES Library for QRYOPT Command Name Determine Query Information NO YES Start Query Optimisation NO YES Update of Version Zeichenwert F3 Verlassen F4 Bedienerf F5 Aktualisieren F12 Abbrechen F13 Verwendung der Anzeige F24 Weitere Tasten Installation mask QueryOptimizer Handbuch QueryOptimizer Seite 9 Language Here you enter the language which you would like to use You can choose between DE German and EN English Separate File Library Enter here if the data and program objects should be memorised separately If YES is entered the library AGXFQYDTA XE is being opened and the Data bank administration data will be created within this library While carrying out QueryOptimizer AGXFQYDTA is being automatically pre adapted Library for QRYOPT Command Choice of library in which the start command
8. REN RE 31 BEIEN 28 Handbuch QueryOptimizer Seite 47 Demne ee WEE 11 Einschr nkung der bersicht aerea 26 EST EICHE EE 30 Fy m EE EEN T F10 Dateisort Usersort Abtragescort eee errar aerea ar ana ne arena re area er anne nana 7 MEN a re CN T FI2 Z te Le T PIF AA Le EE T Ska ug ee Een ET BEE 7 eS STEUER EE T F21 B tehlszelle EN T F22 Mult Delete JADE RAR DN UR SU O O ONU ND RA T F22 Weitere Angaben E 8 F23 Link Unlink Modus errar renan aaa rara arara arara aeee area 8 F3 Programm beenden EE T F4 Auswahl Pedenertubrung ceca eeeeeeeseeeeseeeeseeesseeseueeseeeeseeesseeseeeesueesseeesaeeess 7 eenegen T FOOT aree RR RR DDR E E SN EE EEE PR E EE 31 E7552 19 6 is e 30 GETQRYCPU O DON 13 19 Ehee Ulpe RECORRE RT A AR OR TD RR E NR PR E 32 ms o CNG ING PARAN RADAR een RE E O N E RUA DR PR A ER 13 Index l schen EEE 37 Index Info aktualisieren rrenan rare rara tnne nenen Anen AEAEE AEAEE nAn AAAA nanne nnna nanen 21 Indexinformationen aktualisieren ccc ccceceeeeeeeeeeeeesaeeeeeaueuseueaeeaueesaueaueueeaueeeaeeaeeuueusaueaueeeeenenas 38 INC ST OA e E 36 MOS EZ On E ee ee een ee eee ee eee 41 SIGA OR EEN 9 Intelligente Suchfunktionen eee eeree erre nenne nenne nnnnonnnnnnnnunnnnnnnnnnnnnnunnnnennnnennnnennnnenn 36 Intelligente Suchmechanismen anne nenne nenne nnnnnnnnnnnnne nenne nnnnnnnnnennnnennnnennnnnnnnnenn 26 DONT EN ee ee 17 19 20
9. group of queries in order to display queries which start with the provided string Description In the field description you are able to limit the display of queries by using the Zeichenfolge within the query description Valid values are Name All queries which have the provided string somewhere in the description should be displayed Name All queries which have the provided Zeichenfolge somewhere in the description should NOT be displayed Please note The inputs of the choose line Auswahizeilen are Additive which means if you are searching in field library by using DIR and in the field query by using HU you will be displayed all queries which start with HU of libraries with start with DIR This also applies for the field description for which an additional subtractive search is possible by which the search series AUS KUND ZU display all queries which have the terms AUS and KUND but not the Zeichenfolge ZU within the field Description Also a combination of library query and description can be used in order to limit the display 5 5 1 2 Sorting by File Name You can reach this view by using functioning key F10 either from the menu points 5 6 or 7 Handbuch QueryOptimizer Seite 27 Seite 28 Lib File Please enter here the name of a library in order to limit the extent of the to be displayed queries Valid values are Name The name of a library in your system in order to only display the qu
10. in order to avoid a parallel processing JOBD The job queue of the actual job description is being used INTER The job is being processed interactive on the screen Handbuch QueryOptimizer 4 4 Update Index Information In this screen you are updating the Index Information of the logical files created by the optimising process OPTI files You are able to call up this command by UPDOPT F4 You can display the out of here resulting information by entering CALL XQ40000 respectively by using function 8 of the main menu Index Informationen updaten UPDOPT Make choice press enter JOB Queue Name JOBD Update Index Information Job Queue Enter the name of the job queue over wich this job is supposed to be worked off Valid values are Name The name of an existing job queue in your system Please make sure that you are using a job queue which is assigned to a subsystem and if possible only allows one job at a time in order to avoid a parallel processing JOBD The job queue of the actual job description is being used INTER The job is being processed interactive on the screen Handbuch QueryOptimizer Seite 21 Diese Seite bleibt frei Seite 22 Handbuch QueryOptimizer 5 0 Sector Administration After you have incorporated your queries into the administration of the QueryOptimizer you are able to administrate the queries within this Menu Sector in a very comfortable and divers manner 5 1 S
11. of last usage number of days of use CPU capacity before and after the optimzation process as well as the complete running time of the query before and after the optimising 5 5 Intelligent Search Mechanism There are two methods for intelligent search to your availability 5 5 1 Limitation of the Overview In the sorting view the choose line is being offered with which you are able to limit the quantity of queries which ought to be displayed in a intelligent manner 5 5 1 1 Sorting by Query Name You can reach this view by using functioning key F10 either from the menu points 5 6 or 7 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance A Analyse 4 L schen Q Query auf Display A Bibliothek Name Beschreibung Choose line by Sorting by Query Name Library Please enter here the name of a library in order to limit the extent of the to be displayed queries Seite 26 Handbuch QueryOptimizer Valid values are Name The name of a library of your system in order to display only the queries out of this specific library Name The generic name of a group of libraries in order to display only the queries of libraries which start with the provided string Name Here you can limit the search for query names Valid values are Name The name of a query in your system in order to only display one query Name Generic name of a
12. under the file QRYOPTSQL under the query library SEU The SQL Statements are being created and displayed under the system editor SEU In these cases it is important that within the parameter job queue LNTER is being given named EDTF Enables the filing of the SQL Statements into a IFS file with following call up of the ASCII File Editors Here it is also important to give INTER within the parameter Job queue Handbuch QueryOptimizer Job Queue Please enter here the name of the job queue over which this job is supposed to be worked off Valid values are Name The name of an existing job queue within your system Please make sure that you are using a job queue which Is assigned to a Subsystem and which if possible only allows to run one job at a time in order to avoid a parallel processing JOBD The job queue of the actual job description is being used INTER The job is being processed inter active on the screen If a Screen display connected with command through SQL Extract SEU or EDTF the following setting needs to be chosen 4 2 Optimize Query While optimising the system creates Index files for the chosen queries which are responsible for acceleration of the queries The acceleration which is needed depends on the complexability of the query as well as the therefrom arising formation of intelligent logical files Similar as on the screen analysing Query the queries which are supposed to be o
13. 000 15 01 02 TESTDATEN QRYOUT1 11 11 44 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Asw Bibliothek Datei Alias TESTDATEN AUFTRAEGE TOL File display 9 6 2 Fields By using selection F before a query respectively with F8 in the display files the used fields of an query will be displayed verwendete Felder anzeigen XOLZ000 15 01 02 TESTDATEN QRYOUT1 11 12 24 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Asw lfd Feld Funktion Bezeichnung Lan Dez 1 KUNDE 7 2 AUFTRAG MIN AUFTRAG 10 3 AUFTRAG MAX AUFTRAG 10 4 AUFTRAG ANZAHL AUFTRAG 10 Field display 5 6 3 Selections By using selection S before a query respectively with F8 out of the display fields the selection criteria of the query will be displayed Handbuch QueryOptimizer Seite 31 Selektion anzeigen x013000 15 01 02 TESTDATEN QRYOUT1 11 17 01 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Asw Selektionsbegriff WHERE KUNDE EIGEN Selections 5 6 4 Sorting By using selection O before a query respectively with F8 out of the display Selections the sorting fields for the query will b
14. 1 48 Auswahl treffen und Eingabe dr cken 4 Index l schen L link Index U unlink Index A Name phys Datei Keyfelder n Tage benutzt S Bibliothek erstellt zuletzt am OPTIO00006 YKUBOTA ZLZBEK ZRENR 0 OPTIO00010 YKUBOTA ZLZBEK ZSTAT OPTIO00011 YKUBOTA ZLZBEP PSTAT OPTI000012 YKUBOTA ZLZBEP PRENR OPTIO00013 YKUBOTA ZLZBEK ZBELN OPTI000014 YKUBOTA ZLZBEP PSTAT PBETE PBELN OPTIO00015 YKUBOTA ZLZBEP PBELN F3 Verlassen F6 Indexinfo aktualisieren Fll Weitere Daten F12 Abbrechen F20 Druck F21 Befehlseingabe F22 Multi Delete F23 Unlink Modus Index Overview 5 7 1 Intelligent Search functions As customary for administration masks you can limit the size of the displayed index files by using the Choose line Seite 36 Handbuch QueryOptimizer Name Please enter here the name of an Index file in order to limit the size of the to be displayed query Valid values are Name The name of an Index file in your system in order to display only the index file Name Generic name of an group on Index files in order to display only the index files which start with the provided string Phys Files Key Fields Here you are able to limit the search for names of physical files respectively names of the key fields Valid values are Name All queries which have the provided string somewhere in the description should be displayed Name All queries which have the provided string somewhere in the description should NOT be displayed
15. Please note The inputs of the choose line are Additive which means if you are searching in field Name by using OPTIOO1 and in field phys File with HU all Index files which start with OPTI001 and have HU in the name of the phys files respectively contain key fields will be displayed 5 7 2 Choices Delete Index By using selection 4 before an Index you are able to permanently delete an logical file out of your system Unlink Index By using selection U before an Index the logical file can be deleted temporary in order to be re produced by using selection L for Link Index at a later time Please note This function has been integrated in order to avoid problems during the update of User data Some of the Update programs delete own logical files during software changes in order to be able to also delete the appropriate physical file If there are Index files existing of QueryOptimizer which are based on this file the user program of course is not aware of theses files and would possibly create an abort error This is the reason why you should discuss this with you Software House and if applicable delete the Index files with Unlink Handbuch QueryOptimizer Seite 37 Link Index By using selection L before an Index you can re generate temporary deleted Index files 5 7 3 Functioning Keys F6 Actualising Index Information By using this functioning key the Index information will be newly generated F11 Furt
16. QueryOptimizer Total acceleration and efficient management of iSeries queries User manual Pri i Sea Gei 4 Ia h 4 T g ute L d RK Do a H L I ail E 14 K 5 Bi i dE ki f L K E J G Contact EDV Beratung Andreas Goring Andreas Goring Keplerweg 19 76646 Bruchsal 49 7251 9895 12 49 7251 9895 13 info goering de ww qoering de Screens GOERING USA Randy Shaw 2883 CravenRidge Dr Atlanta GA 30319 Tel 404 759 1967 Email Irshaw aoering usa com Web http www goering usa com The screen shots displayed in this manual apply to the real layout up to a certain extend Data carrier If you are receiving an update during servicing we like to ask you to return the old data carrier to us Thank you Manual Version 1 21 printed on 21 March 2002 Manual refers to Software Release 1 21 Copyright 2002 EDV Beratung Andreas G ring Seite 2 Handbuch QueryOptimizer Table of contents 1 0 General Information Targets and Profit Terms of Use Technical Requirements 3 0 The menus of the QueryOp 3 1 The QueryOptimizer main 4 0 Sector Commands 4 1 Analize Query 4 2 Optimize Query 4 3 Determine CPU Capacity 4 4 Update Index Information 9 9 1 JOZ Searching with F15 5 6 Choices 5 6 1 i 5 6 2 Query on Display User classification U Adjust Options Run Query Run Query in background Display Infor
17. SPSW In case the password has not been included please request it by phone see page 2 for contact information Seite 10 Handbuch QueryOptimizer 2 3 Deinstallation In case you no longer wish to use QueryOptimizer on your system you must first close all activities with the QueryOptimizer In case you have entered the library name AGXFQY in your job description JOBD or in the system value system values for example QUSRLIBL it needs to be deleted from there Afterwards you log out of the system and back on as QSECOFR By using the following commands DLTLIB AGXFQY DLTLIB AGXFQYDTA DLTCMD QGPL QRYOPT all existing QueryOptimizer objects will be deleted The deletion is only possible if no job is using the library AGXFQY therefore exit menu prior Handbuch QueryOptimizer Seite 11 Diese Seite bleibt frei Seite 12 Handbuch QueryOptimizer 3 0 The menus of the QueryOptimizer 3 1 The QueryOptimizer main menu By using the following command after the successful installation of the program you can call up the QueryOptimizer menu QRYOPT The following menu will appear QRYOPT QueryOptimizer Menu Choices commands User view Analyse Query 9 Display user Query Optimise Query Determine Query CPU capacity Update Index Information Query Administration zz Other Sorting by Query name 99 Display program versions Sorting by File name Sorting by user Index Administration
18. U display all queries which have the terms AUS and KUND but not the string ZU within the field Description Also a combination of library query and description can be used in order to limit the display Handbuch QueryOptimizer Seite 29 5 5 2 Searching with F15 By using function key F15 you have extended search functions and criteria to your availability which are beyond the choose line function After pressing the function key the following search mask will appear Selektion verwalten XQ50000 15 01 02 11 09 01 Erstellt durch Erstellt ab 15 01 02 Geandert ab j 15 01 02 letzte Verwendung j 15 01 02 n Tage verwendet j 99 999 Laufzeit sec 9 999 999 Verwendete Dateien Verwendete Felder Anzahl Dateien Anzahl Felder Anzahl Selektionen Anzahl Sortierfelder Anzahl Gruppierungen Anzahl Benutzer Anzahl Variablen Anzahl Indizes CO OO OO OO OO CH F3 Verlassen F12 Abbrechen Search mask The search fields are combined with each other through AND terms which means through filling more fields you will achieve an Additive limitation For example through MEIER and number of files 3 to 9 displays only queries created by MEIER and consisting of only 3 to 9 files An exception here are the fields Used files and used fields which include each 4 with OR terms combined fields Created through Limit the display of the query further by entering the User ID of the employee which supposedly created the query
19. ach Datei Name XQ20000 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance A Analyse 4 L schen Q Query auf Display A Lib Datei Dateiname Qry Name Beschreibung AGXFOYDTA AGXFOYDTA AGXFOYDTA AGXFOYDTA QTEMP QTEMP OTEMP QTEMP XQKOPP XQKOPP XQKOPP XQO PTP XOLSTP XOLSTP XOLSTP XOLSTP XQ10000 XQ20000 2021000 XQ40000 XQ10000 XQ20000 XQ21000 XQ40000 Liste Liste Liste Liste Liste Liste Liste Liste fur fur fur f r f r f r f r f r Programm Programm Programm Programm Programm Programm Programm Programm XQ10000 XQ20000 XQ21000 XQ40000 XQ10000 XQ20000 XQ21000 XQ40000 TESTDATEN TESTDATEN YKUBOTA YKUBOTA ZLZBEK TESTL F3 Verlassen F6 Neu F10 Usersort F11 Sicht 2 F12 Abbrechen F15 Suchen F20 Liste drucken F21 Befehlseingabe F22 Multi Delete AUFTRAEGE TEST1 WEVCOOL1 OR YOUTI TESTIQRY TEST1 Sorting by Query File Names Please note that queries containing of more then 1 file will appear in this view several times which means once per file library The description of the possibilities of choices can be found further down in this chapter 5 3 Sorting by User The QueryOptimizer offers you the possibility to assign existing queries to users or groups This is being achieved through using menu point 5 Sorting by Query Name or 6 Sorting by File Name by entering the cho
20. but not the Zeichenfolge ZU within the field Description Handbuch QueryOptimizer Also a combination of library query and description can be used in order to limit the display 5 5 1 3 Sorting by User Name You can reach this view by using functioning key F10 either from the menu points 5 6 or 7 User Please enter here the name of an user or an user group in order to limit the extent of an to be displayed query Valid values are Name The name of an user in your system in order to display only the queries of that particular user Name Generic name of an group of user in order to display only queries which have been assigned to this particular group of user and which start with the provided string Description In the field description you can limit the display of the queries by using the string within the query description Valid values are Name All queries which have the provided string somewhere in the description should be displayed Name All queries which have the provided string somewhere in the description should NOT be displayed Please note The inputs of the choose lines are Additive which means if you are searching in field library by using DIR and in the field query by using HU you will be displayed all queries which start with HU of libraries with start with DIR This also applies for the field description for which an additional subtractive search is possible by which the search AUS KUND Z
21. by free definable names The defined user doesn t need to be a registered user on the iSeries The advantage is that you can assign queries to departments e g Purchasing Department Invoicing Department Sales Department This function has a command ready API which can be linked into your applications or menus For the first time you can display to your user an overview of only his queries 1 2 Terms of Use The software QueryOptimizer can only be used on the machine serial number model processor which has been defined on the ordering form A system change respectively an upgrade requires a new password and if applicable a licence fee Please request an written offer The licence of the QueryOptimizer is only bounded to the iSeries not to the quantity of users which are working with it Handbuch QueryOptimizer Seite 5 1 3 Technical Requirements Your system iSeries respectively AS 400 requires Operating System OS 400 from Version 4 Release 2 RISC and the IBM Licence program Query 400 1 4 Extension of Testing period If you have not been able to test the software extensively during the testing period please give us a call and we can extend the testing period over the phone 1 5 Comments Improvements to the manual This menu is a new edition past experience has shown that spelling mistakes as well as printing errors can occur or even that some sections are not described thoroughly enough out of your point of vie
22. can be deleted off the list with choice 4 By using key ED new users may be added 5 6 11 Performance By using choice P before a query the display of the Index Information as well as the performance data is being called up Index anzeigen x018000 15 01 02 TESTDATEN TEST1 11 27 57 Letzte Query Analyse sy 2002 01 08 13 45 55 Ergebnisse vor Opt nach Opt Beschleunigung CPU Belastung sec 100 80 25 00 effektive Laufzeit 00 10 00 00 00 50 1 100 00 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Aw Physische Datei S tze Indexdatei Keyfelder mehr F11 YKUBOTA ZLZBEK 100 QGPL OPTI000010 ZSTAT YKUBOTA ZLZBEP 100 QGPL OPTI000011 PSTAT YKUBOTA WEVC001 10 000 YKUBOTA WEVC002 WVADVN YKUBOTA ZLZBEP 100 QGPL OPTI000012 PRENR YKUBOTA ZLZBEK 100 QGPL OPTI000013 ZBELN YKUBOTA ZLZBEP 100 QGPL OPTI000014 PSTAT PBETE PBELN Weitere F5 Aktualisieren F6 Optimierung F17 Zeit Reset F18 CPU Last ermitteln Display Index Performance data Last Query Analyzis Here you will see the date and time of the last analysing run of this query CPU Capacity unoptimized If simulating a CPU Capacity before the optimising of an query has been made you see the original values which means CPU Time in seconds is being displayed here CPU Capacity optimized If simulating a CPU Capacity after the optimising of an query has bee
23. e displayed Sortierung anzeigen XQ14000 15 01 02 TESTDATEN QRYOUT1 11 17 34 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Asw lfd ASC DESC Feld Funktion 1 ASC KUNDE Sorting 5 6 5 Grouping By using selection choice G before a query respectively with F8 out of the display sorting the grouping fields will be displayed Gruppierungen anzeigen x015000 15 01 02 TESTDATEN QRYOUT1 11 18 41 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance analysieren Asw Lvl Feld Funktion 1 KUNDE Grouping 5 6 6 Variables By using selection V before a query the used Variables of a query will be displayed Variables are a possibility of adding parameter to a query from outside during the carrying out process The definition succeeds by using the mask select records while placing a parameter name leading into the column value after a field name and comparison operator e g KNDNUM EQ PARM1 This query can not be made interactively receptively over RUNQRY it must be passed on by using the command STRQMQRY and by giving the variables name and variables value Seite 32 Handbuch QueryOptimizer 9 6 7 RUNQRY By using selection R before a query this will be started interactively on the sc
24. e library is being chosen in which the through the optimising process automatically created Index files are being kept Valid values are QGPL The logical files OPTI are being accumulated in the library QGPL PF The logical files are being stored in the same libraries where also the matching physical files are being accumulated QUERY The logical files are being stored in the same libraries as the queries Job Queue Please enter here the name of the job queue over which this job is supposed to be worked off Valid values are Name The name of an existing job queue within your system Please make sure that you are using a job queue which is assigned to a Subsystem and which if possible only allows to run one job at a time in order to avoid a parallel processing JOBD The job queue of the actual job description is being used INTER The job is being processed inter active on the screen 4 3 Determine CPU Capacity This function serves the measurement of the CPU Capacity of analysed queries As explained in the previous command these queries are being simulated and the determined running time information is being placed into the data record of the respective query This command can also be called up while entering GETQRYCPU F4 Query CPU Belastung ermitteln GETQRYCPU Auswahl eingeben und Eingabetaste dr cken ORY Name generisch ALL Bibliothek CURLIB LIBL ALL JOB Warteschlange JOBD De
25. endently from each other Selection Mask Here the user can define if the Query Selection screen is being displayed for changing selection criteria during the execution of an query or not The display of the Selection masks equals the execution of an query with parameter RCDSLT YES Seite 40 Handbuch QueryOptimizer Protocol Type Here the user can define whereto the output of the query should proceed Here the user can define whereto the output of the query should proceed Valid values are Q B The selection as defined in the query is being used The print out occurs on the screen The print out takes place on a printer which needs to be defined Therefore a printer free of choice can be used or the standard value PRINT will be defined The print out occurs into a file which needs to be named Therefore File Name Library Name and File selection Q as defined N new file R replace file M new partial file T replace partial file or A to be added to a partial file need to be given 6 1 2 Run Query By using selection R before a query this will be started interactively Changes which have been made under User setting will be taken into consideration 6 1 3 Run Query in background By using selection X prior a query it will be passed on to the batch processing Changes which have been made under User Settings will be taken in consideration 6 1 4 Display Information By using key F11 the addi
26. ensure that all on the system existing Queries are being taken over into the administration of the QueryOptimizer Comment On the Query Definition and the existing Objects QRYDFN themselves nothing is being changed or exchanged through the take over process into the administration Handbuch QueryOptimizer Seite 15 Seite 16 Library Please enter here the library name s in which the Queries are supposed to be analysed Valid values are Name The name of a library which queries are to be analysed LIBL The queries of all libraries listed in the library list of the active job are being analysed CURLI The queries of the actual library of the job are being analysed ALL All Libraries are being searched by the in the parameter QRY named queries Selection With the help of this parameter you control if all or only one query is being taken into the analysis Valid values are ALL All given queries within the parameter QRY and Library are being analysed NEW For this Analyzis only the new created queries since the last run are being taken into consideration Please note The use of the option ALL is being recommended on a regular basis That way it is being assured that deleted queries also disappear out of the administration SQL Extract This parameter gives you the possibility to create SQL Anweisungen along to the queries Valid values are YES The SQL Statements of the analysed query are being saved
27. eries out of this library Name Generic name of a group of libraries in order to display queries which are stored in libraries which start with the provided string File Name Here you can limit the search for file names Please note that queries which have the same file names but which have been used in different libraries may appear several times Valid values are Name The name of an file of your system in order to only display the queries in which this particular file was used Name Generic name of an group of queries in order to only display the queries in which files starting with the provided string had been used Description In the field description you can limit the display of the queries by using the string within the query description Valid values are Name All queries which have the provided string somewhere in the description should be displayed Name All queries which have the provided string somewhere in the description should NOT be displayed Please note The inputs of the choose line Auswahlzeilen are Additive which means if you are searching in field library by using DIR and in the field query by using HU you will be displayed all queries which start with HU of libraries with start with DIR This also applies for the field description for which an additional subtractive search is possible by which the search series AUS KUND ZU display all queries which have the terms AUS and KUND
28. ext With the help of this function key the description line is being identified with a query in order to unlock or lock it for alterations F20 Print list D Prints a list of all actual chosen queries F21 Command line Links up a command line for entering an OS 400 command F22 Multi Delete Deletes the queries of the actual choices out of the QueryOptimizer s overview Handbuch QueryOptimizer Seite 7 F23 Further Details If there are more options within the selection line as displayed on the screen you can have the additional ones displayed by using F23 F23 Link Unlink Mode Displays en and excludes logical files for Service and Update purposes F24 Further Keys If there are more functioning keys within the functioning key line as displayed on the screen you can have the additional ones displayed by using F24 1 7 Quick Entry For the impatient and the system familiar users we recommend the quick entrance with e Installation of the Software as described in chapter 2 e Enter command QRYOPT Seite 8 Handbuch QueryOptimizer 2 0 Installation The installation of QueryOptimizer requires the installation of the Software on the iSeries there is no configuration of the Software necessary During an upgrade the installation program takes existing data into consideration Even the passwords are being maintained 2 1 Software Installation Please log on as QSECOFR on the iSeries Update
29. her Information Herewith further information for each query is being displayed in a second line such as library name creation date and date of last use F20 Print Herewith you print out a report of the generated logical files F22 Multi Delete By using the functioning line limit the display of the Index files to the required extend and delete all selected at once Index files by using F22 After pressing key F22 a confirmation receipt is being displayed prior to the final deleting process Hinweis Diese Aktion l scht alle Index Dateien fur die aktuelle Auswahl Bitte bestatigen Sie dies durch die Taste F10 Sind Sie versehentlich hier gelandet brechen Sie den Vorgang mit F12 ab F10 Best tigung F12 Abbruch Confirmation of Deletion F10 Confirmation In order to avoid an deletion by accident the FIO key function has been activated as deletion confirmation instead of the enter key F23 Unlink Mode Herewith you only view Index files which have an active status and have not been temporarily deleted by the Unlink F23 Link Mode Herewith you only view Index files which have an Unlink status meaning they have been temporarily deleted F23 Standard Mode Herewith you view all Index files either active or in Unlink status The U status at the right site of the screen displays if the file is in Unlink status Seite 38 Handbuch QueryOptimizer Handbuch QueryOptimizer Seite 39 6 0 Sector User view
30. his function have been described earlier in this manual 5 6 13 Delete By using choice 4 before a query this query can be deleted After pressing the enter key a confirmation message will be displayed prior to the final deletion L schauswahl angeben QueryOptimizer Eintr ge entfernen J Query Objekte vom System entfernen N Bitte best tigen Sie dies durch die Taste F10 Sind Sie versehentlich hier gelandet brechen Sie den Vorgang mit F12 ab F10 Best tigung F12 Abbruch ELLE LILLIFEE Confirmation of Deletion WEP Bi EPPO OS S ES m Handbuch QueryOptimizer Seite 35 Delete QueryOptimizer Entries Here the information for queries out of the QueryOptimizer overview is being deleted This choice will be activated under key J and this function can not be assigned to a different key Delete Query Objects from the system By using this option a solution of the physical queries beyond the QueryOptimizer can be made If the standardised parameter marked with N is being changed to J all chosen queries will be deleted physically F10 Confirmation In order to avoid an deletion by accident the F10 key function has been activated as deletion confirmation instead of the enter key 5 7 Index Management In Index Management you will receive an overview over the Index files which have been generated due to the Performance optimzation Index Verwaltung XO40000 15 01 02 Normalmodus 11 3
31. ice U 15 01 02 10 56 40 Sortierung nach Benutzer XQ21000 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzerzuordnung E Einstellungen 4 Zuordnung aufheben A User Qry Lib Qry Name Beschreibung GOERING AGXFQY XQ21000 Liste f r Programm XQ21000 F12 Abbrechen F15 Suchen F22 Multi Delete F3 Verlassen F6 Neu F20 Liste drucken F10 Orys rt Fll Sicht 2 F21 Befehlseingabe Sorting by User Classification The description of the possibilities of choices can be found further down in this chapter Seite 24 Handbuch QueryOptimizer 5 4 Alternative Views All Administrator displays have functioning key F 11 activated which displays alternative views of the queries as an further information option already within the overview Sortierung nach Query Name Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY P Performance A Analyse A L schen Q Query auf Display U Benutzer V Variablen A Bibliothek Name F3 Verlassen F6 Neu F10 Dateisort F11 Sicht 3 F12 Abbrechen Fl7 Text ffnen F21 Befehlseingabe AGXFQY AGXFQY AGXFOY AGXFOY QSYS QSYS XQ10000 XQ20000 XQ21000 XQ40000 QSECAF QSECCA F20 Liste drucken Beschreibung Infos zur Querydefinition Liste f r Programm D 2 F 7 S 2 Liste f r Programm D 2 Pes S 2 Liste f r Programm DEZ F 8 S 2
32. mation Handbuch QueryOptimizer Seite 3 7 0 SECLOr MISC TE EE 43 Seite 4 Handbuch QueryOptimizer 1 0 General Information 1 1 Targets and Profit With QueryOptimizer you are receiving a useful tool which enables you to efficiently manage and massively accelerate you queries out of Query 400 In order to be able to get the optimal use out of QueryOptimizer your first step should be the take over of your already existing queries into the management of the QueryOptimizer By using the intelligent choices and search functions you can get a overview of you queries There are two functions to be emphasised Minimize the options of the displayed queries successively by giving generic details of the directory name file name query name as well as the description text of the query Use the search function which enables you to effectively search by using extensive criterions as e g author date amount of files fields etc when last used periods and others Especially the last two named criterions make it easy on clearance work Either out of the Management or over the deductive menu points and commands you can identify the long running jobs and CPU Killers under the queries and optimize them afterwards Accelerations by hundreds folds have been achieved at Beta customers Not a minor important function is the classification of queries to users and user groups It should be pointed out that the classification happens
33. n made you see the newly determined comparison values which means CPU Time in seconds is being displayed here GAME means that no changes of the running time have occurred Acceleration Here you will be displayed the factor of how many per cent the speed has managed to be increased Effective running time unoptimized If you make a running time analysis before the optimising of an query has been made you see the original values which means the effective running time in hours minutes seconds CPU capacity optimized If you make a running time analysis after the optimising of an query has been made you see the newly determined comparison values which means Seite 34 Handbuch QueryOptimizer the effective running time in hours minutes seconds SAME means that no changes of the running time has occurred here Acceleration Here you will be displayed the factor of how many per cent the speed has managed to be increased improved 9 6 11 1 Functioning Keys F6 Optimising Here you can start the optimising out of the screen which means if applicable the creation of logical files F17 Time reset By using this Functioning key the measured performance data is being set back to 0 F18 Determine CPU Capacity Here you can determine the CPU Capacity of the just displayed query 5 6 12 Analyzis By using choice A before a query start command QRYOPTMDB in order to newly analysed a query The parameter for t
34. n QRYOPTINS The required files are no longer being shifted into the file library they are being copied Therefore a New Installation with blank data can be repeated at any time e Correction of missing objects for the password issuing respectively password checking Handbuch QueryOptimizer Seite 45 Diese Seite bleibt frei Seite 46 Handbuch QueryOptimizer 9 0 Index AFTER een reiner 18 SAUTO EEN 40 BOT WEE 18 I LE WEEN 16 18 20 EDIF odiei E E 16 51 REENEN 17 19 20 21 BEE 16 18 20 NONIE EEN 18 EE 19 TUE EE 19 Administration aaa aaa aaa anne nenn nn nennen anne nennen nenn 23 Alternative Sichtweise nn en nn nenn ann nennen ann nennen anne nn aaa aaa nennen en 25 PDAS raios ce ct ee 35 PIUS UU EE 16 SE 13 Benutzer Query anzeigen 40 Benutzersicht RAP RR O OR nn ana ee 40 BLS AULA e EEN 14 BERULZETZ UOTON LUNG NEE 33 BEIIEL SAUSGAH SATT ee ee an ee anreisen 41 BS ANS NN E 27 Bibliothek f r Index 19 Bibliothek fur QRYOPT Befehl aaa nennen ann nennen nn 10 Bibliothek mit Altdaten casaco ais pira dentina de aa on etn ane an nee ii aranana nanena 10 BS nl Tu TEE 2 6 CALL XOA0000 cee eecccceecccceeeccececececssceecenececseceecenaceesenaeeeseneeesenaeeeseeeesesaceeeeaeeeceeaeeeeeaneeseteesseanersaees 21 CPU BElaswung SiC NA een er enter een 18 CRU A e H Ca EE 35 CPU LaSLODERNIEN esse nee ernennen ee nee een 34 CRU Las UNODC einen seen ee 34 CRTOFTORT eC Lee ae ee een ee 13
35. of the QueryOptimizer QRYOPT is being memorised Under normal circumstances the library QGPL is a component of the library list of all users and therefore useful as default value Determine Query Information If YES is entered here after successful installation all the information of the existing queries are being taken over into the administration of the QueryOptimizer This step is being recommended to do be done separately after the installation process Start Query Optimising If YES is entered here all existing queries will be optimized after the successful installation Mandatory for the optimising process is First installation then optimization Therefore do this step after the installation process and the analysis Update of Versions If QueryOptimizer had already been installed on the machine the existing libraries in AGXFQYOLD respectively AGXFQYDOLD have been renamed Out of this the version number is automatically being determined If despite of the existing installation the data files have not been carried over or if it happens to be a new installation you can enter the special value NONE Library with old data Here you can find the name of the library out of which the data with already analysed and optimized queries is being taken 2 2 Password After the first installation the included provided passwords must be entered into the system according to the instructions which you find in the letter command IN
36. orting by Query Name By using menu point 5 Sorting by query name you receive an overview of all queries which you have incorporated into the Administration of the QueryOptimizer This display is without library limit which means you have all the queries of your system in one view Sortierung nach Query Name XQ10000 15 01 02 10 53 52 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance A Analyse 4 L schen Q Query auf Display A Bibliothek Name Beschreibung AGXFQY XQ10000 Liste f r Programm XQ10000 AGXFQY XQ20000 Liste f r Programm XQ20000 AGXFOY XQ21000 Liste f r Programm XQ21000 AGXFQY XQ40000 Liste f r Programm XQ40000 TESTDATEN QRYOUT1 TESTDATEN TESTI TESTDATEN TESTIORY F3 Verlassen F6 Neu F10 Dateisort Fi11 Sicht 2 F12 Abbrechen F15 Suchen Fl7 Text ffnen F20 Liste drucken F21 Befehlseingabe F22 Multi Delete Sorting by Query Name From this Central program you control and administrate your queries You will find the description of the search and choice functions in this chapter further down below 5 2 Sorting by File Name Menu point 6 Sorting by file name will display the sorting of the queries by file name The screen content is mainly in accordance with the representation of the previously introduced menu Sorting by Query Name Handbuch QueryOptimizer Seite 23 15 01 02 10 55 58 Sortierung n
37. owing the choices of the QueryOptimizer Menu are being described more thoroughly Seite 14 Handbuch QueryOptimizer 4 0 Sector Commands With the help of Command you are so to say getting the queries prepared for real usage You are taken over the on you system existing Queries into the administration of the QueryOptimizer Herewith you begin with the analysis of the existing systems with the menu point 1 of the main menu 4 1 Analize Query After calling up the first menu the following screen will appear QueryOptimizer Datacollector QRYOPTMDB Make choice and press enter ORY Name Name generic ALL Library Name CURLIB LIBL ALL Choice SAIL NEW SQL Extrakt NO YES SEU EDTF JOB queue Name JOBD Analize Query In this screen mask or as an alternative by using the command QRYOPTMDB F4 you decide which Queries are being taken over into the administration of the QueryOptimizer QRY Name Here choose the queries which should be taken over into the administration of the QueryOptimizer Valid values are Name By giving the name of an single query only a single query will be analysed Name By giving a generic name all queries beginning with this particular name part will be analysed ALL If you wish to analyse all queries of one library or all queries of the system choose ALL For the first run the use of ALL for Query Name and Library is being suggested this will
38. ptimized are being specified here Optim Query Index erstellen CRTOPTORY Auswahl eingeben und Eingabetaste dr cken ORY Name generisch ALL Bibliothek CURLIB LIBL ALL CPU Belastung ermitteln AFTER BOTH Bibl f r Index PF QUERY JOB Warteschlange JOBD Optimize Query QRY Name Please choose the queries which are supposed to be optimized Consider Bear in mind that through giving the information ALL in QRY Name and library all on your system existing query are being optimized This can lead to long waiting periods as well as to a high CPU capacity Furthermore there are logical files being created in order to optimize queries Depending on your system surrounding you need to decide if the advantage of a quicker query makes up for the disadvantage of higher maintaining effort of the logical files during the continuation of the files do to for each writing operation of an physical files the logical files need to be updated as well Handbuch QueryOptimizer Seite 17 Seite 18 Valid values are Name By giving the name of an single query only a single query will be analysed Name By giving a generic name all queries beginning with this particular name part will be analysed ALL If you wish to analyse all queries of one library or all queries of the system choose ALL Library Please enter here the library name s in which the Queries are supposed to be analysed Valid
39. reen 9 6 8 SBMQRY By using selection X before a query this will be passed on to and carried out by the pile processing For this the command submit job SBMJOB will be linked up eingeblendet in which you can change the job description job queue etc 5 6 9 Query on Display Independent of the set output definition of the query it will be carried out and the result is being displayed on the screen if selection Q is being entered before the query process 5 6 10 User classification By using selection U before a query you can assign these queries to users which are entitled to carry them out After the carry out process of this function each user can start the command QRYOPTUSR with his user ID and will only be able to view queries for which he has been entitled to Extensive CL Programs and own user menus are more or less belong to the past Benutzer definieren x017000 15 01 02 TESTDATEN TEST1 11 22 28 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY 4 Benutzer l schen V Variablen P Performance analysieren E Einstellungen Asw Benutzer S Ausf hrungsoptionen andern mit E ANDI J Drucker PRINT HUGO N Ausgabe auf Bildschirm NENA N Datei DATEN OUTFILE FIRST Option lt Query Definition F3 Verlassen F5 Aktualisieren F6 Erfassen F12 Abbrechen Define User Handbuch QueryOptimizer Seite 33 If a user should no longer be entitled for the queries he
40. stellt XQ10000 06 04 01 XQ20000 07 04 01 XQ21000 07 04 01 XQ40000 22 04 01 25 01 96 G 1 G 1 2010000 15 01 02 11 00 13 U 1 F15 Suchen F22 Multi Delete 2010000 15 01 02 11 00 45 Ge ndert Benutzt Tage 28 12 01 00 00 00 28 12 01 00 00 00 25 09 01 00 00 00 12 09 01 00 00 00 03 08 98 00 00 00 25 01 96 03 08 98 00 00 00 XQ10000 XQ20000 XQ21000 XQ40000 Beschleunigung F15 Suchen F22 Multi Delete AOLOGOO 15 01 02 11 01 13 o F15 Suchen F22 Multi Delete Seite 25 Sortierung nach Query Name x0100009 15 01 02 11 04 02 Auswahl treffen und Eingabe dr cken D Dateien F Felder S Selektion O Sortierung G Gruppierung R RUNQRY X SBMQRY U Benutzer V Variablen P Performance A Analyse 4 L schen Q Query auf Display A Bibliothek Name Beschreibung Laufzeit vorher nachher Beschleunigung AGXFQY XQ10000 Liste f r Programm XQ10000 AGXFQY XQ20000 Liste f r Programm XQ20000 AGXFOY XQ21000 Liste f r Programm XQ21000 AGXFQY XQ40000 Liste f r Programm XQ40000 QSYS QSECAF OS TE QSECCA F3 Verlassen F6 Neu F10 Dateisort Fl1l Sicht 1 F12 Abbrechen F15 Suchen Fl7 Text ffnen F20 Liste drucken F21 Befehlseingabe F22 Multi Delete Alternative View Here you will be displayed an overview for each query of the number of files fields Selection features marks etc Information about query type User ID of the creator date of creation date of last change date
41. termine CPU Time of Queries Handbuch QueryOptimizer Seite 19 Seite 20 QRY Name Please choose the queries for which you like to simulate a CPU capacity Comment Bear in mind that through giving the information ALL in QRY Name and library all on your system existing queries are being simulated This can lead to long waiting periods as well as to a high CPU capacity Valid values are Name By giving the name of an single query only a single query will be simulated Name By giving a generic name all queries beginning with this particular name part will be simulated ALL If you wish to simulate all queries of one library respectively all queries of the system choose ALL Library Please enter here the name of the library s of which the queries are to be simulated Valid values are Name The name of the library of which the query is to be simulated LIBL The queries of all libraries on the library list of the actual job are being simulated CURLIB The queries of the actual library of the job are being simulated ALL All libraries are being searched for the named queries as given in the parameter QRY Name Job Queue Enter the name of the job queue over which this job is supposed to be worked off Valid values are Name The name of an existing job queue in your system Please make sure that you are using a job queue which is assigned to a subsystem and if possible only allows one job at a time
42. tional set User Options can be displayed for each query in a second line Handbuch QueryOptimizer Seite 41 Diese Seite bleibt frei Seite 42 Handbuch QueryOptimizer 7 0 Sector Misc Via menu point 99 Display program version the actual installed version of the QueryOptimizer is being displayed to you in the Status line Handbuch QueryOptimizer Seite 43 Diese Seite bleibt frei Seite 44 Handbuch QueryOptimizer 8 0 Release notes Improvements 8 1 Version 1 20 e Additionally to the CPU time actual required computer time during the execution of the query the effective running time from call up until completion of the query is being displayed as well e The structure of the logical files has been switched from SQL to CRTLF in order to also be of assistance to customers without SQL e The display function F11 has been expanded in order to be able to display more information within the Overview e The Switch option F10 enables the change over between Query File and User sorting without having to leave the program e During the Optimising of queries the parameter optimize CPU capacity has been pre occupied with BOTH in order to be able to directly compare the running time before and after the optimzation e During deletion of queries it is being distinguished between deletion out of the overview and deletion of the physical query 8 2 Version 1 21 e Correction of the Installation applicatio
43. values are Name The name of a library which queries are to be analysed LIBL The queries of all libraries listed in the library list of the active job are being analysed CURLIB The queries of the actual library of the job are being analysed ALL All Libraries are being searched by the in the parameter QRY named queries Determine Query CPU Capacity One aspect of the optimising process is the improvement of the terms periods of queries This term period is being measured by the simulation of the query and as information adapted into the analysed queries Here you can give details on how the determination of the running time should take place Valid values are NONE No determination of the CPU capacity takes place AFTER After successful optimzation the CPU Capacity is being determined and the information is being placed into data record of the query BOTH By choosing this function you can either start a simulation run prior or after the optimization process and are able to see directly the performance improvement in the overview of the queries Comment The CPU Capacity is being determined through the carry out process of the referred query Do you have so called long running jobs in your system the Handbuch QueryOptimizer system will be particularly through the BOTH function heavily strained Postpone such actions into the more quiet evening hours of your business day Library for Index Here th
44. w If you find that improvements or additions would be of use please correct the pages of the manual accordingly and send them to us Actuality We are trying to be as up to date as possible It could happen though that the manual is not in accordance with the latest Software Level In this case you will always find the most actual information under document Neuerungen Version x xx which is enclosed with the respective data carrier Screens The iSeries masks displayed in this manual only correspond to the real layout up to a certain extend Seite 6 Handbuch QueryOptimizer 1 6 Functioning keys The function keys used in the program correspond to the SAA Standard In order to avoid repeating the most common used keys are described below F1 Help key Shows the online user help for the actual mask F3 Escape program Exits the actual program and displays the menu F4 Selection User guide Displays all possible entries within this field F5 Updating Updates the display with the newest data F6 F7 F8 Various functions depending on the single Teilmasken F9 Displays all parameter of the command F10 File sort User sort Query sort Displays query analogous of the menu points 5 6 7 F11 More Information Display of detailed information depending on the single Teilmasken F12 Back Jumps back one step within the program F15 Search Choice of extensive criterions F17 Unlock lock t

QueryOptimizer

Contents

Download Pdf Manuals

Related Search

Related Contents