回歸....

七月尾,我由數碼港搬到了在鰂魚涌的office, 經過了四個月後,再由鰂魚涌搬回來了數碼港..

人是回歸了,但坐位,工作性質也不同了,想當日是因為那"神奇"的project 已導致我們要搬到鰂魚涌去, 到步的第二天,便因為人手的重組,所以我和另一位的同事就去了另一team 去,由front end 走到了backend, 經過了四個月,東西也算是上手了吧, 何況我對自己的learning curve 有一定的信心, 所以總不算是太難倒我吧 :p

上星期尾時我的manager 走來對我說,由於之前交上的skill set 給政府的其中一個project 選中,問我有冇興趣去試一下(那算是一個短期的Secondment),不過因為真係太短,而且是太趕了吧(十二月七日便要到那邊),只是得三個月而且那個政府project 所做的應該是一個web protal 的development, 那種如此短又趕的東西,總是不好做, 恐怕到時會OT 都傻,這隻吃力不討好的東西還是不太適合我吧. :p

更何況現在在做的東西,反而有一點是我喜歡做的, 雖然front end 的development 我也同樣的喜歡,但back end 時所做的problem solving 那種成功感,和front end 的是兩種不同的東西呢!!

閱讀內容...

隱藏內容...

teradata error code

Return Code = 04 ( BTEQ returns a return code of 04 for the following Teradata error codes )
2580 - Mload not active on table %TVMID.
2667 - Statistics cannot be collected on an empty table.
3534 - Index already exists.
3666 - This view has too many columns to store or retrieve comments.
3737 - Name is longer than 30 characters.
3747- No start-up string defined for this user.
3803 - Table “%VSTR” already exists.
3804 - View “%VSTR” already exists.
3805 - Macro “%VSTR” already exists.

Return Code = 08 ( BTEQ returns a return code of 04 for the following Teradata error codes )

CLI0530 -Character set name or code unknown.
2123- A segment could not be read successfully.
2538 -A disk read error occurred in the tables area.
2541- End of hash code range reached.
2632- All AMPs own sessions for this Fast/MultiLoad
2639 - Too many simultaneous transactions.
2641 %DBID.%TVMID was restructured. Resubmit.
2644 No more room in database %DBID.
2654 Operation not allowed: %DBID.%TVMID is being restored.
2805 Maximum row length exceeded in %TVMID.
2809 Invalid recovery sequence detected.
2815 Apparent invalid restart of a restore.
2818 Invalid lock to dump table without after image journaling.
2825 No record of the last request was found after Teradata Database restart.
2826 Request completed but all output was lost due to Teradata Database restart.
2827 Request was aborted by user or due to statement error.
2828 Request was rolled back during system recovery.
2830 Unique secondary index must be dropped before restoring table.
2835 A unique index has been invalidated. Resubmit request.
2837 Table being fast loaded; no data dumped.
2838 Table is unhashed; no data dumped.
2840 Data rows discarded due to inconsistent hash codes.
2843 No more room in data base.
2866 Table was recovery aborted; no data dumped.
2868 This permanent journal table is damaged; no data dumped.
2920 Delete journal and AMP down without dual.
2921 No saved subtable for journal %DBID.%TVMID.
2926 No more room in %DBID.%TVMID.
3001 Session is already logged on.
3111 The dispatcher has timed out the transaction.
3116 Response buffer size is insufficient to hold one record.
3119 Continue request submitted but no response to return.
3120 The request is aborted because of a Teradata Database recovery.
3523 %FSTR does not have %VSTR access to %DBID.%TVMID.
3524 %FSTR does not have %VSTR access to data base %DBID.
3566 Data base does not have a PERMANENT journal.
3596 RESTORE Teradata Database invalid if table, view or macro exists outside of
Teradata Database.
3598 Concurrent change conflict on data base; try again.
3603 Concurrent change conflict on table; try again.
3613 Dump/restore, no hashed nonfallback tables found.
3656 Journal table specified no longer exists.
3658 ROLLBACK/ROLLFORWARD table specifications are invalid.
3705 Teradata SQL request is longer than the Simulator maximum.
3802 Database “%VSTR” does not exist.
3807 Table/view “%VSTR” does not exist.
3824 Macro “%VSTR” does not exist.
3873 “%VSTR” is not a journal table.
3877 NO FALLBACK specified and the table is FALLBACK.
3897 Request aborted due to Teradata Database restart. Resubmit.
3916 Requested information not in dictionary.
5495 Stored Procedure %VSTR does not exist.

Return Code = 12 ( BTEQ returns a return code of 04 for the following Teradata error codes )
CLI0001 Parameter list invalid or missing.
CLI0002 Invalid number of parameters received.
CLI0003 Error validating HSIRCB.
CLI0004 Error validating HSICB.
CLI0005 Error validating HSISPB.
CLI0006 Invalid destination HSICB detected.
CLI0007 Invalid destination RCB detected.
CLI0008 DBCFRC unable to free RCB/HSICB control blocks because they are not
contiguous in storage.
CLI0009 Invalid DBCAREA pointer or id.
CLI0010 ECB already waiting.
2971 The AMP lock table has overflowed.
2972 No table header exists for table.

http://teradatadevelopers.blogspot.com/

閱讀內容...

隱藏內容...

五年 ....

早幾天,login wow 時在mailbox 入面有隻pet...是 World of warcraft 5歲的生日禮物,不經不覺原來就打左隻game 差唔多五年了...

閱讀內容...

隱藏內容...

畢業典禮

上星期六,是女友的畢業日子,本來沒有飛入原場睇的我,竟然幸運地在排隊時,後面的哥仔聽到我地差一張飛而佢因為有一位朋友沒有來所以多了一張飛,所以給了我讓我走進了場, 所以能夠進場影相加拍片.竟然會有咁好彩的事情,真係難以致信...



如果比起當年我在浸大畢業所用的大學會堂,教院的畢業場地是細很多, 但由放它的細, 所以我用部500D 的kit 鏡都可以影到下相, 如果是AC hall, 恐怕要用kit 鏡的話我諗都要坐得好鬼前先得lu....

典禮後,陪著女友四週找她的朋友照相, 現在相比起從前真係多左好多人用DSLR(當然我也加入了), 想當年我畢業時邊有咁多人用單鏡的, 不過講開畢業相,又令我想起我一下唔覺意咁format 左部機, 當年我所影的畢業相冇鬼晒,真係一個GG... =.=, 現在能找到的真係少的很的..

最後恭喜女友辛苦了三年終於畢業,一邊工作一邊讀書真係不易的....辛苦你了...

閱讀內容...

隱藏內容...

storage free upgrade

之前因為放爆了picasa 的免費空間,所以用了20美金買了多10G 的空間

不過最近google他們加多了新plan 也為舊的plan 更新了, 20美金可以買80G 的空間呢,而且也為舊有客戶upgrade 了...一下子多了70G 出來, 真係點放都應該放唔晒.... :p

不過如果佢早d出呢d plan , 我就會選5美金for 20G la.... =.=, 或者下次renewal 時可以考慮一下downgrade , 雖然20美金一年都唔係貴, 不過真係好似用唔晒咁....

閱讀內容...

隱藏內容...