10 More Discussions You Might Find Interesting
1. AIX
Hi all,
In my system, I have HMC 7 with Power Machine 6 & 7. On the managed system, we have many lpars.
In some lpars, I can see they are using virtual fiber channel to connect to DS8K storage. In search with google, I understand that it is configured with VIOS server to share the physical FC... (7 Replies)
Discussion started by: Phat
7 Replies
2. AIX
Hello Team,
I would need your help to enable communication over TLS1.2 on AIX 7.1 or 7.2 with IBM JDK 1.8 latest update.
By default, the request is trying to establish a connection over TLSv1 even though TLS 1.2 is explicitly enabled on server as well as on Java 8. The openssl command throws... (4 Replies)
Discussion started by: Naina2019
4 Replies
3. UNIX for Dummies Questions & Answers
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 (2 Replies)
Discussion started by: nedkao
2 Replies
4. Emergency UNIX and Linux Support
Dear all,
I was given the ID_DSA.pub by an MVS user, which I placed in the appropriate user's authorized_keys file. When the user tris to SFTP from their side to the AIX box, the following error is got:
error: debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY ... (6 Replies)
Discussion started by: ggayathri
6 Replies
5. Solaris
Hi everyone,
I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies
6. 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
7. Programming
Hi ,
We are migrating our database from DB2 z/os to DB2 UDB on UNIX.
and cobol on mainframes to AIX cobol on UNIX.
We have some cobol Db2 programs that are accessing different Databases
how do we code such type of programs in AIX cobol.
Do we need to Establish connection for accessing... (0 Replies)
Discussion started by: nal.satish
0 Replies
8. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
9. AIX
Hello,
can any one help me to debug the following command.
db2 -stec +pc ;
Regards,
SM (2 Replies)
Discussion started by: smolgara
2 Replies
10. Shell Programming and Scripting
Hi All,
I have written a script that transfers(FTP) files from Unix system to MVS system.
Below is the code for it.
ftp -inv $HOST<<ftp_test
quote site LRECL=200
quote site BLKSIZE=28000
mput SOURCE DEST
ftp_test
Here I need the help, if the above code can get... (3 Replies)
Discussion started by: rinku11
3 Replies
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)