• Slow JDBC DB2 Connection

    Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the...

    Biohazard425 pointsBadges:
  • AS400

    In DDS, Unique is file level keyword. Is there any specific key word for field level?

    rajeshece1,215 pointsBadges:
  • How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • Native database implementation on AS/400

    Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

    Engineerteja5 pointsBadges:
  • What is the use of primary files in DB2/400?

    whats the use of primary file any real example please? in what scenario should we prefer to fully procedural file?

    6r1,485 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • Referential integrity and AS/400

    Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

    Shaddy20 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Granting and Revoking DB2 authority

    We've had several requests to grant 'temporary' SELECT authority on a table (meaning they want the user to have the authority for today, and not tomorrow). The DBAs don't want the housework of remembering to revoke the authority tomorrow, so we were wondering if anyone knows a way to grant...

    Nperk20 pointsBadges:
  • DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

    The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ' Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and...

    Saimadhu455 pointsBadges:
  • Database hang on AIX

    I'm experiencing a database hang and so far I haven't discovered the root cause of the problem. We are running DB2 v9 fixpak 3a on AIX 5.3. The instance is hanging and we can't kill the DB2 processes so the only way to restore services is rebooting the server. The following is the output from the...

    AS400 - Ask the Expert485 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Mainframe quality assurance testing tools

    I need to find a quick and cheap mainframe testing tool for an insurance application. The client will not spend the dollars till the concept is proven. I have looked for open source for the mainframe and found nothing. The client is running a batch system processing input are batch claims. Any help...

    Frankd0 pointsBadges:
  • Update help needed

    I need to perform an update as follows... Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = '', DXDAD1 = '', DXDAD2 = '', DXDAD3 = '', DXDAD4 = '', DXDPCD = '', DXINVN = 0 Where SDIECD = 'SO' And SDCDAT <...

    SBatSI415 pointsBadges:
  • Prevent Update in DB2 SQL External Trigger Program

    I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a...

    Djswtd25 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • FORMAT keyword in non-join logical files — what and how?

    How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?

    AS400 - Ask the Expert485 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • DB2 Web Query Login

    I log into DB2 Web Query, do what I am going to do and end the session. Come back the next day and login again. I then ger the message "An active session for this user id already exists." Why do I get this msg each time I start Web Query?

    PChase5 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