An administrator determines that the system slows down whenever a specific query is run and that IDX- FILEA displays when a WRKACTJOB is performed. Which tool or command can assist the administrator in determining what is causing this to occur?
A. ANZQRY
B. ANZIDX
C. System i Navigator Index Adviser
D. IBM Systems Director Database Manager
The DNS server was updated with the new IP address of a remote system. Whenever the administrator tries to connect to the remote system from the local system, they are unable to do so. Which action will resolve this issue with the least disruption to the network?
A. Remove the host route for the old IP address.
B. Run the CHGTCPDMN command to clear DNS cache.
C. Clear the APP cache on the administrator's PC.
D. Add a route with *NEXTHOP specified as the remote system name.
Which journaling capability was added in IBM i 7.1?
A. End journaling can be done while a journaled file is in use.
B. Journals larger than 1TB can have remote journals attached to them while in use.
C. Remote journals are automatically compared and verified during suspend and resume operations.
D. When starting journaling of the physical file, all logical files will automatically have their access paths set for SQL optimization.
A customer determines that run time of a weekly reporting job has begun to increase rapidly over the past several months. Examination of the file shows only normal size growth of less than 1%.
The entire file is read sequentially by key and is heavily I/O blocked for performance.
What should the administrator do to reduce run-time for the reporting job?
A. Override the file to SEQONLY(*YES).
B. Reorganize the file to remove deleted records.
C. Reorganize the rile in the sequence of the key field.
D. Increase the job's time slice and enable expert cache in the memory pool in which the job runs.
An IBM i 7.1 partition has a system ASP that has a combination of Solid State Drive (SSD) units and Hard Disk Drive (HDD) units. The system administrator needs to permanently migrate the logical files that are randomly accessed by the application jobs to the SSDs.
What is the appropriate method for identifying the most randomly accessed logical and physical files?
A. Query the table QSYS2/SYSIXSTAT for files with logical reads greater than U and sequence in descending order.
B. Use WRKACTJOB command to identify the application jobs.For each job, select option 5=Work with, then 14.Display open files, if active, than press Fl 1.
C. From Performance Tools, generate a system report to an output file.Query the output file for logical files with random reads greater than U and sort in descending order.
D. Trace the accessed file data using the TRCASPBAL SET(*ON) ASP(l) command.Print the report with the command PRTTRCRPTTYPE (*FILE) QRDER(*DESC), and look for Random Reads/sec.
An application uses commitment control and has the following attributes: Physical files in library: APDATA Logical files in library: APLE Journals in library: APJRN Journal receivers in APJRNPCV
Application objects must be saved at a transaction boundary.
Which parameter of the SAVLIB command of the following supports this requirement?
A. ACCPTH(*YES)
B. SAVACT(*LIB)
C. TNSBND(*YES)
D. SAVACT(*SYNCLIB)
A customer is developing an application that needs to be deployed to IBM i servers globally. The administrator created one user named APPOWNER to own all objects in the application. What are the appropriate security characteristics for the application?
A. This owner has no special authority.Users adopt this profiles authority when running the application.Developers log on as this profile to maintain the application.
B. This owner has no special authority and password *NONE.Authorization List, APPAUTL, is created and all objects are added to it.Developers are added to APPAUTL with *ALL authority.
C. This owner has no special authority and password *NONEUsers adopt this profiles authority when running the application.Developers are members of this profile's group with QWNER(*GRPPRE)
D. This owner has no special authority and password *NONE.List named APPAUTL is created and all objects are added to it.Users are added to APPAUTL with *USE.Developers are added to APPAUTL with *ALL Authority.
An administrator is upgrading 5 partitions on a single system to a new IBM i release.
The IBM i partitions share a tape library configured with one drive per partition. There is one DVD drive on the system shared by the all the partitions.
The maintenance window is long enough to upgrade at most one partition using DVD media. Which approach allows the administrator to complete all the upgrades within the maintenance window?
A. Build an image catalog with the distribution media, and copy to all partitions.Install each partition from its image catalog image.
B. Build an image catalog on a Linux PC, and share it with NES to all partitions.Concurrently update all the partitions using network install to the virtualized image catalog.
C. Build an image catalog with the distribution media on one partition.Save the directory with the DVD images to tapes so there is one tape for each partition. Use an alternate IPL device to install from the tapes.
D. Concurrently IPL all partitions in "D" mode to the DVD drive in shared mode.When all the partitions complete using one DVD and prompt for the next one, insert the next DVD in the drive and respond to the prompts.
After installation of Licensed internal code (LIC) and the base operating system, the administrator IPLs with "B Normal". After the IPL completes, the administrator received the following message when attempting to complete the installation:
CPF3D8F: Cannot install library QGPL.
What is wrong and what must the administrator do to continue the installation?
A. Subsystems other than the controlling subsystem are running.End all subsystems and start installing the licensed programs again.
B. The IPL partition settings were not correct.Change the settings to "A Manual", IPL the system again, then start installing the licensed programs.
C. The IPL should not have been run until the installation of licensed programs was successfully completed. Start the process again from the beginning.
D. The option to install the library QGPL was skipped during installation of the base operating system. Run the installation process again, install the QGPL library, and then continue the installation.
A save file named SAVE in library QGPL contains only .bin files saved from an IFS directory.
Assuming the necessary parent directories are present, how can the administrator restore the .bin files to a new directory named DIR 1?
A. Restore the .bin files using the RSTSAVFDATA FILE (QGPL/SAVE) OBJ((`*ALL' INCLUDE `/DIR1')
B. Restore the .bin files using the command RST DEV(`/QSYS.LIB/QGPL.LIB/SAVE.FILE') OBJ((`*ALL' `INCLUDE `/DIR')).
C. Use the DSPSAVF command to rind out the OLDDIRECTORY directory name, then restore the bin files using the command RST DEV(`/QSYS.LIB/QGPL.LIB/SAVE.FILE') OBJ((`/OLDDIRECTORY' INCLUDE `/DIR1')).
D. Change the current directory to DIR1, use the DSPSAVF command to find out the OLDDIRECTORY directory name, then restore the .bin files using the command RST DEV(`/QSYS.LIB/QGPL.LIB/ SAVE.FILE') QBJ(`/OLDDIRECTORY' INCLUDE)).
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C4040-129 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.