×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

有对AIX感兴趣的请看进来

本饭桶在吃闲饭之余刚开发了一套自动申请AIX ID的小程序,可谓之麻雀虽小五脏俱全了...

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

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

THX
FAN.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 有对AIX感兴趣的请看进来
    本饭桶在吃闲饭之余刚开发了一套自动申请AIX ID的小程序,可谓之麻雀虽小五脏俱全了...

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

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

    THX
    FAN.
    • thumbs up!
    • 多谢了, 能不能给个DB2的ACCOUNT.
      • 对不起,机器上没装DB2...要的话我就去装。
        • 你是道德上有修养的人, 谢谢了, 有些人来这里只吹牛,XB, 很无聊.
          • Thx.
            本文发表在 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我还是菜鸟,希望指导.
      本文发表在 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
      • 这个这个....
        本文发表在 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),多谢
          -bash-3.00# lslpp -f bos.adt.libm
          lslpp: 0504-132 Fileset bos.adt.libm not installed.
          -bash-3.00#
    • Thanks a lot.
    • 从未做过admin, 但时不时要被performance困扰。想做一些基本的研究,有什么建议?正在看"AIX 5L Performance Tools Handbook".
      • 建议:你个大款,用你半天的收入去eBay上买一个43p140的RS6000自己研究
        • 这里有个Test server, 随便玩。