DB2
in [SQL]
|
CLP giving weird error code for simple SQL I'm using the CLP on a Windows XP machine, DB2 ESE 9.5. I connect to the SAMPLE database and issue the following command : db2 select * from proj where deptno <> 'E21' and the response I get is : was unexpected at this time. If I use the command editor application (GUI thingie) and enter the same comma... 21 May 2010 04:03
IMPORT vs. LOAD Hi! Today we had a hot discussion about the performance of LOAD vs. IMPORT. I'd like to hear what you have to say: - Should LOAD be faster that IMPORT in every circumstance? - Is IMPORT more suited for small files and LOAD for large files? - Is LOAD more suited for table that have many indexes and IMPORT for tab... 1 Jun 2010 09:43
HADR is failing during online backup HADR is failing during online backup. the stand by goes in the Remote catchup pending while backup is in progress on primary. once backup is completed the standby comes to Peer state. ... 19 May 2010 12:39
Unable to find donor to satisfy minSize constraint We're running DB2 V9.1.0.4 on AIX 5.3. We're receiving this message in db2diag.log. 2010-05-19-09.47.14.651270-240 I1089667A438 LEVEL: Warning PID : 2125870 TID : 1 PROC : db2stmm (DB_SIMS) 0 INSTANCE: db2sims NODE : 000 DB : DB_SIMS APPHDL : 0-1359 ... 20 May 2010 08:20
Try IBM preperation series You can find pdfs by IBM. Search for 730 preperation series, you should find the relevant material. And it's more than good for fundamentals. Ankita Singh wrote: Hi 12-May-10 Does anyone have dump for db2 certification exam 730 Previous Posts In This Thread: Submitted via EggHeadCafe - Software De... 18 May 2010 15:52
Can a raw device container extension be combined with auto-storage? Hello, For a while, I've followed a strategy of moving away from raw devices, and to use automatic storage - in order to simplify database management. But given the increasing smartness of storage systems (where it's easy to extend the size of a LUN, for example), I find it tempting to re-think our strategy... 19 May 2010 08:13
DB2 DBA - Distributed Database Administrator required at Morgan Stanley, UK, London Apply through the following link: DB2 DBA - Distributed Database Administrator required at Morgan Stanley, UK, London http://www.morganstanley.com/about/careers/careersearch.html?cpUrl=http://careers.peopleclick.com/careerscp/client_ms/external/gateway.do?functionName=applyFromLink&source=&jobPostID=263938&locale=... 15 May 2010 06:08
Create Index in Separate table space I'm Running on DB2 9.5/AIX, currently involved in Migration from Ora to DB2. In oracle i've following statement. CREATE INDEX ITEM_IDX ON ITEM (LOWER("ITEM_NAME"), ITEM_ID) TABLESPACE IDX_TBS; I'm not able to find the corresponding syntax in DB2, goggled it but still not able to find the solution. I assu... 20 May 2010 06:12
Disabling a MQT in db2 9.7 I'm running into an odd problem - I'd like to disable a user- maintained MQT in db2 9.7. The online documentation for db2 9.7 has been enhanced to death. The closest link I can seem to find is this: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.doc/doc/t0005319... 13 May 2010 03:57
Yellowfin discusses, Selection criteria for an in-memory analysis solution The evolution of reporting and analytics has seen dramatic changes in recent years. Starting with static green bar reports in the mid-to- late '70s, information could be abstracted from mainframe systems and, often manually, transferred to spreadsheets where data could be aggregated and analyzed. Data warehousi... 12 May 2010 08:01 |