有对AIX感兴趣的请看进来 -thisunreal(饭得志) @拉斯维加斯华人论坛:拉斯维加斯枫下论坛 The Rolia Forum of Las Vegas

工作学习 / 专业技术讨论 / 有对AIX感兴趣的请看进来 -thisunreal(饭得志); 2005-12-10 {210} (#2655605@0)
本饭桶在吃闲饭之余刚开发了一套自动申请AIX ID的小程序,可谓之麻雀虽小五脏俱全了...

各位要拿自己的AIX ID的弟兄到如下链接观摩观摩,并请多多提出意见.

http://fandezhi.efglobe.com/apply/applyuser.php

THX
FAN.
http://fandezhi.efglobe.com/apply/applyuser.php

thumbs up! -pasu(InTheSky); 2005-12-10 (#2655731@0)
多谢了, 能不能给个DB2的ACCOUNT. -goodchoice(丑壮男人); 2005-12-10 (#2656122@0)

对不起，机器上没装DB2...要的话我就去装。 -thisunreal(饭得志); 2005-12-10 (#2656381@0)

你是道德上有修养的人, 谢谢了, 有些人来这里只吹牛,XB, 很无聊. -goodchoice(丑壮男人); 2005-12-11 (#2656777@0)

Thx. -j30(猪狗不如); 2005-12-11 {4328} (#2658065@0)
本文发表在 rolia.net 枫下论坛刚完成了DB2的安装,呵呵,是新手,花了不少时间,发现AIX 5.3的第4张盘上的DB2安装进去以后无法使用...只能去download了一个Trial版本,经测试一切正常

----------------
db2inst1:/home/db2inst1 > ps -ef|grep db2
db2inst1 23606 41130 0 22:37:39 - 0:00 db2tcpcm 0
db2inst1 24490 41130 0 22:37:44 - 0:05 db2hmon 0
db2inst1 27092 41130 0 22:37:39 - 0:00 db2ipccm 0
root 27592 41130 0 22:37:39 - 0:00 db2ckpwd 0
db2inst1 29220 1 0 22:54:36 - 0:00 /home/db2inst1/sqllib/bin/db2bp 52238A108 5 A
db2inst1 37332 41130 0 22:37:39 - 0:00 db2tcpcm 0
dasusr1 39758 1 0 22:36:13 - 0:00 /home/dasusr1/das/adm/db2dasrrm
db2inst1 41130 50974 0 22:37:39 - 0:00 db2sysc 0
dasusr1 43932 1 0 22:36:39 - 0:00 /home/dasusr1/das/bin/db2fmd -i dasusr1 -m /home/dasusr1/das/lib/libdb2dasgcf.a
db2inst1 44906 52238 2 22:57:29 pts/6 0:00 grep db2
root 47856 41130 0 22:37:39 - 0:00 db2ckpwd 0
db2inst1 48118 49362 0 22:37:44 - 0:00 db2spmlw 0
root 48726 1 0 22:36:39 - 0:00 /usr/opt/db2_08_01/bin/db2fmcd
db2inst1 49362 41130 0 22:37:39 - 0:00 db2gds 0
db2inst1 50192 41130 0 22:37:40 - 0:00 db2resync 0
root 50974 1 0 22:37:38 - 0:00 db2wdog 0
db2inst1 51582 49362 0 22:37:40 - 0:00 db2srvlst 0
root 51920 41130 0 22:37:39 - 0:00 db2ckpwd 0
db2inst1 52094 41130 0 22:37:40 - 0:00 db2spmrsy 0
db2inst1 52238 28276 1 22:54:11 pts/6 0:00 -ksh
db2inst1 52866 27092 0 22:47:48 - 0:00 db2agent (idle) 0
db2inst1 53208 27092 0 22:37:52 - 0:05 db2agent (idle) 0
db2inst1 55988 27092 0 22:47:47 - 0:59 db2agent (idle) 0
db2inst1 58318 52238 12 22:57:29 pts/6 0:00 ps -ef

db2inst1:/home/db2inst1 > db2 connect to sample

Database Connection Information

Database server = DB2/6000 8.2.0
SQL authorization ID = DB2INST1
Local database alias = SAMPLE

db2inst1:/home/db2inst1 > db2 "select * from staff";

ID NAME DEPT JOB YEARS SALARY COMM
------ --------- ------ ----- ------ --------- ---------
10 Sanders 20 Mgr 7 18357.50 -
20 Pernal 20 Sales 8 18171.25 612.45
30 Marenghi 38 Mgr 5 17506.75 -
40 O'Brien 38 Sales 6 18006.00 846.55
50 Hanes 15 Mgr 10 20659.80 -
60 Quigley 38 Sales - 16808.30 650.25
70 Rothman 15 Sales 7 16502.83 1152.00
80 James 20 Clerk - 13504.60 128.20
90 Koonitz 42 Sales 6 18001.75 1386.70
100 Plotz 42 Mgr 7 18352.80 -
110 Ngan 15 Clerk 5 12508.20 206.60
120 Naughton 38 Clerk - 12954.75 180.00
130 Yamaguchi 42 Clerk 6 10505.90 75.60
140 Fraye 51 Mgr 6 21150.00 -
150 Williams 51 Sales 6 19456.50 637.65
160 Molinare 10 Mgr 7 22959.20 -
170 Kermisch 15 Clerk 4 12258.50 110.10
180 Abrahams 38 Clerk 3 12009.75 236.50
190 Sneider 20 Clerk 8 14252.75 126.50
200 Scoutten 42 Clerk - 11508.60 84.20
210 Lu 10 Mgr 10 20010.00 -
220 Smith 51 Sales 7 17654.50 992.80
230 Lundquist 51 Clerk 3 13369.80 189.65
240 Daniels 10 Mgr 5 19260.25 -
250 Wheeler 51 Clerk 6 14460.00 513.30
260 Jones 10 Mgr 12 21234.00 -
270 Lea 66 Mgr 9 18555.50 -
280 Wilson 66 Sales 9 18674.50 811.50
290 Quill 84 Mgr 10 19818.00 -
300 Davis 84 Sales 5 15454.50 806.10
310 Graham 66 Sales 13 21000.00 200.30
320 Gonzales 66 Sales 4 16858.20 844.00
330 Burke 66 Clerk 1 10988.00 55.50
340 Edwards 84 Sales 7 17844.00 1285.00
350 Gafney 84 Clerk 5 13030.50 188.00

35 record(s) selected.

db2inst1:/home/db2inst1 > db2 connect reset
DB20000I The SQL command completed successfully.
db2inst1:/home/db2inst1 >更多精彩文章及讨论，请光临枫下论坛 rolia.net

请教饭兄问题:请教AIX5.3上问题: freetds安装完成后,没有相应的so文件产生. 缺少bos.adt.libm.详情见内. AIX我还是菜鸟,希望指导. -mike20030405(mike); 2005-12-12 {6777} (#2659619@0)
本文发表在 rolia.net 枫下论坛安装以下几个软件包,全部是源码,需要编译安装(如果那位大侠能提供这些软件的binary包将感激不尽).
1. freetds
2. unixodbc
3. mozilla LDAP c-sdk

目前遇到的问题是:
1. freetds和unixodbc安装完成后(缺省路经安装),/usr/local/lib下没有相应的.so文件.我不了解AIX,难道AIX下.a就相当于其他unix下的.so? 其实在freetds和unixodbc的目录下有.so文件,但是为什么没有安装到/usr/local/lib?这两个软件包在HP和solaris下都编译安装很正常.
/usr/local/lib下的文件有:
-rwxr-xr-x 1 root system 149707 Dec 12 13:18 libtdssrv.a
-rwxr-xr-x 1 root system 801 Dec 12 13:18 libtdssrv.la
-rwxr-xr-x 1 root system 851 Dec 12 13:18 libtdsodbc.la
-rwxr-xr-x 1 root system 452481 Dec 12 13:18 libtdsodbc.a
-rwxr-xr-x 1 root system 473555 Dec 12 13:18 libsybdb.a
-rwxr-xr-x 1 root system 796 Dec 12 13:18 libsybdb.la
-rwxr-xr-x 1 root system 371030 Dec 12 13:18 libct.a
-rwxr-xr-x 1 root system 781 Dec 12 13:18 libct.la
-rwxr-xr-x 1 root system 2362 Dec 12 13:18 libtds.a
-rwxr-xr-x 1 root system 786 Dec 12 13:18 libtds.la
-rwxr-xr-x 1 root system 772 Dec 09 18:00 libboundparam.la
-rwxr-xr-x 1 root system 152490 Dec 09 18:00 libboundparam.a
-rwxr-xr-x 1 root system 37203 Dec 09 18:00 libgtrtst.a
-rwxr-xr-x 1 root system 694 Dec 09 18:00 libgtrtst.la
-rwxr-xr-x 1 root system 550505 Dec 09 18:00 libnn.a
-rwxr-xr-x 1 root system 674 Dec 09 18:00 libnn.la
-rwxr-xr-x 1 root system 2010599 Dec 09 18:00 libtemplate.a [ 相约加拿大:枫下论坛 www.rolia.net/forum ]
-rwxr-xr-x 1 root system 709 Dec 09 18:00 libtemplate.la
-rwxr-xr-x 1 root system 1956558 Dec 09 18:00 libodbcpsql.a
-rwxr-xr-x 1 root system 723 Dec 09 18:00 libodbcpsql.la
-rwxr-xr-x 1 root system 45734 Dec 09 18:00 libmimerS.a
-rwxr-xr-x 1 root system 694 Dec 09 18:00 libmimerS.la
-rwxr-xr-x 1 root system 42188 Dec 09 18:00 libsapdbS.a
-rwxr-xr-x 1 root system 694 Dec 09 18:00 libsapdbS.la
-rwxr-xr-x 1 root system 44282 Dec 09 18:00 liboraodbcS.a
-rwxr-xr-x 1 root system 704 Dec 09 18:00 liboraodbcS.la
-rwxr-xr-x 1 root system 44990 Dec 09 18:00 libodbctxtS.a
-rwxr-xr-x 1 root system 704 Dec 09 18:00 libodbctxtS.la
-rwxr-xr-x 1 root system 43658 Dec 09 18:00 libtdsS.a
-rwxr-xr-x 1 root system 684 Dec 09 18:00 libtdsS.la
-rwxr-xr-x 1 root system 694 Dec 09 18:00 libesoobS.la
-rwxr-xr-x 1 root system 49226 Dec 09 18:00 liboplodbcS.a
-rwxr-xr-x 1 root system 704 Dec 09 18:00 liboplodbcS.la
-rwxr-xr-x 1 root system 48055 Dec 09 18:00 libesoobS.a
-rwxr-xr-x 1 root system 41948 Dec 09 18:00 libodbcnnS.a
-rwxr-xr-x 1 root system 699 Dec 09 18:00 libodbcnnS.la
-rwxr-xr-x 1 root system 46036 Dec 09 18:00 libodbcmyS.a
-rwxr-xr-x 1 root system 699 Dec 09 18:00 libodbcmyS.la
-rwxr-xr-x 1 root system 43080 Dec 09 18:00 libodbcminiS.a
-rwxr-xr-x 1 root system 709 Dec 09 18:00 libodbcminiS.la
-rwxr-xr-x 1 root system 47768 Dec 09 18:00 libodbcpsqlS.a
-rwxr-xr-x 1 root system 709 Dec 09 18:00 libodbcpsqlS.la ＜ r o l i a. n e t ＞
-rwxr-xr-x 1 root system 41698 Dec 09 18:00 libodbcdrvcfg2S.a
-rwxr-xr-x 1 root system 724 Dec 09 18:00 libodbcdrvcfg2S.la
-rwxr-xr-x 1 root system 42552 Dec 09 18:00 libodbcdrvcfg1S.a
-rwxr-xr-x 1 root system 724 Dec 09 18:00 libodbcdrvcfg1S.la
-rwxr-xr-x 1 root system 885950 Dec 09 18:00 libodbccr.a
-rwxr-xr-x 1 root system 694 Dec 09 18:00 libodbccr.la
-rwxr-xr-x 1 root system 2986106 Dec 09 18:00 libodbc.a
-rwxr-xr-x 1 root system 716 Dec 09 18:00 libodbc.la
-rwxr-xr-x 1 root system 941262 Dec 09 17:59 libodbcinst.a
-rwxr-xr-x 1 root system 709 Dec 09 17:59 libodbcinst.la

生成但未安装的.so文件
-bash-3.00# pwd
/usr/local
-bash-3.00# find . -name "*.so*" -exec ls -l {} ;
-rwxr-xr-x 1 root system 445678 Dec 12 13:13 ./freetds-0.63/src/odbc/.libs/libtdsodbc.so.0
-rwxr-xr-x 1 root system 1654 Dec 12 13:12 ./freetds-0.63/src/tds/.libs/libtds.so.4
-rwxr-xr-x 1 root system 364853 Dec 12 13:12 ./freetds-0.63/src/ctlib/.libs/libct.so.3
-rwxr-xr-x 1 root system 463369 Dec 12 13:12 ./freetds-0.63/src/dblib/.libs/libsybdb.so.5
-rwxr-xr-x 1 root system 147170 Dec 12 13:15 ./freetds-0.63/src/server/.libs/libtdssrv.so.2
-rw-rw-r-- 1 root system 417 Dec 21 1998 ./openssl-0.9.8a/crypto/des/times/486-50.sol
-rwxr-xr-x 1 root system 1908719 Dec 09 15:27 ./unixODBC-2.2.11/Drivers/PostgreSQL/.libs/libodbcpsql.so.1
-rwxr-xr-x 1 root system 1936136 Dec 09 15:29 ./unixODBC-2.2.11/Drivers/Postgre7.1/.libs/libodbcpsql.so.2
-rwxr-xr-x 1 root system 1997323 Dec 09 15:32 ./unixODBC-2.2.11/Drivers/template/.libs/libtemplate.so.1
-rwxr-xr-x 1 root system 542824 Dec 09 15:34 ./unixODBC-2.2.11/Drivers/nn/.libs/libnn.so.1 { 枫下论坛 www.rolia.net/forum }
-rwxr-xr-x 1 root system 935235 Dec 09 15:16 ./unixODBC-2.2.11/odbcinst/.libs/libodbcinst.so.1
-rwxr-xr-x 1 root system 2971134 Dec 09 15:22 ./unixODBC-2.2.11/DriverManager/.libs/libodbc.so.1
-rwxr-xr-x 1 root system 881766 Dec 09 15:25 ./unixODBC-2.2.11/cur/.libs/libodbccr.so.1
-rwxr-xr-x 1 root system 41653 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/drvcfg1/.libs/libodbcdrvcfg1S.so.1
-rwxr-xr-x 1 root system 40799 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/drvcfg2/.libs/libodbcdrvcfg2S.so.1
-rwxr-xr-x 1 root system 46872 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/PostgreSQL/.libs/libodbcpsqlS.so.1
-rwxr-xr-x 1 root system 42184 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/MiniSQL/.libs/libodbcminiS.so.1
-rwxr-xr-x 1 root system 45147 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/MySQL/.libs/libodbcmyS.so.1
-rwxr-xr-x 1 root system 41078 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/nn/.libs/libodbcnnS.so.1
-rwxr-xr-x 1 root system 47165 Dec 09 15:25 ./unixODBC-2.2.11/DRVConfig/esoob/.libs/libesoobS.so.1
-rwxr-xr-x 1 root system 48233 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/oplodbc/.libs/liboplodbcS.so.1
-rwxr-xr-x 1 root system 42818 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/tds/.libs/libtdsS.so.1
-rwxr-xr-x 1 root system 44095 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/txt/.libs/libodbctxtS.so.1
-rwxr-xr-x 1 root system 43374 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/Oracle/.libs/liboraodbcS.so.1
-rwxr-xr-x 1 root system 41351 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/sapdb/.libs/libsapdbS.so.1
-rwxr-xr-x 1 root system 44884 Dec 09 15:26 ./unixODBC-2.2.11/DRVConfig/Mimer/.libs/libmimerS.so.1
-rwxr-xr-x 1 root system 36322 Dec 09 15:34 ./unixODBC-2.2.11/autotest/.libs/libgtrtst.so.1
-rwxr-xr-x 1 root system 150041 Dec 09 18:00 ./unixODBC-2.2.11/samples/.libs/libboundparam.so.1
-bash-3.00#

2. 编译Mozilla LDAP c-sdk时提示
ld: 0706-006 Cannot find or open library file: -l m
ld:open(): A file or directory in the path name does not exist.

google了一下,似乎是缺少libm.a.那位知道那里可以下载到bos.adt.libm? 要不那位有AIX5.3的安装盘借用一下或者做个镜象? ＜相约加拿大 ROLIA.NET ＞

非常感谢!

(另外,你的OS 390有没有一个什么基本操作说明?汗,啥操作都不会啊)更多精彩文章及讨论，请光临枫下论坛 rolia.net

这个这个.... -thisunreal(饭得志); 2005-12-12 {1279} (#2659778@0)
本文发表在 rolia.net 枫下论坛root:/db2/fandezhi/db2inst1/NODE0000/SQL00001 > whereis libm.a
libm: /usr/lib/libm.a /usr/ccs/lib/libm.a

root:/db2/fandezhi/db2inst1/NODE0000/SQL00001 > lslpp -w /usr/lib/libm.a
File Fileset Type
----------------------------------------------------------------------------
/usr/lib/libm.a bos.adt.libm Symlink

我这里有光盘,不过建议你先执行一下以下命令看看有没有安装,没安装的话我再把相应安装文件集放到机器上给你下载把.

root:/etc > lslpp -f bos.adt.libm
Fileset File
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.libm 5.3.0.10
/usr/lib/libm_r.a -> /usr/ccs/lib/libm_r.a
/usr/ccs/lib/libmsaa.a
/usr/ccs/lib/libm_r.a -> /usr/ccs/lib/libm.a
/usr/lib/libmsaa.a -> /usr/ccs/lib/libmsaa.a
/usr/ccs/lib/libmsaa_r.a -> /usr/ccs/lib/libmsaa.a
/usr/ccs/lib/libm.a
/usr/lib/libblas.a
/usr/lib/libm.a -> /usr/ccs/lib/libm.a
/usr/lib/libmsaa_r.a -> /usr/ccs/lib/libmsaa_r.a更多精彩文章及讨论，请光临枫下论坛 rolia.net

没有安装,老兄抽空整一个给我下载吧(注意:oslevel是5300-03),多谢 -mike20030405(mike); 2005-12-13 {100} (#2660909@0)
-bash-3.00# lslpp -f bos.adt.libm
lslpp: 0504-132 Fileset bos.adt.libm not installed.
-bash-3.00#

Thanks a lot. -peoplesoso(peoplesoso); 2005-12-14 (#2662909@0)
从未做过admin, 但时不时要被performance困扰。想做一些基本的研究，有什么建议？正在看"AIX 5L Performance Tools Handbook". -losthorizen(Shangri-La); 2005-12-16 (#2666727@0)

建议：你个大款，用你半天的收入去eBay上买一个43p140的RS6000自己研究 -lpcome(饭主席); 2005-12-16 (#2666737@0)

这里有个Test server, 随便玩。 -losthorizen(Shangri-La); 2005-12-16 (#2666745@0)

@Las Vegas

有对AIX感兴趣的请看进来

Replies, comments and Discussions:

More Topics