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.

Answer Question   |  December 23, 2008  2:32 AM
AS/400 database, AS/400 database administration, DB2, DB2/400, Open source databases

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?

Answer Question   |  December 19, 2008  6:22 AM
DB2, DB2/400, DB2/400 primary files

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 be connect to [...]

Answer Question   |  December 24, 2008  7:24 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server

What are the possible situations where DB2 server FORCES to close the applications connected to it?
Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

Answer Question   |  June 29, 2011  11:00 AM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2

How to limit the number of application connections in DB2?
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

Answer Question   |  September 23, 2009  10:54 AM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database

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

Answer Question   |  December 8, 2008  6:42 AM
Database, DB2, DB2/400, Oracle, RDBMS, Referential integrity, SQL Server

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? [...]

Answer Question   |  December 10, 2008  11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

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.

Answer Question   |  December 4, 2008  4:51 AM
Database administration, Database connectivity, Database management, DB2, Network connectivity, Oracle, SQL Database, SQL Server 2005

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.

Answer Question   |  December 2, 2008  11:44 AM
Database deadlock, Database Failover, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

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 authority either with an expiration [...]

Answer Question   |  December 4, 2008  8:52 PM
DB2, DB2 administration, DB2 Permissions, DBA

Create DB2 table relations
There is a requirement to have a subset of data available in DB2 tables in production to a test environment. There is no relationship defined in DB2 (so info available in catalog relationship tables). Now we need to find the relationship between the tables using some automation process. So we might not able to manually [...]

Answer Question   |  November 24, 2008  10:34 AM
DB2, DB2 Table Relationships, Mapping table relationships, Table Relationships

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’ [...]

Answer Question   |  November 19, 2008  6:28 PM
DB2, i5, SQL, UDB for iSeries/i5

QMF
can we save the statements write in QMF?

Answer Question   |  September 23, 2009  2:14 PM
DB2, DB2 query tools, IBM DB2, IBM DB2 Query Management Facility, IBM Query Management Facility, QMF, Query Management Facility

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 Linux]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

Answer Question   |  December 4, 2008  1:24 PM
DB2, DB2 Universal Database, DB2 Update Query

DB2/400
difference between db2 and db2/400

Answer Question   |  September 23, 2009  7:38 AM
DB2, DB2/400, IBM DB2

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 [...]

Answer Question   |  November 4, 2008  7:35 PM
DB2, Remote access, SQL database replication, Unix Servers

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 [...]

Answer Question   |  December 4, 2008  5:58 PM
AIX, AIX Performance, DB2, DB2 Fixpak

SQL query error: token DATA
I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),…… ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this query on iSeries [...]

Answer Question   |  September 23, 2009  5:54 PM
AS/400, DB2, JDBC, SQL Query

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?

Answer Question   |  December 4, 2008  5:50 PM
AS/400, DB2, DB2/400, SQL Query, VARCHAR

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.

Answer Question   |  November 4, 2008  5:48 PM
AS/400, DB2, SQL, SQL procedure