05-21-2012
AIX & DB2 paging issues
AIX & DB2 paging issues
Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem..
Thanks in advance
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all!
Working on Oracle v8i/9i on Unix Sun Solaris v8.0.
I am experiencing excessive paging & Swapping.Would like to know the cause.
I guess:could be due to inappropriate setting of Unix Kernel Parameters...
Please correct me if I am wrong!
Thanks&Regards,
Amit. (5 Replies)
Discussion started by: Amitstora
5 Replies
2. UNIX for Dummies Questions & Answers
Hi folks,
Lately my RS 6000 server is giving some problems.
Needs a reboot from time to time (4-8 days):mad:
Specs:
IBM/RS6000
Unix 4.3
3 gigabyte memory
I keep getting messages like :
" The fork function failed "
I have raised the paging space from 1 gigabyte to 3 gigabyte,... (2 Replies)
Discussion started by: Erik Rooijmans
2 Replies
3. AIX
Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed
Thanks is advance :) (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies
4. AIX
Hi,
I want to try to connect to a DB2 (MVS) database from an AIX, through my c++ custom program. Is anybody who knows how can I do this? Which libraries should I use? Should I have a DB2 connect installed on my AIX?
Thank you in advance. (3 Replies)
Discussion started by: develo
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Can anyone please advise a universal command option for using sar to check for paging/memory issues.
For Linux, I used sar -B and check on the majflt/s column and a high number is supposed to indicate paging issues, is that correct?
Unfortunately, on a Solaris server, sar -B does not... (1 Reply)
Discussion started by: newbie_01
1 Replies
6. UNIX for Advanced & Expert Users
I need to capture lengthy screen puts and direct to .txt.
Script command is started on Wed Aug 22 13:27:36 EDT 2012.
# qcp
sh: qcp: not found.
An issue I have is that script command doesn't take non-AIX commands.
I need to run application-specific commands and capture the output in... (2 Replies)
Discussion started by: Daniel Gate
2 Replies
7. Shell Programming and Scripting
Hi,
I am migrating few of the shell scripts from existing SUN Solaries to AIX.
My script contains some command like 'dos2unix' and 'unix2dos' which are not compatible in AIX flavour. Please let me know if there is any such commands in AIX which can replace these commands.
Thanks. (1 Reply)
Discussion started by: 46019
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a very simple script that queries from a DB2 table. The script has 3 parts - (i) Sets the db2profile (ii) connects to db2 using credentials (iii) executes the query.This script works fine if i run it manually from the command prompt. However when scheduled in crontab, it proceeds... (2 Replies)
Discussion started by: VeePee
2 Replies
9. AIX
I am new to AIX, I have few AIX 5.3 servers and I could see there are significant difference in paging space utilization on servers even though they are running same applications
below server is working fine which shows 2-5 % paging usage throuh out the day
cpu_scale_memp = 8... (12 Replies)
Discussion started by: bibish
12 Replies
10. UNIX and Linux Applications
What are the parameters ((i.e., Process & Services) need to monitor for SAP & DB2 to capture shutdown, restart & Halt status of those applications.
Please suggest the best practices.
Ex: SAPSTART for SAP & DP2SYS for DB2 (3 Replies)
Discussion started by: marunmeera
3 Replies
LEARN ABOUT PHP
pdo_odbc-dsn
PDO_ODBC-DSN(3) 1 PDO_ODBC-DSN(3)
PDO_ODBC DSN - Connecting to ODBC or DB2 databases
The PDO_ODBC Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is odbc:. If you are connecting to a database cataloged in the ODBC driver manager or the DB2 catalog, you can
append the cataloged name of the database to the DSN.
o DSN
- The name of the database as cataloged in the ODBC driver manager or the DB2 catalog. Alternately, you can provide a complete
ODBC connection string to connect to a database as described at http://www.connectionstrings.com/.
o UID - The name of the user for the connection. If you specify the user name in the DSN, PDO ignores the value of the user name
argument in the PDO constructor.
o PWD - The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of the password
argument in the PDO constructor.
Example #1
PDO_ODBC DSN example (ODBC driver manager)
The following example shows a PDO_ODBC DSN for connecting to an ODBC database cataloged as testdb in the ODBC driver manager:
odbc:testdb
Example #2
PDO_ODBC DSN example (IBM DB2 uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to an IBM DB2 database named SAMPLE using the full ODBC DSN syntax:
odbc:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;PORT=50000;DATABASE=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;
Example #3
PDO_ODBC DSN example (Microsoft Access uncataloged connection)
The following example shows a PDO_ODBC DSN for connecting to a Microsoft Access database stored at C:db.mdb using the full ODBC
DSN syntax:
odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\db.mdb;Uid=Admin
PHP Documentation Group PDO_ODBC-DSN(3)