Speed up MT build

In , March 31, 2006

I move both my Site Root(defined at MT publishing settings) and DataSource path(defined at mt-config.cgi) of...

I move both my Site Root(defined at MT publishing settings) and DataSource path(defined at mt-config.cgi) of MT to my Ramdisk, R:\.

That means It's no longer need to access hdd while building sites. It just accesses the Ram. With a test, the speed for building site or building an entry has a dramitic increase, from over 20 mins reduce to 3"50' for rebuilding whole site, and from 2-3 mins reduce to 25s for adding a new entry in my Thinkpad.

The data in Ramdisk will lost after a reboot, I write a .bat file to init the data in Ramdisk and save changes from Ramdisk to hdd.

More about the .bat file please continue to read.

 

继续阅读 "Speed up MT build" 的剩余内容

Posted by Alex at 1:26 AM | Comments (0) | TrackBack (0) | Edit

Lesson 5

In Jeet Kune Do, March 30, 2006

连续三节课没有上，觉得耐力有些下降。练习了几组动作组合前低鞭腿接后高鞭腿前手直拳接后手直拳，再接后高鞭腿前腿侧踹接后腿高鞭腿（要领：侧踹后收腿） 练习了从前没有练习过的踢靶方法并腿踢两人各持单靶对立，靶心向下，齐胸，间距一拳，练习人跑步至靶前垫步跳起，双脚同时并腿向上踢靶分腿踢持靶与上相同，间距加大，练习人跳起分腿向上踢靶双侧踢两人各持单靶对立，靶心相对，齐胸，间距约两步，练习人跑步至靶前，以左腿弹起，同时右腿提膝，侧踹右侧靶，未落地转身左腿踹左侧靶难度很大，除了教练没人能踢得出来要领，跳起时，要向内并左腿，容易发力。跃起侧踹两人各持单靶对立，靶头相接，齐胸，练习人跑步至靶前侧身跃过靶身，并腾空侧踹可在两靶后再用一人持靶，练习人越过两靶，空中侧踹此靶空中两脚两人各持单靶，错开一步相对站立，靶心向下，齐胸，靶头在一条直线上，练习人跑至靶前跃起，以一脚先击打近身靶，未落地另一脚击打远身靶注意并腿，利于发力以左腿跃起时，右腿即提膝做好踢击准备击打时依靠小腿弹动，大腿幅度不打跃起后身体具有向前动量，踢击后落地，两靶都应在身后空中三脚与上类似，加一只靶，成旋转90度的品字型排列，要在空中连续提出三脚难度较高，除了教练没有人能把第三脚踢得稍微好一些第二、第一靶可依次降低一些高度来降低难度练习结束后，静坐调息。...

连续三节课没有上，觉得耐力有些下降。

练习了几组动作组合

  • 前低鞭腿接后高鞭腿
  • 前手直拳接后手直拳，再接后高鞭腿
  • 前腿侧踹接后腿高鞭腿（要领：侧踹后收腿）

练习了从前没有练习过的踢靶方法

  • 并腿踢
    • 两人各持单靶对立，靶心向下，齐胸，间距一拳，练习人跑步至靶前垫步跳起，双脚同时并腿向上踢靶
  • 分腿踢
    • 持靶与上相同，间距加大，练习人跳起分腿向上踢靶
  • 双侧踢
    • 两人各持单靶对立，靶心相对，齐胸，间距约两步，练习人跑步至靶前，以左腿弹起，同时右腿提膝，侧踹右侧靶，未落地转身左腿踹左侧靶
    • 难度很大，除了教练没人能踢得出来
    • 要领，跳起时，要向内并左腿，容易发力。
  • 跃起侧踹
    • 两人各持单靶对立，靶头相接，齐胸，练习人跑步至靶前侧身跃过靶身，并腾空侧踹
    • 可在两靶后再用一人持靶，练习人越过两靶，空中侧踹此靶
  • 空中两脚
    • 两人各持单靶，错开一步相对站立，靶心向下，齐胸，靶头在一条直线上，练习人跑至靶前跃起，以一脚先击打近身靶，未落地另一脚击打远身靶
    • 注意并腿，利于发力
    • 以左腿跃起时，右腿即提膝做好踢击准备
    • 击打时依靠小腿弹动，大腿幅度不打
    • 跃起后身体具有向前动量，踢击后落地，两靶都应在身后
  • 空中三脚
    • 与上类似，加一只靶，成旋转90度的品字型排列，要在空中连续提出三脚
    • 难度较高，除了教练没有人能把第三脚踢得稍微好一些
    • 第二、第一靶可依次降低一些高度来降低难度
练习结束后，静坐调息。

标签 Tags: 其它与截拳道课程 (6) 相关的话题

Posted by Alex at 11:46 PM | Comments (0) | TrackBack (0) | Edit

Pentax 135 Lens FAQ

In Photography, March 30, 2006

因为表格太宽，要完整显示，请点击这里暂时禁止样式单。 恢复样式单，请点击这里，或者刷新本页。    Product Price  Used Price  Issued Date  Lens Constructure Number of aperture blades...

因为表格太宽，要完整显示，请点击这里暂时禁止样式单。

恢复样式单，请点击这里，或者刷新本页。 

  Product
 Price  Used Price  Issued Date  Lens Constructure
Number of aperture blades
 Filter Size
 Maximum magnification Min Aperture  Metering System  Min Focus Distance Weight
Size (diameter x length)
Angel of View
Tripod Mount
Color  Focus Length
Aperture 
 SMC  ED  AL
Star *  Limited
Fixed Power Zoom  Macro
IF  Memo

smcP-DA 12-24mm F4.0 ED AL  899.95 USD       13 in 10
8  77mm  0.12X  F22  TTL open-aperture metering
0.3mm 430g  84 x 87.5mm  99-61°
                           
  smcP-DA 16-45mm  F4.0 ED AL  449.95 USD
    13 in 10 (2 AL) 6  67mm
0.26X  F22  TTL open-aperture metering  0.28m  365g  72x92mm  83-35°
    16-45mm  F4 Y Y  Y
     
        

smcP-DA 18-55mm F/3.5-5.6 AL  199.95 USD       12 in 9 6
52mm  0.34X F22-38  TTL open-aperture metering
 0.25m  225g  68 x 67.5mm  76-29°      
                      

smcP-DA 50-200mm F/4-5.6 ED  199.95 USD       11 in 10  5  52mm  0.24X  F22-32    1.1m  255g  66.5  78.5mm
 31.5-8.1°
                           

smcP-DA 10-17mm F/3.5-4.5 ED IF        10 in 8  6
None  0.39X  F22-32
TTL open-aperture metering
0.14m  320g  68 x 71.5mm  180-100°                            

smcP-DA 14mm F2.8 ED IF  699.95 USD       12 in 11  6
77mm
0.19X
F22  TTL open-aperture metering 0.18m  420g

83.5 x 69mm

90°
                           

smcP-DA 40mm F2.8 LIMITED 349.95 USD       5 in 4
9
49mm
0.13X
F22
TTL open-aperture metering
0.4m  90g  63 x 15mm
39°                            

smcP-D FA 50mm F2.8 MACRO 524.00 USD       8 in 7  8
49mm
1X
F32  TTL open-aperture metering
0.195m  265g
67.5 x 60
47° (31.5° with *istD series)                            

smcP-D FA 100mm F2.8 MACRO  699.00 USD       9 in 8  8
49m
1X?
F32
TTL open-aperture metering
0.303m
345g
67.5 x 80.5
24.5° (16° with *istD series)                            

smcP-FA 43mm F1.9 LIMITED  499.00 USD       7 in 6  8
49mm
0.12X  F22
TTL open-aperture metering
0.45m
155g
64 x 27mm
53°       Black/Silver
                   

smcP-FA 31mm F1.8 LIMITED  1049.00 USD       9 in 7  9
58mm
0.16X
F22
TTL open-aperture metering
0.3m
360g  66.5 x 69mm  70°       Black/Silver
                   

smcP-FA 77mm F1.8 LIMITED  789.00 USD       7 in 6  9
49mm
0.14X
F22
TTL open-aperture metering
0.7m  270g
64 x 48mm
31.5°       Black/Silver                     
smcP-FA J 18-35mm F/4-5.6 AL
 250.00 USD
    12 in 10
   67mm
 0.18X
 F22-32
   0.92 ft.
 6.7 oz.
 2.8 x 2.7"
 100-63°                            
smcP-FA J 28-80mm F/3.5-5.6 AL
 83.00 USD
    8 in 8
   58mm
 0.25X
 F22-38
   0.40m
 180g
 63 x 67mm
 75-30.5°                            
  smcP-FA 28-80mm F3.5-5.6
       8 in 8
   58mm
 0.19X
 F22-38
   0.50m
 275g
 66.5 x 78mm
 75-30.5°                            
smcP-FA J 75-300mm F/3.5-5.8 AL
 200.00 USD
    12 in 10
   58mm
 0.3X
 F32-38
   4.3 ft.
 13.6 oz.
 2.7 x 4.6"
 32-8.2°   Silver
                        
smcP-FA 20-35mm F4.0 AL
 792.00 USD
    10 in 8
   58mm
 0.16X
 F22
   1.0 ft.
 8.6 oz.
 2.7 x 2.7"
 94-64°                            
  smcP-FA 20-35mm F4.0
       15  in 12
 7
 77mm
       0.30m
 600g
 90.5 x 82.5mm
                              
smcP-FA 28-105mm F/3.2-4.5 AL IF
 317.00 USD
    12 in 11
   58mm
 0.19X
 F22-32
   0.50m
 255g
 66 x 65.5mm
 75-23.5°                            
smcP-FA 28-105mm F/4.0-5.6 IF
   850.00 RMB    15 in 12    62mm
0.18X
 F22-32    0.50m
 305g
 72 x 74mm
 75-23.5°                            
 
 smcP-FA 28-105mm F/4.0-5.6 Power Zoom
       13 in 11   58mm
0.33X  F22-32    0.43m
 515g
 72.5 x 95.5mm
 75-23.5°                            
  smcP-FA 28-200mm F/3.8-5.6 AL IF        16 in 14
  73mm
 0.21X
 F22-32
   0.52m
 465g
 78 x 83mm
 75-12.5                            
smcP-FA 50mm F1.4
 315.00 USD
2050.00 RMB?
   7 in 6
   49mm
 0.15X?
 F22
   0.45m
 220g
 65 x 37mm
 47°                            
smcP-FA 35mm F2.0 AL
 475.00 USD
    6 in 5
 8
 49mm
 0.17X
 F22
   1.0 ft.
 6.9 oz.
 2.5 x 1.8"
 63°                            
  smcP-FA* 200mm F2.8 ED IF
       9 in 8
   77mm
 0.20X F32
   1.2 ft.
785g
83 x 134mm
 12.5°                            
smcP-FA 300mm F2.8 ED IF
       10 in 7
   112mm, 43mm
  F32
  6.6 ft.
93.8 oz. w/hood
5.3 x 13.4"
8.2°                           Lens Hood built-in
smcP-FA* 300mm F2.8 ED IF
 6067.00 USD
    10 in 7
   112mm, 43mm
 0.17X
 F32
   2.0m
 2500g
 123 x 247mm
 8.2°                            
  smcP-FA* 300mm F4.5 ED IF
    9 in 7
   43mm
 0.17X
 F32
   2.0m
 935g
 72.5 x 160mm
 8.2°                            
smcP-A* 300mm F2.8 ED IF
 6876.00 USD
                                                   
smcP-A 400 F5.6
 2172.00 USD
                                                   
  smcP-FA* 400mm F5.6 ED IF
       9 in 8
  77mm
0.23X
 F45
  2.0m
 1140g
 83 x 199mm
 6.2°                            
  smcP-FA* 600mm F4.0 ED IF
       9 in 7
   150mm, 43mm
 0.13X
 F32
  5.0m
 7000g w/tripod mount
 176 x 457mm
4.1°                            
smcP-A* 600mm F5.6 ED IF
 7400.00 USD
                                                   
smcP-K Bellows 100mm F4.0
 330.00 USD
                                                   
smcP-FA J 75-300mm F/4.5-5.8 AL
 200.00 USD
    12 in 10
   58mm
 0.30X
 F32-38   1.30m
 385g
 69 x 116mm
 32-8.2
                            
  smcP-FA 35-80mm F/4-5.6
       7 in 6
   49mm
 0.25X
 F22-32
   0.40m
 160g
 66.5 x 58mm
 63-30.5
                            
  smcP-F 35-80mm F/4-5.6
       7 in 6
   49mm
       0.40m
 186g
65 x 58mm
                              
smcP-FA 70-200mm F/4-5.6 Power Zoom
   650.00 RMB(2)
   10 in 8
   49mm
 0.25X
 F32-45
   1.10m
 465g
 73 x 116.5mm
 34.5-12.5
                            
smcP-FA 28mm F2.8 SOFT
       5 in 5
 8
 49mm
 0.25X
 F22
   0.30m
 194g
 40 x 65.5mm
 75°
                            
  smcP-FA 85mm F2.8 SOFT
       5 in 4
   52mm
 0.25X
 F32
   0.50m
 305g
 66 x 60mm
 28.5
                            
smcP-FA 24-90mm F/3.5-4.5 AL IF
       13 in 11
   67mm
 0.18X
 F22-32
   0.50m
 355g
 72 x 74.5mm
 84-27°                            
smcP-FA 28-70mm F2.8 Power Zoom?
       14 in 11
   67mm
 0.25X
 F22
   0.43m
 800g w/hood
 3.3 x 4.1" (4.1 x 5.9" w/hood)
 75-34.5°                            
  smcP-FA *28-70mm F2.8 AL Power Zoom
       14 in 11
   67mm
 0.25X
 F22
   0.43m
 800g
 84.5 x 104mm
 75-34.5°                            
  smcP-FA *28-70mm F4.0 AL Power Zoom
       9 in 7
   52mm
 0.23X
 F22
   0.40m
 240g
 65.5 x 66mm
 75-34.5°                            
smcP-FA 28-90mm F/3.5-5.6
       10 in 8
   58mm
 0.28X
 F22-38
   0.40m
 195g
 66.5 x 67.5mm
 75-27°                            
smcP-FA 20mm F2.8       10 in 9
 6
 67mm
 0.12X
 F22
   0.25m
 9 oz.
 70 x 44mm
 94°                            
smcP-FA* 24mm F2.0 AL IF
       11 in 9
   67mm
 0.12X
 F22
   0.30m
 405g
 72.5 x 65.5mm
 84°                            
smcP-FA 28mm F2.8 AL
       5 in 5
   49mm
 0.13X
 F22
   0.30m

185g,
6.5 oz.

66 x 40.5mm, 2.5 x 1.6"
 75°                            
smcP-FA 24mm F2.0 AL IF
       11 in 9
 8
 67mm
   F22
   0.30m
 14.3 oz.
 2.9 x 2.6"
 84°                            
smcP-FA 50mm F1.7
       6 in 5
   49mm
 0.15X
 F22
   0.45m
 170g
 65 x 37mm
 47°                            
smcP-FA 80-200mm F2.8 ED IF
       16 in 13
   77mm
 0.19X
 F32
   4.6 ft.
 55.4 oz. w/hood
 3.4 x 7.5" (4.1 x 9.4" w/hood)
 30.5-12.5°                            
  smcP-FA* 80-200mm F2.8 ED IF Power Zoom
       16 in 13
   77mm
0.19X
 F32
   1.40m
 1570g w/tripod mount
 87.5-191.5mm
 30.5-12.5°                            
  smcP-FA 80-200mm F/4.7-5.6
       11 in 7
  49mm
 0.25X
 F32-38
   1.10m
270g
65 x 97.5mm
 30.5-12.5°                            
  smcP-F 80-200mm F/4.7-5.6
       11 in 7
  49mm
 0.25X
 F32-38
   1.10m
295g
65 x 97.5mm
 30.5-12.5°                            
  smcP-FA 80-320mm F/4.5-5.6
       13 in 10
  58mm
 0.28X
 F32-38
   1.50m
 550g
 74.5 x 129mm
 30.5-7.7                             
smcP-FA 100-300mm F/4.7-5.8
       11 in 9
   58mm
 0.26X
 F32
   4.9 ft.
 14.5 oz.
 2.8 x 5.1"
 24.5-8.2°                            
  smcP-F 100-300mm F/4.5-5.6
       12 in 8
  58mm
 0.25X
 F32-38
   1.50m
 605g
 71.5 x 154.5mm
 24.5-8.2
                           
smcP-FA 250-600mm F5.6 ED IF
       18 in 16
   43mm (rear)
 0.2X
 F32
   11.5 ft.
 178.1 oz.
 5.3 x 17.4"
 9.9-4.1° Y
                         Lens Hood built-in
  smcP-FA* 250-600mm F5.6 ED IF Power Zoom
       18 in 16
   43mm (rear) 112mm(front)
 0.2X
 F32
   3.50m
 5600g w/tripod mount
 134 x 442mm
 9.9-4.1° Y
                          
smcP-FA 85mm F1.4 IF
       8 in 7
   67mm
0.1X
 F22
  
 2.8 ft. 
21.8 oz. w/hood
 3.1 x 2.8"
28.5°                            
  smcP-FA* 85mm F1.4 IF
       8 in 7
   67mm
 0.11X
F22
  
 0.85m
 550g
 79 x 70mm
28.5°                            
smcP-FA 135mm F2.8 IF
       8 in 7
   52mm
0.25X
 F22
 
 2.3 ft.
375g
 68 x 80mm
 18°                            
smcP-FA 200mm F2.8 IF
       9 in 8
   77mm
0.14X
F32
  4.7 ft.
28.9 oz. w/hood
 3.2 x 5.3"
12.5° Y
                          
smcP-FA 600mm F4.0 ED IF
       9 in 7
   43mm (rear)
   F32
   16.4 ft.
 227.5 oz. w/hood
 6.9 x 18"
 4.1°                            
smcP-FA 50mm F2.8 MACRO
   1450.00 RMB?   8 in 7
   52mm
1.0X
F32
  0.6 ft.
13.6 oz.
2.7 x 2.8"
47°                            
smcP-FA 100mm F2.8 MACRO
       9 in 8
   58mm
1.0X
F32
  1.0 ft.
21.2 oz.
2.9 x 4.0"
24.5°                            
smcP-FA 100mm F3.5 MACRO   1425.00 RMB?
   5 IN 4
   49MM
0.5x
F22
  1.41 ft.
7.8 oz.
2.7 x 2.8"
24.5°                            
smcP-FA 200mm F4.0 ED MACRO
      
 12 in 9
 
67mm
1.0X
F32
  1.69 ft.
 38.2 oz.
2.9 x 7.5"
12.5° Y
                          
  smcP-FA* 200mm F4.0 ED IF MACRO
      
 12 in 9
 
    F32
  0.514m
     12.5°                            
  Product
 Price  Used Price  Issued Date  Lens Constructure
Number of aperture blades
 Filter Size
 Maximum magnification Min Aperture  Metering System  Min Focus Distance Weight
Size (diameter x length)
Angel of View
Tripod Mount
Color  Focus Length
Aperture 
 SMC  ED  AL
Star *  Limited
Fixed Power Zoom  Macro
IF  Memo
  smcP-M 50mm F1.4
   650.00 RMB
                                                  
  smcP-M 28mm F3.5
   60.00 USD
                 180g
                                
  smcP-M 35mm F2.8
   100.00 USD
                                                  
  smcP-M 85mm F2.0
   170.00 USD
                 250g
                                
  smcP-M 120mm F2.8
   130.00 USD
       49mm
         270g
                                
smcP-M 135mm F3.5
   600.00 RMB?
       49mm
         270g
                                
  smcP-M 150mm F3.5
           49mm
         290g
                                
  smcP-M 200mm F4.0
   1000.00 RMB
      52mm
         405g
                                

smcP-M 40-80mm F/2.8-4 MICRO    850.00RMB?
                                                  
                                                         
                                                         
  Product
 Price  Used Price  Issued Date  Lens Constructure
Number of aperture blades
 Filter Size
 Maximum magnification Min Aperture  Metering System  Min Focus Distance Weight
Size (diameter x length)
Angel of View
Tripod Mount
Color  Focus Length
Aperture 
 SMC  ED  AL
Star *  Limited
Fixed Power Zoom  Macro
IF  Memo
smcP-A 15mm F3.5
      13 in 12
   NONE
   F22
   1.0 ft.
 20.9 oz.
 3.1 x 3.2"
 111°                           Filter Built-in, UV, Y2, O2, Skylight
smcP-A 20mm F2.8
       10 in 9
   67mm
   F22
   0.8 ft.
 8.6 oz.
 2.8 x 1.7"
 94°                            
smcP-A 50mm F2.0
       5 in 5
   49mm
   F22
   1.5 ft.
 5.1 oz.
 2.5 x 1.2"
 47°                            
smcP-A 50mm F1.2
       7 in 6
   52mm
   F22
   1.5 ft.
 12.1 oz.
 25 x 1.9"
 47°                            

smcP-A 35-80mm F/4.0-5.6
       7 in 6
  49mm
0.25X
F22    1.3 ft.  6.5 oz.
2.5 x 2.3"
 63-30.5°                            
smcP-A 80-200mm F/4.7-5.6
       11 in 7
   49mm
 0.25X
 F32
   3.6 ft.
 10.4 oz. 2.5 x 3.9"
 30.5-12.5°                            
smcP-A 50mm F2.8 MICRO
   1500.00 RMB?
                                                  
smcP-A 50mm F1.7
   700.00 RMB?
                                                  
  Product
 Price  Used Price  Issued Date  Lens Constructure
Number of aperture blades
 Filter Size
 Maximum magnification Min Aperture  Metering System  Min Focus Distance Weight
Size (diameter x length)
Angel of View
Tripod Mount
Color  Focus Length
Aperture 
 SMC  ED  AL
Star *  Limited
Fixed Power Zoom  Macro
IF  Memo
smcP Reflex 400-600mm F/8.0-12
       12 in 7
   67mm, 40.5mm
     NONE
 9.8 ft.
 25.7 oz.
 3.2 x 4.3" 6.2-4.1°                           rear mount filters (normal, sky, Y8, R60, ND 2x, 2.8x, 4x)
  Fisheye Zoom 17-28mm F/3.5-4.5
       9 in 7
           0.45m
 158g
 61 x 65mm
                              
smcP-F 50mm F1.7
   1200.00RMB(1)
                                                  
smcP-A 100mm F4
                                                      
smcP-A 100mm F2.8
                                                      
                                                         

继续阅读 "Pentax 135 Lens FAQ" 的剩余内容

标签 Tags: 其它与135 (1), FAQ (3), Lens (1), Pentax (6), PK (6), 宾得 (6), 镜头 (4) 相关的话题

Posted by Alex at 11:26 AM | Comments (0) | TrackBack (0) | Edit

CASE WHEN in views reduces performance

In DB2 Development, March 29, 2006

The complex CASE WHEN in fullselect statement would reduce performance much. We could call SQL Score...

The complex CASE WHEN in fullselect statement would reduce performance much. We could call SQL Score functions instead of the place of CASE WHEN, it could be 15X improved in following example.

NOTE: However, CASE WHEN is better than IF ELSE which is slower. But you can not use CASE WHEN END; in functions. It reports unrelated and strange error as compiling.

继续阅读 "CASE WHEN in views reduces performance" 的剩余内容

标签 Tags: 其它与DB2 Development (24) 相关的话题

Posted by Alex at 6:31 PM | Comments (0) | TrackBack (0) | Edit

Later-Bound variables in cursors

In DB2 Development, March 29, 2006

following code would be fine:declare var1 datatype;declare mycur cursor for    select * from table1    where column...

following code would be fine:

declare var1 datatype;
declare mycur cursor for
    select * from table1
    where column = var1;

set var1 = 'varlue';
open mycur;

the results would be limited with the condition "where column = var1" as your wish.

 

标签 Tags: 其它与DB2 Development (24) 相关的话题

Posted by Alex at 6:12 PM | Comments (0) | TrackBack (0) | Edit

DEFAULT 不能代替NOT NULL

In DB2 Development, March 29, 2006

字段定义有default 值并不代表可以省略not null定义，可如下测试：create table zytest(a int default 9);insert into zytest values(default);insert into zytest values(1);insert into zytest...

字段定义有default 值并不代表可以省略not null定义，可如下测试：

create table zytest(a int default 9);
insert into zytest values(default);
insert into zytest values(1);
insert into zytest values(null);

select * from zytest;

a
----
9
-
1

update zytest set a = null where a = 1;

select * from zytest;

a
----
9
-
-

update zytest set a = default where a is null;

select * from zytest;

a
----
9
9
9

标签 Tags: 其它与DB2 Development (24) 相关的话题

Posted by Alex at 6:06 PM | Comments (0) | TrackBack (0) | Edit

SQL0332N Reason Code 1

In DB2 Development, March 29, 2006

dos> db2 connect to db_name user xxx using ***SQL0332N 没有从源代码页“819”至目标代码页“1386”的转换，原因码是“1”SQLSTATE=57017原因：连接的数据库使用的代码页设置（819）与本地客户端设置的代码页（1386）不同 之间无法进行双向转换，即无法将GBK 编码的字符转换为ISO-8859-1字符，解决方法：dos> db2set DB2CODEPAGE=819dos> db2 terminatedos>... 
dos> db2 connect to db_name user xxx using ***

SQL0332N 没有从源代码页“819”至目标代码页“1386”的转换，原因码是“1”
SQLSTATE=57017


原因：连接的数据库使用的代码页设置（819）与本地客户端设置的代码页（1386）不同 之间无法进行双向转换，即无法将GBK 编码的字符转换为ISO-8859-1字符，解决方法：

dos> db2set DB2CODEPAGE=819
dos> db2 terminate
dos> db2 connect to db_name user xxx using ***
连接成功。

如果数据库是UTF-8 encoded，本地客户端的代码页是1386，则可以正常连接，不存在此问题。

对于本地的代码页似乎只能设置一个值
，因此如果需要同时连接多个具有不同代码页的数据库，就会比较麻烦，无法做到真正的同时连接，只能每次使用上面的命令切换。

标签 Tags: 其它与DB2 Development (24) 相关的话题

Posted by Alex at 5:46 PM | Comments (0) | TrackBack (0) | Edit

Tablespaces are put into backup pending after a load

In DB2 Administration, March 29, 2006

DB2 sets tablespace as Backup Pending state after loading data into a table in linear logging...
DB2 sets tablespace as Backup Pending state after loading data into a table in linear logging database(that is, logretain or userexit is on), whatever the load is successful or failed. the reason is that the load process will not write log file. from the begin time of loading to the end time of loading, there will be a blank segment in log file, and the rollforward recovery can Not jump over the blank segment to apply the later log file.

so database needs a backup after loading to make sure db2 have recovery capicibility.

it's able to use [COPY YES|NO]  or [NONRECOVERABLE] to prevent tablespace go into Backup Pending state. COPY YES will do the backup automatically after loading, and COPY NO and NONRECOVERABLE will give up this backup that means db2 will be not able to recover the database once an serious error occured.


继续阅读 "Tablespaces are put into backup pending after a load" 的剩余内容

标签 Tags: 其它与DB2 Administration (13), Load (1), Tablespace (1) 相关的话题

Posted by Alex at 5:31 PM | Comments (0) | TrackBack (0) | Edit

SQL0181N

In DB2 Development, March 27, 2006

SQL0181N  日期时间值的字符串表示法超出范围。  SQLSTATE=22007 I got this error when I try to insert following timestamp. '2006-02-29-01.04.00.000000'There's no 29th...

SQL0181N  日期时间值的字符串表示法超出范围。  SQLSTATE=22007 

I got this error when I try to insert following timestamp. 

'2006-02-29-01.04.00.000000'

There's no 29th in Feb, 2006, ;)

标签 Tags: 其它与DB2 Development (24) 相关的话题

Posted by Alex at 5:36 PM | Comments (0) | TrackBack (0) | Edit

My equipments on Photography

In Photography, March 27, 2006

135 Camera Bodies Pentax *ist DS 135 LensPentax smcP-DA 16-45mm F4.0 ED ALPentax smcP-M 50mm F1.4Ricoh XR...

135 Camera Bodies 

Pentax *ist DS

135 Lens

Pentax smcP-DA 16-45mm F4.0 ED AL

Pentax smcP-M 50mm F1.4

Ricoh XR RIKENON 200mm F4.0

Tripods

Triopo T-1127 

Heads

Giottos MH1001-652 

Giottos MH1000-621

Flash Light

Misc 

RC-SET 3 Remote Control

Pentax 近摄接圈 1、2、3号 

KENKO Pz-AF 1.5X TELEPLUS SHQ 增倍镜

Marlans 帆布摄影包 

瑞士产汽吹 

 

标签 Tags: 其它与DSLR (1), 器材 (1), 摄影 (3), 数码单反 (1) 相关的话题

Posted by Alex at 2:51 AM | Comments (0) | TrackBack (0) | Edit

Pentax M 50mm F1.4 smc

In Photography, March 27, 2006

I got an used Pentax manual len, M 50mm F1.4 smc at Wukesong. it spent me...

I got an used Pentax manual len, M 50mm F1.4 smc at Wukesong. it spent me 650rmb with 7 days guarantee. I take the trial photos for it, it's a great len, has very nice outside of focus(焦外成像).

smcP-M 50 F1.4

这个镜头的大光圈解像力稍差，焦外也不是十分理想，在F2.8 及以上则不错，不过最大光圈在光线暗的时候还是提供了非常宝贵的快门速度。 

镜头中有些灰。 

继续阅读 "Pentax M 50mm F1.4 smc" 的剩余内容

标签 Tags: 其它与Pentax (6), PK (6), 宾得 (6), 镜头 (4) 相关的话题

Posted by Alex at 2:36 AM | Comments (0) | TrackBack (0) | Edit

Triopo T-1127 tripod & Giottos MH1001-652 Head

In Photography, March 27, 2006

<