• iSeries Access ODBC Driver Error

    I'm trying to run a stored procedure on MS SQL Query Analyzer but continue to get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [IBM][iSeries Access ODBC Driver][DB2...

    Sixpach0 pointsBadges:
  • STP Cable

    what is the maximum lenght of STP cable can be used for 10 Mbps speed.  

    Shakeelawan10 pointsBadges:
  • Oracle acquires SUN: implications ?

    What do you think will be the implications of Oracle's Sun acquisition on: The future of MySql ? The virtualization market ? The hardware market ? The operating systems market ? Other IT fields ?

    carlosdl65,110 pointsBadges:
  • Delete Spool Files of 30 users (Starting with OP) using Generic Name i.e. OP*

    Every 3 moths we are deleting Spool files of users Starting With OP, on iSeries System using the below Program and a Display File. This activity is performed after the Spool Files (Which needs to be deleted) are saved on Tape using BRMS. *************** Beginning of data **************************...

    Haaiderali215 pointsBadges:
  • changing properties of PDS

    How to change space allocation for already created PDS?

    Chandu805 pointsBadges:
  • Connect to AS/400 from a PC and run User Profiles Initial Program

    I'd like to be able to have a user connect via FTP, ect. from a PC to our AS/400, login, and have the user profiles inital program run immediately. We've tried several options, but the initial program doesn't run unless a user signs on to a Session. This is not an option. Can you help? Thanks

    Sbach50 pointsBadges:
  • Need some performance tuning tips or suggestions.

    We currently have a 720-9406 model iSeries AS/400 system. We recently upgraded are OS to version V5R3M0. We are using the system mainly for our payroll processing which occurs weekly, as well as we have the system set up as a web server which we have employees accessing throughout the day. Since...

    Bkr0963c0 pointsBadges:
  • Can you transfer active jobs to another subsystem?

    If a job is already active in one subsystem, can you use tfrbchjob or tfrjob to move into a different job queue to run in a different subsystem, or will you get errors because the job is already active in one subsystem?

    Bkr0963c0 pointsBadges:
  • Calling External Procedure from Java Web based Application

    Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in...

    TOKNOWIT0 pointsBadges:
  • How To Print A Hardware Configuration List?

    Does anyone know of another command to use to print out a hardware configuration list for the AS/400. I have already used the following command: DSPHDWRSC TYPE(*AHW) OUTPUT(*PRINT) Is there anything else that can be used?

    Bkr0963c0 pointsBadges:
  • Restoring a dtaq in iseries.

    I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included. When i do that, the dtaq is empty. If someone knows how to do that, please tell me. Thanks.

    Moreira0 pointsBadges:
  • AS/400 System Saves and Journals

    We use the following commands to do our weekly system save: SAVSYS, NONSYS, SAVDLO, SAV. Will this save system journals as well? Thanks in advace for your help.

    BaughOper0 pointsBadges:
  • iSeries Navigator message monitor failing on endpoint system

    After years of working very well, iSeries Nagivator (Ops Nav) refuses to monitor messags on an endpoint iSeries.  This is a recent development.  Its been working just fine on the endpoint in question for the last 3+ years.  The QYPSJSVR job log shows CPFB904 and CPFB905.  Both are running V5R4...

    WoodEngineer6,045 pointsBadges:
  • The most-watched IT questions this week: Oct. 20, 2009

    Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

    Michael Morisy7,943 pointsBadges:
  • Scalar functions in GROUP BY

    Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM MYTAB A GROUP BY...

    Sumithar0 pointsBadges:
  • Dell PowerEdge 2950 power requirements

    Can anyone point me to the power usage of a dell poweredge 2950? i have 25 that i plan on installing and want to make sure i dont overload the power supply. I have read that each server averages 750w but i know this can vary.

    ITKE54,900 pointsBadges:
  • When a Network receives a packet, does it use the IP or MAC address?

    When a packet is sent in the network, which address is being used; the IP (Internet Protocol) or MAC (Media Access Control)?

    NetworkingATE1,545 pointsBadges:
  • Triggers

    Does the AS/400 have a cross-reference file or files that give the same kind of information about triggers as QADBFDEP and QADBFCST do for dependent files and constraints? If so, what is/are they called? Thanks

    Xixones0 pointsBadges:
  • AS400 Clutter

    anyone know what causes *SQLPKG objects to be created in various libraries by many different users, some by IBM internal most not. Trying to cleanup system.

    Jpolep5 pointsBadges:
  • Dell PowerEdge 6400 alarm settings

    My dell poweredge 6400 had a drive fail in raid 5 config. How do i disable the alarm that goes off when this happens.

    ITKE54,900 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following