Frequently Asked Questions
* NEW *
Free AS400 App Monitoring
Free 1 Year Pro License Offer
00149 - mb software (977
)
00196 - Why is my CPU only 20% consumed and my batch job still runs for 5 hours? (300
)
00037 - How do I install the software? (300
)
00059 - How do I manually send performance data? (262
)
00065 - Analyzing Long Running Batch Jobs (245
)
00041 - How do I host data in a web browser on a local server? (230
)
00098 - Running Workload Performance Series v6.0 on V5R4M5 (221
)
00208 - How do we identify unused indexes? (187
)
00104 - qtemp library cpu time (187
)
00069 - How do I run the Query Optimizer data collector? (179
)
00087 - From iSeries performance advisor I can see reports of disk arm imbalance in certain days. (177
)
00047 - How should I go about finding out what is consuming the most resources on my system? (175
)
00081 - How do the free quarterly application performance reviews work? (164
)
00063 - What can we do about SQL and Queries that are killing the system? (164
)
00045 - How much impact will this software have on my iSeries? (138
)
00246 - What are some of the most common culprits making batch jobs run long? (131
)
00210 - How can I force an SQL request to use an existing logical file or index? (129
)
00272 - Is it better to use SQL or CRTLF to build new indexes? (125
)
00229 - Why should I care about the IFS? (123
)
00073 - What is the difference between an Access Plan and an Access Path? (123
)
00067 - How do I manually apply software updates? (121
)
00153 - Why do some jobs always generate a joblog? (119
)
00192 - logical files built using DDS that have select/omit (115
)
00077 - Why does the WORKNAV job appear to be consuming a lot of CPU? (113
)
00075 - What is ODP - Open Data Path in Query Optimizer? (111
)
00251 - How do we identify the transaction files that would most benefit from these techniques? (108
)
00200 - What can be done to improve performance besides buying more hardware? (105
)
00206 - How do we identify duplicate indexes? (103
)
00049 - We use purchased software without any source code. How can we improve performance? (101
)
00083 - How do we re-engage with MB Software after lapsing on Annual Software Maintenance? (93
)
00055 - We are upgrading the operating system to V6R1M0. Any requirements for the software? (93
)
00231 - How do I get an IFS folder saved on one system and restored onto another? (89
)
00265 - Is "save while active" safe? (85
)
00096 - I still have not had any success getting reports via email from the iSeries. (83
)
00091 - Disk Navigator data collection takes a long time on our system. (83
)
00085 - When should I create an SQL index versus a logical file with DDS and CRTLF command? (83
)
00234 - What is the difference between temporary storage and a job's QTEMP library? (81
)
00267 - What about our full system save where all batch subsystems are ended? (79
)
00257 - How do we make our SQL perform less I/O? (79
)
00129 - Average Interactive Response Time (77
)
00089 - Does your software analyze system software? (77
)
00255 - What types of job queues should we create? (76
)
00053 - We are upgrading hardware and operating system version. New license keys needed? (75
)
00307 - remind me where is it we recommend indexes (73
)
00300 - Will running DISKNAV create a database that will grow quite large over time? (73
)
00276 - Why is our iSeries server not providing equivalent SQL performance to other platforms? (73
)
00043 - How do I manually install if our firewall blocks WORKPERF.EXE from working? (73
)
00261 - Can the I/O performance of an RPG application be improved without a complete rewrite? (72
)
00204 - How can we reduce the journal transactions without having control over the application? (72
)
00079 - What do I look for to improve SQL performance? (71
)
00240 - How do we find existing trigger programs and see how they are affecting performance? (70
)
00293 - Prep for Conference Call (68
)
00269 - Can I improve SQL performance without having access to source code? (68
)
00202 - Does "Remote Journaling" reduce the performance impact on the system? (67
)
00051 - How do I log into the secured area of the web site? (67
)
00244 - What can be done besides building a new index or changing the SQL? (66
)
00123 - XX05591 Access Plan Rebuilds (66
)
00198 - What types of system bottlenecks should we monitor on a regular basis? (65
)
00106 - increase Total Allocated size QTEMP (64
)
00274 - What is the difference between an Access Plan and an Access Path? (63
)
00263 - What else can be done to improve the duration of a backup procedure? (62
)
00242 - Why does all of this matter and how is my custom code getting executed? (62
)
00061 - Manual FTP of Save File (62
)
00057 - Need to transfer software to another system. Any additional license or maintenance fees? (61
)
00259 - Journal receivers on a 2nd ASP. What more can we do to improve journal performance? (60
)
00249 - How can I do any of this with purchased software and no access to source code? (60
)
00253 - How do I create a new job queue? (59
)
00194 - SQL buffer size of the DDS logical is only 8192 bytes (58
)
00331 - Does trial version contain full version of modules and functionality or limited capabilities? (57
)
00108 - what should joblog parms be (57
)
00107 - java qtemp sample (55
)
00105 - software to create a job queue is called (55
)
00012 - (18
)