Trafodion Troubleshooting 常用命令

最新推荐文章于 2021-05-16 20:25:26 发布
最新推荐文章于 2021-05-16 20:25:26 发布
阅读量1.7k 收藏 2
点赞数 1
分类专栏： QianBase/EsgynDB/Trafodion
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Post_Yuan/article/details/52944188
版权

1 sqstart(启动数据库，支持热启动和冷启动)

[trafodion@cent-1 scripts]$ sqstart -h
Usage: sqstart { -w | -c | -r } -x
-w Perform a Warm Start
-c Perform a Cold Start
-r Perform a Cold Start with volume recovery
-x Perform Extra Checks (chk_dbperms) before allowing startup
[trafodion@cent-1 scripts]$ sqstart
Checking orphan processes.
Checking if HBase is available
--------------------------------------
executing: hbcheck
...
Checking if peers are available
--------------------------------------
executing: check_peers
...
Executing sqipcrm (output to sqipcrm.out)
Starting the SQ Environment (Executing .../sql/scripts/gomon.cold)
Background SQ Startup job (pid: 55893)
*** Checking Trafodion Environment ***
...
Starting the DCS environment now
...
The Trafodion environment is up!
Process         Configured      Actual      Down
-------         ----------      ------      ----
DTM             2               2
RMS             4               4
DcsMaster       1               1
DcsServer       2               2
mxosrvr         4               0           4
Starting the REST environment now
...


2 sqstop(关闭数据库，支持abrupt模式和immediate模式)

[trafodion@cent-1 ~]$ sqstop -h
Usage: sqstop [ abrupt | immediate ]
This command is used to perform a shutdown of the SQ environment.
If a parameter is not specified, then a normal shutdown is performed.
[trafodion@cent-1 ~]$ sqstop
Shutting down the REST environment now
Shutting down the DCS environment now
Shutting down (normal) the SQ environment!
[$Z00175H] %ps
[$Z00175H] NID,PID(os)  PRI TYPE STATES  NAME        PARENT      PROGRAM
[$Z00175H] ------------ --- ---- ------- ----------- ----------- ---------------
[$Z00175H] 000,00023532 000 WDG  ES--A-- $WDG000     NONE        sqwatchdog
[$Z00175H] 000,00023533 000 PSD  ES--A-- $PSD000     NONE        pstartd
[$Z00175H] 000,00023548 001 GEN  ES--A-- $TSID0      NONE        idtmsrv
[$Z00175H] 000,00023554 001 GEN  ES--A-- $CMON       NONE        service_monitor
[$Z00175H] 000,00023670 001 GEN  ES--A-- $NMON0      NONE        service_monitor
[$Z00175H] 000,00023774 001 DTM  ES--A-- $TM0        NONE        tm
[$Z00175H] 000,00027218 001 GEN  ES--A-- $ZSC000     NONE        mxsscp
[$Z00175H] 000,00027707 001 SSMP ES--A-- $ZSM000     NONE        mxssmp
[$Z00175H] 000,00051642 001 GEN  ES--A-- $Z00175H    NONE        shell
[$Z00175H] 001,00012526 000 PSD  ES--A-- $PSD001     NONE        pstartd
[$Z00175H] 001,00012525 000 WDG  ES--A-- $WDG001     NONE        sqwatchdog
[$Z00175H] 001,00012539 001 GEN  ES--A-- $NMON1      NONE        service_monitor
[$Z00175H] 001,00012754 001 DTM  ES--A-- $TM1        NONE        tm
[$Z00175H] 001,00015350 001 GEN  ES--A-- $ZSC001     NONE        mxsscp
[$Z00175H] 001,00015557 001 SSMP ES--A-- $ZSM001     NONE        mxssmp
[$Z00175H] 001,00019503 001 GEN  ES--A-- $Z010FX8    NONE        mxosrvr
[$Z00175H] 001,00020602 001 GEN  ES--A-- $Z010GTM    NONE        mxosrvr
[$Z00175H] %shutdown
Shutdown in progress
Stopping OpenTSD...
Stopping Tcollector...
Stopping DBMgr...
Stopping Bosun...


3 sqcheck/trafcheck(检查数据库相关进程)

[trafodion@cent-1 scripts]$ sqcheck -h
Usage: sqcheck [ -c <cc> | -i <nn> | -d <nn> | -h | -f | -q | -v | -r | -j ]
-i <nn>  Number of times the check for Trafodion processes be done (Default 2)
-d <nn>  Duration of sleep (in seconds) between each check  (Default 1)
-c <cc>  Which component to check: [all | dtm | dcs | rms ] (Default all)
-f       fast - (it's like running .../sql/scripts/sqcheck -i 1 -d 0)
-r       reset the iteration counter if the process count increases (as compared to the count in the last iteration)
-j       Format the output in JSON. Used by REST server
-h       Help
-v       Verbose
-q       Quiet
[trafodion@cent-1 scripts]$ sqcheck
*** Checking Trafodion Environment ***
Checking if processes are up.
Checking attempt: 1; user specified max: 2. Execution time in seconds: 0.
The Trafodion environment is up!
Process         Configured      Actual      Down
-------         ----------      ------      ----
DTM             2               2
RMS             4               4
DcsMaster       1               1
DcsServer       2               2
mxosrvr         4               4

4 dcscheck(检查DCS服务)

[trafodion@cent-1 scripts]$ dcscheck
Zookeeper listen port: 2181
DcsMaster listen port: 23400
Configured Primary DcsMaster: "cent-1"
Active DcsMaster            : "cent-1"
Process         Configured      Actual          Down
---------       ----------      ------          ----
DcsMaster       1               1
DcsServer       2               2
mxosrvr         4               4


5 dcsstart(启动DCS服务)

[trafodion@cent-1 scripts]$ dcsstart
*** Checking Trafodion Environment ***
Checking if processes are up.
Checking attempt: 1; user specified max: 2. Execution time in seconds: 0.
The Trafodion environment is up!
Process         Configured      Actual      Down
-------         ----------      ------      ----
DTM             2               2
RMS             4               4
DcsMaster       1               0           1
DcsServer       2               0           2
mxosrvr         4               0           4
Starting the DCS environment now


6 dcsstop(停止DCS服务)

[trafodion@cent-1 scripts]$ dcsstop
Shutting down the DCS environment now
stopping master.
cent-2: stopping server.
cent-1: stopping server.

7 rmscheck(检查RMS服务)

[trafodion@cent-1 scripts]$ rmscheck
Timestamp                           Id    Status
2016-10-27 06:23:09.218429  Node    0     OK
2016-10-27 06:23:09.241041  Node    1     OK

8 rmsstart(启动RMS服务)

[trafodion@cent-1 scripts]$ rmsstart
exec {nowait, nid 0, name $ZSC000, out stdout_ZSC000 } mxsscp
...
exec {type ssmp, nowait, nid 0, name $ZSM000, out stdout_ZSM000 } mxssmp
...


9 rmsstop(停止RMS服务)

[trafodion@cent-1 scripts]$ rmsstop
!Stop the SSMP processes
...
!Stop the SSCP processes
...

10 hbcheck(检查Metadata)

[trafodion@cent-1 scripts]$ hbcheck -h
Usage:
hbstatus [[-h] | [-m] | [-p] <peer id> | [-t] <table name>]
-h              : Help (this output).
-m              : Check the status of Trafodion metadata tables.
-p <peer id>    : Defaults to the local cluster.
-t <table name> : Check the status of the provided table.
-v              : Verbose output.
[trafodion@cent-1 scripts]$ hbcheck -v
ZooKeeper Quorum: cent-2.novalocal, ZooKeeper Port  : 2181
HBase is available!
HBase version: 1.0.0-cdh5.4.8
HMaster: cent-2.novalocal,60000,1477058112339
Number of RegionServers available:2
RegionServer #1: cent-2.novalocal,60020,1477058112366
RegionServer #2: cent-1.novalocal,60020,1477058082327
Number of Dead RegionServers:0
Number of regions: 115
Number of regions in transition: 0
Average load: 57.5

11 sqcollectlogs(收集相关日志)

[trafodion@cent-1 scripts]$ sqcollectlogs -h
Usage: sqcollectlogs {-a | -d | -z | -h}

-a Collect all (logs and pstacks). Default is logs only
-c Compress (tar-zip) the logs/stdout files on a per-node basis and move the tar-zip files to the
   collection node. To extract these files, execute the xtract_logs program that can be found
   in the logs collection directory.
   On a cluster, recommend executing xtract_logs on the head node.
-d After zipping, delete the directory where the logs were collected.
   Note: This option (-d) only applies if the -z option is also used.
-z tar/zip up the directory (containing the collected logs/pstacks). Default is not to tar/zip
-h Help
[trafodion@cent-1 scripts]$ sqcollectlogs -a -z
Collection in progress...
Collecting monitor pstacks
[1] 54909
Collecting mxosrvr pstacks
[2] 54910
Collecting tdm_arkcmp pstacks
[3] 54911
Collecting tdm_arkesp pstacks
[4] 54912
Collecting tm pstacks
[5] 54913
[1]   Done                    $SQPDSHA "sqnpstack monitor $PWD/monitor" 2> /dev/null
[3]   Done                    $SQPDSHA "sqnpstack tdm_arkcmp $PWD/tdm_arkcmp" 2> /dev/null
[5]+  Done                    $SQPDSHA "sqnpstack tm $PWD/tm" 2> /dev/null
[2]-  Done                    $SQPDSHA "sqnpstack mxosrvr $PWD/mxosrvr" 2> /dev/null
[4]+  Done                    $SQPDSHA "sqnpstack tdm_arkesp $PWD/tdm_arkesp" 2> /dev/null
Logs and pstacks collected in /home/trafodion/logs/sqinfo.20161027_0636
Creating a tar/zip file...
Created the .tgz file: /home/trafodion/logs/sqinfo.20161027_0636.tgz

12 reststart(启动REST服务)

[trafodion@cent-1 scripts]$ reststart
*** Checking Trafodion Environment ***
Checking if processes are up.
Checking attempt: 1; user specified max: 2. Execution time in seconds: 0.
The Trafodion environment is up!
Process         Configured      Actual      Down
-------         ----------      ------      ----
DTM             2               2
RMS             4               4
DcsMaster       1               1
DcsServer       2               2
mxosrvr         4               4
Starting the REST environment now

13 reststop(关闭REST服务)

[trafodion@cent-1 scripts]$ reststop
Shutting down the REST environment now
stopping rest.

14 restcheck(检查REST服务)

[trafodion@cent-1 scripts]$ restcheck
TrafodionRest listen port  : 4200
TrafodionRest is up on node: cent-1,pid: 28467
Process         Actual
---------       ------
TrafodionRest   1

15 lobstart(启动LOB服务)

[trafodion@cent-1 scripts]$ lobstart
Starting lob server processes
Successfully started $zlobsrv0
Successfully started $zlobsrv1


16 lobstop(关闭LOB服务)

[trafodion@cent-1 scripts]$ lobstop
stopped $zlobsrv0
stopped $zlobsrv1


17 sqps(显示当前正在执行的进程)

[trafodion@cent-1 scripts]$ sqps
[$Z000SUY] %ps
[$Z000SUY] NID,PID(os)  PRI TYPE STATES  NAME        PARENT      PROGRAM
[$Z000SUY] ------------ --- ---- ------- ----------- ----------- ---------------
[$Z000SUY] 000,00056370 000 WDG  ES--A-- $WDG000     NONE        sqwatchdog
[$Z000SUY] 000,00056371 000 PSD  ES--A-- $PSD000     NONE        pstartd
[$Z000SUY] 000,00056388 001 GEN  ES--A-- $TSID0      NONE        idtmsrv
[$Z000SUY] 000,00056394 001 GEN  ES--A-- $CMON       NONE        service_monitor
[$Z000SUY] 000,00056510 001 GEN  ES--A-- $NMON0      NONE        service_monitor
[$Z000SUY] 000,00056584 001 DTM  ES--A-- $TM0        NONE        tm
[$Z000SUY] 000,00030812 001 GEN  ES--A-- $Z000Q5C    NONE        java
[$Z000SUY] 000,00034275 001 GEN  ES--A-- $Z000SZA    NONE        mxosrvr
[$Z000SUY] 000,00035473 001 GEN  ES--A-- $Z000TYI    NONE        mxosrvr
[$Z000SUY] 000,00041871 001 GEN  ES--A-- $ZSC000     NONE        mxsscp
[$Z000SUY] 000,00041954 001 SSMP ES--A-- $ZSM000     NONE        mxssmp
[$Z000SUY] 000,00030358 001 GEN  ES--A-- $ZLOBSRV0   NONE        mxlobsrvr
[$Z000SUY] 000,00034123 001 GEN  ES--A-- $Z000SUY    NONE        shell
[$Z000SUY] 001,00044580 000 WDG  ES--A-- $WDG001     NONE        sqwatchdog
[$Z000SUY] 001,00044581 000 PSD  ES--A-- $PSD001     NONE        pstartd
[$Z000SUY] 001,00044593 001 GEN  ES--A-- $NMON1      NONE        service_monitor
[$Z000SUY] 001,00044794 001 DTM  ES--A-- $TM1        NONE        tm
[$Z000SUY] 001,00014474 001 GEN  ES--A-- $Z010BTJ    NONE        mxosrvr
[$Z000SUY] 001,00015554 001 GEN  ES--A-- $Z010CPE    NONE        mxosrvr
[$Z000SUY] 001,00023248 001 GEN  ES--A-- $ZSC001     NONE        mxsscp
[$Z000SUY] 001,00023252 001 SSMP ES--A-- $ZSM001     NONE        mxssmp
[$Z000SUY] 001,00008542 001 GEN  ES--A-- $ZLOBSRV1   NONE        mxlobsrvr

18 pstat(显示当前节点Trafodion所有核心进程)

[trafodion@cent-1 scripts]$ pstat
trafodion    56388 56203 futex_  7960 108024 00:00:30 SNl  idtmsrv SQMON1.1 00000 00000 056388 $TSID0 192.168.0.16:51336 00004 00000 00006 SPARE
trafodion    56203     1 hrtime 38460 377980 00:02:19 Ssl  ../export/bin64/monitor COLD
trafodion    30358 56203 futex_ 37404 332480 00:00:00 SNl  mxlobsrvr SQMON1.1 00000 00000 030358 $ZLOBSRV0 192.168.0.16:51336 00004 00000 00468 SPARE
trafodion    34275 33902 futex_ 42188 386484 00:00:34 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-1.novalocal:1:1 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.16 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
trafodion    35473 35027 futex_ 42188 386484 00:00:33 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-1.novalocal:1:2 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.16 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
trafodion    41871 56203 futex_ 37948 399064 00:00:17 SNl  mxsscp SQMON1.1 00000 00000 041871 $ZSC000 192.168.0.16:51336 00004 00000 00250 SPARE
trafodion    41954 56203 futex_ 41772 409564 00:00:18 SNl  mxssmp SQMON1.1 00000 00000 041954 $ZSM000 192.168.0.16:51336 00011 00000 00255 SPARE
trafodion    56371 56203 futex_  5016 114808 00:00:35 Sl   pstartd SQMON1.1 00000 00000 056371 $PSD000 192.168.0.16:51336 00012 00000 00002 SPARE
trafodion    56394 56203 futex_  7924  97768 00:00:32 SNl  service_monitor SQMON1.1 00000 00000 056394 $CMON 192.168.0.16:51336 00004 00000 00007 SPARE -t 60 -f cluster_monitor.cmd
trafodion    56510 56203 futex_  7924  97768 00:00:31 SNl  service_monitor SQMON1.1 00000 00000 056510 $NMON0 192.168.0.16:51336 00004 00000 00008 SPARE -t 60 -f node_monitor.cmd
trafodion    56370 56203 futex_  4552 133856 00:00:38 Sl   sqwatchdog SQMON1.1 00000 00000 056370 $WDG000 192.168.0.16:51336 00005 00000 00001 SPARE
trafodion    56584 56203 futex_ 278304 2670664 00:02:21 SNl tm SQMON1.1 00000 00000 056584 $TM0 192.168.0.16:51336 00002 00000 00011 SPARE

19 cstat(显示集群Trafodion所有核心进程)

[trafodion@cent-1 scripts]$ cstat
cent-2: uid          pid   ppid  wchan   rss   vsz   time     stat cmd
cent-2: ---          ---   ----  -----   ---   ---   ----     ---- ---
cent-1: uid          pid   ppid  wchan   rss   vsz   time     stat cmd
cent-1: ---          ---   ----  -----   ---   ---   ----     ---- ---
cent-1: trafodion    56388 56203 futex_  7960 108024 00:00:30 SNl  idtmsrv SQMON1.1 00000 00000 056388 $TSID0 192.168.0.16:51336 00004 00000 00006 SPARE
cent-1: trafodion    56203     1 hrtime 38460 377980 00:02:20 Ssl  ../export/bin64/monitor COLD
cent-1: trafodion    30358 56203 futex_ 37404 332480 00:00:01 SNl  mxlobsrvr SQMON1.1 00000 00000 030358 $ZLOBSRV0 192.168.0.16:51336 00004 00000 00468 SPARE
cent-1: trafodion    34275 33902 futex_ 42188 386484 00:00:34 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-1.novalocal:1:1 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.16 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
cent-1: trafodion    35473 35027 futex_ 42188 386484 00:00:33 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-1.novalocal:1:2 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.16 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
cent-1: trafodion    41871 56203 futex_ 37952 399064 00:00:17 SNl  mxsscp SQMON1.1 00000 00000 041871 $ZSC000 192.168.0.16:51336 00004 00000 00250 SPARE
cent-1: trafodion    41954 56203 futex_ 41780 409564 00:00:18 SNl  mxssmp SQMON1.1 00000 00000 041954 $ZSM000 192.168.0.16:51336 00011 00000 00255 SPARE
cent-1: trafodion    56371 56203 futex_  5016 114808 00:00:35 Sl   pstartd SQMON1.1 00000 00000 056371 $PSD000 192.168.0.16:51336 00012 00000 00002 SPARE
cent-1: trafodion    56394 56203 futex_  7924  97768 00:00:32 SNl  service_monitor SQMON1.1 00000 00000 056394 $CMON 192.168.0.16:51336 00004 00000 00007 SPARE -t 60 -f cluster_monitor.cmd
cent-1: trafodion    56510 56203 futex_  7924  97768 00:00:31 SNl  service_monitor SQMON1.1 00000 00000 056510 $NMON0 192.168.0.16:51336 00004 00000 00008 SPARE -t 60 -f node_monitor.cmd
cent-1: trafodion    56370 56203 futex_  4552 133856 00:00:38 Sl   sqwatchdog SQMON1.1 00000 00000 056370 $WDG000 192.168.0.16:51336 00005 00000 00001 SPARE
cent-1: trafodion    56584 56203 futex_ 278308 2670664 00:02:22 SNl tm SQMON1.1 00000 00000 056584 $TM0 192.168.0.16:51336 00002 00000 00011 SPARE
cent-2: trafodion     8542 44432 futex_ 37408 332476 00:00:01 SNl  mxlobsrvr SQMON1.1 00001 00001 008542 $ZLOBSRV1 192.168.0.47:34220 00004 00001 00024 SPARE
cent-2: trafodion    14474 13989 futex_ 44200 386480 00:00:27 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-2.novalocal:2:1 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.47 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
cent-2: trafodion    15554 15120 futex_ 46096 386480 00:00:27 Sl   mxosrvr -ZKHOST cent-2.novalocal:2181 -RZ cent-2.novalocal:2:2 -ZKPNODE /trafodion -CNGTO 60 -ZKSTO 180 -EADSCO 0 -TCPADD 192.168.0.47 -MAXHEAPPCT 0 -STATISTICSINTERVAL 60 -STATISTICSLIMIT 60 -STATISTICSTYPE aggregated -STATISTICSENABLE true -SQLPLAN true -PORTMAPTOSECS -1 -PORTBINDTOSECS -1 -PUBLISHSTATSTOTSDB false -OPENTSDURL localhost:5242
cent-2: trafodion    23248 44432 futex_ 37940 399060 00:00:14 SNl  mxsscp SQMON1.1 00001 00001 023248 $ZSC001 192.168.0.47:34220 00004 00001 00022 SPARE
cent-2: trafodion    23252 44432 futex_ 39828 409560 00:00:15 SNl  mxssmp SQMON1.1 00001 00001 023252 $ZSM001 192.168.0.47:34220 00011 00001 00023 SPARE
cent-2: trafodion    44581 44432 futex_  5008 114804 00:00:28 Sl   pstartd SQMON1.1 00001 00001 044581 $PSD001 192.168.0.47:34220 00012 00001 00002 SPARE
cent-2: trafodion    44593 44432 futex_  7908  97768 00:00:26 SNl  service_monitor SQMON1.1 00001 00001 044593 $NMON1 192.168.0.47:34220 00004 00001 00003 SPARE -t 60 -f node_monitor.cmd
cent-2: trafodion    44580 44432 futex_  4524 133852 00:00:32 Sl   sqwatchdog SQMON1.1 00001 00001 044580 $WDG001 192.168.0.47:34220 00005 00001 00001 SPARE
cent-2: trafodion    44794 44432 futex_ 241652 2662688 00:01:57 SNl tm SQMON1.1 00001 00001 044794 $TM1 192.168.0.47:34220 00002 00001 00004 SPARE


20 pkillall(杀掉当前节点Trafodion核心进程)

[trafodion@cent-1 scripts]$ pkillall
kill 23313: No such process

21 ckillall(杀掉集群Trafodion核心进程)

[trafodion@cent-1 scripts]$ ckillall
Do you really want to continue? y/n : y
Shutting down the DCS environment now
stopping master.
cent-2: stopping server.
cent-1: stopping server.
Shutting down the REST environment now
stopping rest.
Stopping OpenTSD...
Stopping Tcollector...
Stopping DBMgr...
Stopping Bosun...


数据源的港湾
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
易鲸捷trafodion数据库，MDAM详解
03-22
易鲸捷trafodion数据库，MDAM详解；这是易鲸捷数据库特有的优化方式
BGP Troubleshooting 排错技术
02-09
BGP Troubleshooting 排错技术
Juniper----常用Troubleshooting 方法及日志收集
qq_43331152的博客
10-29 3250
一，Flow的排查 通常配置完成后，发现业务访问不正常或是不通，需要使用一些方法进行排查 1，在接口上抓包查看实时的Traffic信息 SRX> monitor traffic interface ge-0/0/0.0 no-resolve 2,Flow的Debug set security flow traceoptions file flowlog #生成文件名flowlog set s...
JVM Troubleshooting命令-jinfo
听雪楼
02-18 603
概述 用来查看正在运行的Java应用程序的扩展参数，支持在运行时，修改部分参数。 命令格式 jinfo [ option ] pid jinfo [ option ] executable core jinfo [ option ] [ servier-id ] remote-hostname-or-IP option : 命令行功能选项 pid : 进程id executable...
Trafodion 权限相关命令
数据源的港湾
02-27 509
当前的Trafodion数据库支持通过LDAP的方式来管理用户及权限。Trafodion有很多与权限控制相关的SQL命令，本文列举一些常用的SQL语法供读者参考，这些SQL命令大部分可以通过Trafodion官网的SQL手册查看到，可能有少部分目前尚未维护在官网中。 1 查看系统有哪些用户(get users) SQL&gt;get users; Users ===== DB__ADMIN...
OpenShift Authentication Troubleshooting 常用命令
Christina の Blog
05-16 150
查看它使用哪种 Identity Provider oc get OAuth cluster -o yaml spec 里面会描述
Troubleshooting Cisco Catalyst 4500 Series Switches
10-08
在本课程"Troubleshooting Cisco Catalyst 4500 Series Switches"中，重点是学习如何诊断和解决Catalyst 4500系列交换机的问题。这些交换机广泛应用于企业园区网络，提供了高带宽和强大的功能。以下是课程涵盖的关键...
Windows 10 Troubleshooting.zip
05-11
"Windows 10 Troubleshooting"文档旨在提供一个全面的指南，帮助用户解决这些常见问题。以下是该文档可能涵盖的一些关键知识点： 1. **启动问题**：当Windows 10无法正常启动时，用户可以尝试安全模式、系统恢复点...
ANSYS EKM Troubleshooting Guide.pdf
11-08
ANSYS EKM Troubleshooting Guide
Linux命令及TroubleShooting技术总结.docx
最新发布
10-26
对于IT专业人士来说，理解和掌握Linux命令以及TroubleShooting技术至关重要。本篇文章将对Linux的基本命令和故障排查技术进行总结。 首先，让我们来看一下Linux操作系统安装。在安装Linux时，我们需要选择合适的...
Trafodion 对中文的支持
数据源的港湾
10-25 1219
在Trafodion数据库，当我们设定一个字段类型为字符类型的时候（如CHAR或VARCHAR），字符编码会以数据库默认的字符编码为准。 比如下面例子，创建有一个字符类型字段的表，通过SHOWDDL命令可以看到这个字段的编码方式为ISO88591。 SQL>drop table seabase.test_chinese; create table seabase.test_chinese (r
SHELL调用Trafodion SQL与并发执行
数据源的港湾
11-30 1001
本文总结了几种在SHELL脚本中调用Trafodion SQL语句的方法，供读者参考~ 这里假设执行SHELL脚本的用户为trafodion用户，调用方法示例如下，如果执行SHELL脚本的用户为非trafodion用户，非需要在脚本中另外添加一些su到trafodion用户的步骤，在此不做详述。[trafodion@n12 ~]$ cat test.sh #method 1 echo " sele
Trafodion CLI 常用命令
数据源的港湾
11-09 920
我们已经知道，Trafodion提供CLI给用户以交互式的方式去操作数据库。常用的CLI包括Trafci和Sqlci。拿Trafci来说，当在服务器上或客户端执行trafci后便开启了一个会话，即Session。CLI中其实有很多命令是跟Session有关，下面就一一通过例子尝试一下。 ENV/SESSION/SHOW SESSION --显示当前会话的属性和设置 SQ
【Trafodion使用技巧篇】Trafodion数据加载介绍
weixin_34321977的博客
10-29 289
Trafodion 的数据加载主要包括两种方法，即 Trickle Load（持续加载） 和 Bulk Load（批量加载）。下表介绍了两种加载方法的区别： 类型 描述 方法/工具 Trickle Load 数据量较小，立即插入 ODB 工具（性能通常较第三方ETL工具更好); ETL 工具如kettle、Informatica...
Trafodion 开发环境搭建
数据源的港湾
11-15 3965
Trafodion是Apache下面的开源孵化项目，既然是开源，任何人都可以修改并提交你的代码，Trafodion欢迎大家通过各种方式为开源社区贡献一份力量，最直接的方式当然是提交你的代码。要想将自己的代码提交到开源Trafodion社区，首先得准备一套自己的开发环境，有了自己的开发环境，就可以在下载下来的Trafodion源码基础上修改、编译并测试，本篇幅通过详细步骤描述如何搭建Trafodion
数据库基本操作
double_s_c的博客
07-21 474
转载：http://www.cnblogs.com/yejiurui/archive/2012/10/11/2719384.html MySQL数据库CRUD语句快速入门本文目录：SQL语句… 1一、针对数据库database和表table的操作… 11、database和table的常见操作… 12 操作数据库… 23、操作表… 34、针对表中数据的增删改查… 45、表的约束… 96 表的关系…
Trafodion 主要进程介绍
数据源的港湾
03-22 1490
在一个Trafodion正常运行的环境中，通过sqps命令，我们可以查看到Trafodion主要的进程，以下输出是一个3个Trafodion节点的集群环境，[trafodion@n12 esgynDB-2.2.0]$ sqps Processing cluster.conf on local host n12 [$Z001GYK] Shell/shell Version 1.0.1 EsgynDB_
trouble shutting: chkj3008e missing or invalid war file
tianzhihehe的专栏
10-16 543
chkj3008e missing or invalid war file .project文件 &lt;projectDescription&gt;&lt;name&gt; .settings/org.eclipse.wst.common.component文件 安装m2e-wtp 由于直接导出代码然后导入代码建立新工程，name属性与原工程冲突。导致war包创建失败。 ecli...
Linux内核调试工具: Crash - 调试page cache的新工具
weixin_30824277的博客
01-28 159
This article was firstly published from http://oliveryang.net. The content reuse need include the original link. Page cache debug 1. New page cache debug options Recently, my file ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

数据源的港湾

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值