
	Home > Ask the AS/400 Experts > iSeries PC/Windows Connectivity Questions & Answers > Why is my job taking twice as long?

Ask The iSeries 400 Expert: Questions & Answers

EMAIL THIS

Why is my job taking twice as long?

EXPERT RESPONSE FROM: Shahar Mor

		Pose a Question

		Other iSeries 400 Categories

		Meet all iSeries 400 Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 19 December 2005
We are running a series of overnight downloads from the iSeries using SQL server with ODBC connections. The job runs in subsystem QUSRWRK. The job, which once took two hours, leapt to a current five hours with no apparent changes to jobs, configuration or system parameters. The job ends normally, therefore there are no joblogs. On the odd occasion, jobs have to be manually terminated due to overrun. Do you have any idea what might be going on? I'm working with an iSeries Model 820 OS V5R2.

EXPERT RESPONSE
That may be the result of the SQL statement in the iSeries not optimizing (it can happen from changes in the database such as number of rows in tables, dropping indexes etc.).

I would recommend investigate into the QZDASOINIT jobs as follow:

- Force debug messages by setting parameter MESSAGES_DEBUG to *YES in the qaqqini file

- Force the joblog to print by temporarily changing the job description.

The joblog will show you the SQL used, how much time every statement taken, and the access plan (How did SQL planned to get the records).

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	iSeries PC/Windows Connectivity
	Tools for printing a PDF from IFS on iSeries
	File transfer DTF "hooks"
	Users not recognized on iSeries when logged in from Windows 2000
	Remote access from behind a SonicWall firewall
	Setting up personal communications between iSeries and Windows via the internet
	Using remote AS400 commands in a Windows environment
	How to FTP an IFS file on AS/400
	Using a Windows FTP server to pull data from an IFS directory
	Using an FTP script to send a text file from AIX to AS/400
	Monitoring logins over TCP/IP using FTP

Physical connections to iSeries

"Time" saving programming tips for iSeries

PC/Windows connectivity: Top 10 expert Q&As

Run command on a PC

Working with ODBC and dates

Problems with new server and PC

Take control of your iSeries network security -- Part 2

The iSeries and MS Office make good partners

Microsoft computing: Integrating the iSeries and Microsoft Office

i5/OS and Microsoft Office Integration Handbook, Third Edition -- Chapter 3

Know-IT-All Chapter Quiz: i5/OS and Microsoft Office Integration Handbook, Third Edition

Physical connections to iSeries Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 1999 - 2008, TechTarget \| Read our Privacy Policy