While troubleshooting a DB2 performance problem for Websphere Portal 6.1.0 using DB2 9.5 Enterprise Edition , one of the DB2 tuning recommendations from the Portal Tuning guide was to set MAXFILOP = 512 or higher MAXFILOP is the Maximum database files open per application configuration parameter. What...
Usually when the DB2 instance ends unexpectedly, trap files are created. There is usually one trap file capturing the root cause. A number of other files are created, supporting data about DB2 processes. The dbdiag.log file indicates which files to analyze. By default, the files are created in “<INATANCE_HOME>...
Diaglevel refers to the Diagnostic error capture level configuration parameter. There are 5 levels: 0 - No diagnostic data captured 1 - Severe errors only 2 - All errors 3 - All errors and warnings 4 - All errors, warnings and informational messages The default is at 3. Change the diagnostic level with...
Accessing remote data in SQL Server is inevitable sometimes and often people use linked servers for this task. Linked servers are a good option because they are easy to setup and the maintenance is relatively easy but they quickly realize the performance issues when accessing the remote data. There are...
If on the command line use, LIST APPLICATIONS . If you were using a client such as Putty – logon as relevant user, The logon account must have at least one of these Authorisations: sysadm, sysctrl, sysmaint, sysmon. --STEP 1 – connect to relevant database $db2 connect to <MYDB> --STEP...
Prerequisites 1)Putty client 2)Username\Password of a valid Linux user 3)Username,hostname,password of MySQL server 4)Database name – assume it’s called MYDB Steps Logon to Linux server using Putty with information from step 2) of Prerequisites. From the command line type: mysql -uUSERNANE...
After a period of usage – quite often I see these type of messages on the monitoring reports. USERSPACE1 in MYDB has 98 pct used. Instance: MyInstance The first step I take is: Db2 connect to MYDB db2 list tablespace containers for 2 show detail. Tablespace ID = 2 Name = USERSPACE1 Type = Database...
SQL0286N A default table space could not be found with a page size of at least "4096" that authorization ID "user1" is authorized to use. SQLSTATE=42727 This was after a DECLARE GLOBAL TEMPORARY TABLE type of statement I had a look at the users permissions.They were CREATE SCHEMA...
Running the DB2 IMPORT statement below: "import from MYTable.ixf of ixf messages msg.txt INSERT INTO MYSCHEMA.MYTABLE" the error response in the DB2DIAG.LOG was: Error from Import/Export or Load Processing "Log File has reached its saturation point" DIA8309C Log file was full. One...
1)Open a DB2 command prompt 2)Verify you are on the correct instance db2 get instance 3)Find the service name of your instance db2 get dbm cfg | grep SVCE You'll get back something like: TCP/IP Service Name (SVCENAME) = db2mydb2 4)Use the service name to find the port number in the services file...