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