View Full Version : db2 answers

Pages : 1 2 [3] 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  1. Clob
  2. Primary Key error wrong number of qualifiers
  3. DB2 9.5 equivilent of alternate fixpack
  4. how to ensuring MQT freshness
  5. SQL0101N The statement is too long or too complex. SQLSTATE=54001
  6. DB2 UDB LUW full time positions in California
  7. V9 client accessing V7.2 server
  8. SQL27984W - Some information has not been saved (import create mode)
  9. Delete and concurrency problems
  10. DB2 Consultants required at Bangalore
  11. DB2 Consultants required at Bangalore
  12. Need help with dayofweek function
  13. Temp table issue
  14. Temporary table issue
  15. Problem using/naming subquery
  16. Query about DB2 unload
  17. DB2 update using CTE
  18. db2 hash functions
  19. Use of inequality in where clause
  20. query on query plan and MQT
  21. Type 3 driver definitely dead in DB2 V9?
  22. Need help to replace OLAP
  23. Specifying statement delimiter in DB2 Universal JDBC Driver
  24. Can JOIN be used as alternative to NOT EXIST
  25. db2gcf -k, Why is it used?
  26. NEWLOGPATH and folder NODE000
  27. DB2 Host variables - PL/1 locator reference
  28. Best way to create a table
  29. load and generatedoverride
  30. migration of db2
  31. Help with rollforward through most current active logs
  32. DB2 hangs on USEREXIT failure.
  33. Archival logging and USEREXIT BEHAVIOR.
  34. Statistics on temporary tables?
  35. why this 2-column index not used
  36. Enforcing one-to-many relationship in an existing join table
  37. Property for setting codepage or codeset in JDBC
  38. LUW generation 8 -> 9.1 or 9.5 experiences?
  39. Sybase IQ to DB2 for LUW migration helps
  40. Can constraint replace a trigger?
  41. lowering HWM
  42. Unique db id required for n-tier websphere application
  43. DB2 dynamci Query execution ??
  44. Viewing table constraints
  45. db2 design advisor giving error SQL0180N The syntax of stringrepresentation of a datetime value is incorrect
  46. DB2 does not complain(or warn) about data loss
  47. How to form a date value from decimal or smallint values
  48. IDUG North America 2009 - Denver (May 11-15, 2009) - Call for
  49. QUESTION: Task Center job won't complete
  50. Select and Inserting into two different databases
  51. Re: How to fix duplicate SSN without table recreration?
  52. Potential abolition of leap seconds - USNO impact survey
  53. How to learn IBM-DB2
  54. Can we create UDF using View instead of table
  55. host variables in cobol
  56. what is DB2INSTDEF
  57. default timestamp value and performance
  58. DB2 taking a long time to start archiving logs
  59. SQLerror code
  60. Problem in getting the columns name in export command
  61. SQLCACHE_SNAPSHOT function returns no records.
  62. db2ckpwd not running under root
  63. Re: select in a stored procedure call
  64. question: multiple row insert vs. merge
  65. deleting backups with db2adutl and meaning of keep parameter
  66. Generate 'Create database' statement
  67. set write suspend on database takes multiple hours
  68. How calculate date/time difference in DB2
  69. Location Intelligence where to from here?
  70. Join two identically structured views
  71. Sql Stored Procedure
  73. Filter Factors when using Parameter markers?
  74. How to implement insensitive scroll cursor
  75. isolation levels and locks
  76. Array Insert x db2Import
  77. what wrong with my UDF use?
  78. DB2 partial matching in COBOL
  79. How to prevent duplicate insertion without locking the entire table?
  80. DB2 Response File Installation
  81. Exporting large data from QMF to mainframe dataset
  82. read only database
  83. Re: Reg: Owner for Declared Global Temporary tables
  84. FP2 Vista cannot configure default instance
  85. remove DB2 Connect Server ?
  86. Do you know how I can monitor z/os DB2 activity from a unix/windowsmachine?
  87. Problem DB2 9.5 connection to Iseries
  88. DB2 RTCL for linux
  89. Db2 Dba
  91. Create Database with RESTRICTIVE Option
  92. Load syntax help!!!!
  93. Software Problem resolution
  94. Query plan / table partitioning
  95. Strange 911 error
  96. Re: Statements with 2MB size
  97. Large number of reads on sysibm.sysuserauth.
  98. Re: select rows where
  99. soliddb db2 sql conformance?
  100. dumps for db2 certification no 730 and 731
  101. What is DB2 agent ???
  102. How to move tables into different tablespace ?
  103. DPF on 9.5
  104. Scalar sub query in db2
  105. Multible inserts in one Trigger - return code -206
  106. Multiple tables or single table in one tablespace ?
  107. How to get top 1000 rows
  108. Temporary Table
  109. LDAP authentication
  110. problem in creating a db
  111. sysproc.snapshot_tbreorg: What does rergo_status value '4' means ?
  112. Please Help: Insert generating -803 in Trigger
  113. Re: Recursive Data and Stored Procedure in DB2
  114. Runstats / OLTP environment
  115. db2 700 exam
  116. DB2 Best Practices
  117. SQL0101N The statement is too long or too complex.
  118. tablespace queisced after load fail in partioned db
  119. Automate Log shipping
  120. DB2 Migrate to Oracle
  121. How to replaces 1 with corresponding position
  122. Project Management Knowledge Base !
  123. Dynamic SQL
  124. how to get db2 lock waits details
  125. SQL query help
  126. Verify attribute content
  127. Range partition overlap
  128. SQL30081N error while connecting to a DB2 ver. 7.2 Database
  129. connecting servers for playing with HADR
  130. SQL0440 error on delete statement
  131. DB2MOVE
  132. Control Center extension
  133. Removing a newline character from a VARCHAR
  134. Moving tables between tablespaces
  135. Regarding concurrency MERGE x UPDATE
  136. Date function help subtracting dates
  137. recursive query - donot repeat the sub path that has already beendiscovered in the tree
  138. Sybase to DB2 Migration
  139. DB2 Stored Procedure Refresh
  140. DB2 Stored Procedure Refresh
  141. installing db2 connect product on a machine with db2 ese alreadyinstalled
  142. How to access DB2 using DataSource?
  143. Embedded SQL returning uncatchable error - Procedure/Trigger
  144. DB2 on AIX - Authenticate against Active Directory
  145. DB2 UDB Objects Dependent on UDF
  146. Max Lehgth Of A Row In Db2
  147. Db2 loading from Tab delimited Txt file
  148. Database release level
  149. Max Length Of Varchar
  150. How to Write this SQL Statement?
  152. SUM function with conditions (>) or (<)
  153. Can't view tables through Control Center
  154. db2 get snapshot for dynamic sql output question
  155. Problem with Db2 Export Command
  156. matching criteris for a 10-digit number
  157. DB2 backup Valid or Corrupted
  158. DB2 Web Tools - Error code 101
  159. First iteration of stored procedure is slow.
  160. Having problem restoring incremental backup
  161. db2 procedure in solaris
  162. Alternate server for the db2 connect --fail over
  163. DB2 V9.5 FP2 release date
  164. ErrorCode
  165. Re: SQL 2008 published - Highlights
  166. Recursive SQL Question on breaking the infinite loop.
  167. Add a DB2 database partition in different drive
  168. Add a DB2 database partition in different drive
  169. Add a DB2 database partition in different drive
  170. Add on New partition IBM DB2 Database
  171. settign DB2 environment under Windows without using db2cw.bat
  172. Need help on SP with GTT
  173. SOMET_09
  174. PRIQTY and SECQTY
  175. Re: Need help to canvert oracle funciton last in db2
  176. Db2
  177. Difference between automatic and Auto-resize tablespace
  178. SQL 103 - "Numeric literal invalid" on SELECT *, but not SELECT a,b,c
  179. Maximum number of STRIPE SETS in a Tablespace
  180. DB2 EE LOADER
  181. Read Blob field
  182. Yellowfin seeks resellers for BI product
  183. Monitoring DB2 JVM
  184. robust optimisation
  186. Storage required for VARCHAR in V9.5
  187. DB2 page structure
  188. db2 express C and file XML
  189. db2ckpwd uses a lot of memory
  190. IBM DB2 Content Manager eClient v 8.4 configuration fails
  191. Certification in Mind???
  192. More than one second of CPU in one second
  193. clustering index - will your table be arranged by the columns here?
  194. Crash recovery for LUW on Linux
  195. Which are the best R&D websites for DB2 internals?
  197. disable windows db2 user
  198. Error in Stored Procedure (DB21034E)
  199. db2 udb crashed
  200. sql0954
  201. How to safely trim log space
  202. Midnight query chalenge
  203. Can I create unique index on selected records ?
  204. Urgent openings for Informatica with CMML @ PUNE, India...!
  205. Can I use "Get Snapshot" for DB2 on mainframe?
  206. Tablespace containers not accessible
  207. connect Z/OS database from windows
  208. Activate NIS authentication
  209. Problem While loading from Client Database
  210. Parameterizing Schema name
  211. Copying a DB2 database from one server to another
  212. Call to SP in partitioned env. not allowed
  213. DB2 Express-C on Vista/Business
  214. Looking for participants for a 30-minute DB2 survey
  215. Run sql from Dos
  216. Automatic maintenance policy files
  217. conversion from db2 to oracle
  218. Change value in IMPORT
  219. Query size limits
  220. Query size limits
  221. ANy one can plz send me some DB2 V9 (730 exam) dumps
  222. db2 username length 8 characters limit
  223. Function to convert for bit data column / field to INTEGER?
  224. Function to convert for bit data column / field to INTEGER?
  225. How does a SYSIBMADM created
  226. Lock issues in db2
  227. Is there a 'non-mandatory' relationship in DB2 8 for Z/OS?
  228. perl dbi built on DB2 8.2 does not run on 9.1
  229. How to call a stored procedure from a trigger ib DB2 ver 7.x
  230. Newbie question - this is highly unusal
  231. Purging task output
  232. Remote debugging in Java stored procedures
  233. DB2 Live Database Replica for Reports
  234. DB2 UDB for z/OS V8 Sample Programs needed
  235. Connecting to CA-IDMS via JDBC drivers
  236. calling SP from UDF
  237. Paging steadily increasing over time
  238. MQT on a nickname
  239. PL/1 DB2 V8 Table Declaration for a CLOB
  240. PureXML
  241. trouble with C-written application and UDF on 64-bit Windows
  242. remove large number of rows using SQL only
  243. remove large number of rows
  244. Control Center problems
  245. max sequence value --- how?
  246. FETCH into sqlda structure
  247. Treatment of SMALLINT in Java Program
  248. cannot run db2imigr even if LIBPATH set
  249. DB2 Run time client
  250. SSL support for natvie DB2 LUW (non-SQLJ/JDBC)
  251. Preventing First Steps Launch Pad screen
  252. formula to calculate DB monitoring parameters
  253. Finding Tables without any Primary key
  254. What can we do about these non-topic postings to this group?
  255. What can we do about these non-topic postings to this group?
  256. Table in Load Pending state but Terminate command does not work
  257. Cobol cursor and update processing
  258. enable_MQFunctions in DB2 V9.1 x64
  259. How to import database schema back to DB2
  260. spam
  261. how to backup db2v8 in linux os
  262. HADR support for DPF partitions
  263. Why this Stores Procedure is not working - puzzled
  264. Not able to connect to db !
  265. Re: Rewrite LUW query to work on z/OS
  266. I need to check the position of '(' in a string.
  267. mon_heap_sz
  268. hello i need help with torque (java )to setup him to db2
  269. [Test]
  270. Why is DB2 not releasing memory sooner?
  271. Newbie on SQL & Excel
  272. Latest updates in database mangement and many more
  273. Re: How to check SQLCODE in trigger
  274. SQLOGDIR permissions in AIX
  275. spam
  276. spam
  277. TCPIP problem
  278. DB2 Express UDB 9 with db2jcc JDBC driver- Issues with Auto generatedfield
  279. Re: How to avoid 2nd trigger
  280. Any suggestion on how to speed up large batch inserts?
  281. Sql Code = -311
  282. Problem with IN predicate
  283. Re: ADVICE NEEDED: Removing Inner Tie Rod Ends - TWO QUESTIONS
  284. Special register USER
  285. db2exfmt and missing function EXPLAIN_FORMAT_STATS
  286. Offline backup logs
  287. V9 runtime client setup problems
  288. overflowlogpath and hadr
  289. SQL0100W error...while returning result set
  290. UDF Portability?
  291. Calculating Business Days Between two dates...
  292. What's the meaning of IID=0 in output of db2pd command
  293. User-defined aggregate functions and OLAP windowing
  294. Job Opening
  295. about online reorg
  296. How to connect IBM DB2 with JSP?
  297. notify/listen?
  298. Tablespace qualifier in DB2 UDB On Linux/Unix/Windows
  299. Aggregate Concatenation
  300. backup falsely marked as in progress. can i clear this state?
  301. store procedure error
  302. issue for label on table
  303. How to LOAD deleimited data with linefeeds to mainframe DB2
  304. Query exceeds specified time limit or storage limit
  306. DB2 Views
  307. Automate delete archive log !
  308. search image by content
  309. changing the authorization of the tablespace's tables
  310. never-ending LOADs
  311. inserting data into a dependent table
  312. Redirect SELECT results to a file
  313. need help with the trigger
  314. DB2 patches - need historical record of proof
  315. Schema size(Size of all the tables in a schema)
  316. How to invoke db2top in batch mode
  317. Backup Online db2 9.1
  318. Latest updates in database management and SQL server
  319. brothers and sisters must register and send this article to users
  321. Declare result set variable in procedural SQL
  322. DB2 8.2 Workgroup Server Edition limitattions
  323. Sqlcode=-443, Sqlstate=38553 Sysibm:cli:-727
  324. SQL0101N The statement is too long or too complex. SQLSTATE=54001
  325. Timestamps on data records, Documentation on old versions of DB2
  326. privileges on functions
  327. Find a sentence with words separated by multiple spaces
  328. Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
  329. library compatibility undefined reference to`__cxa_guard_acquire@CXXABI_1.2.1'
  330. Yellowfin Business Intelligence Release 4.0 Announced to Industry
  331. Temp tablespace - system or user?
  332. TRANSLATE function
  333. SMS TableSpace - Reorg not releasing space.
  334. Multiple fault monitors from different db2 versions
  335. Re: Delphi + Stored Procedure + Locks
  336. Change default TimeZone in DB2 [JDBC]
  337. Export utility is taking long time
  338. Export utility is taking long time
  339. Export utility on a table is taking long time
  340. Runstats error
  341. DB2 Performance tunning
  342. Re: Community's water tower perhaps somewhat in questionable taste
  343. Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?
  344. Urgent - need help
  345. When does a stored procedure use an MQT
  346. the option CPU_PARALLELISM of LOAD
  347. Re: Question on syscat.keycoluse.colseq
  349. Parallel SQL (forking) in SQL stored procedures
  350. FYI: IM Consumability Survey
  351. Getting group of data for each member of primary key
  352. Question: restore from backup in relative path...
  353. converting DB2 triggers to Oracle
  354. error messages for key constraint violations
  355. Re: Otra vez sin news ( ...
  356. z10 or z9
  357. MQ Functions included in DB2 Workgroup Edition?
  358. FYI: DB2 for LUW Best Practices
  359. Re: Questions to FAILARCHPATH and HADR
  360. Find the latest updates in database management of IBM
  361. CLOB and searching by it
  362. Reorgchk, Reorg, Runstats not having any effect after completion. Why is this?
  363. SQL to find if table has identity and/or row change timestamp columns
  364. DB2 9 runtime client install
  365. import XML file into DB2 table
  366. How can I use shell script to remove specific records from a flat file?
  367. Estimating performance on an OLAP database (virtualization vs. serverinstall)
  368. bind file recovery
  369. How to terminate idle agents?
  370. DB2 query hours difference
  371. Trigger fire a query
  372. DB2v9.5 64-bit does not allow me to chose location of user tablespaces. Why?
  373. Migrated From v7 => v9 ... and Now Can't Use Semi-Colons in Strings?
  374. How to get 'message text' portion of error from SP
  375. Control Center SQL Assist
  376. String comparison in DB2
  377. Getting memory size for an application
  378. Getting rid of nuls
  379. Is it possible to "enable" auto-rollback functionality whiledead-lock occurred on DB2/400?
  380. BACKUP & RUNSTATS running simultaneously
  381. Catalog Service - User interrupt detected
  382. CPU usage in DPF on Windows during massive parallel single rowinserts
  383. db2 load using v9.1 client into a v8.1 fixpak 16 database
  384. Parameter markers in LIKE clause
  385. CTEs in UDFs
  386. Loading Data from SYSCNTL and SYSREC files
  387. What is SQLCODE=-3196?
  388. Oracle Database Training, Practice Tests
  389. Need help w/.ksh script to REORCHK & output Recommended tables to a file
  390. How long does it take to migrate db from 8.2 to 9.1 on LUW
  391. How can I installed DB2TOP on my windows or Linux?
  392. Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
  393. Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
  394. Re: Takers for a Friday SQL puzzle? Timestamps and recursion...
  395. HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
  396. Database Application Front End
  397. How to get list of database?
  398. Re: Olympialaisia terävänä
  399. db2 client hang - db2osse!ossLockGetConflict
  400. [z/os] Finding location of DB2 specific copybooks
  401. Lock waits during online backup
  402. how to develop embedded SQL program by C language?
  403. Is it possible to develop ODBC program on AIX?
  404. Redirected restore DMS -> SMS (or automatic storage) possible?
  405. How to reset auto generated id in a DB2 table
  406. Re: How to reset auto generated id in a DB2 table
  407. Is replication really transferring data via my desktop PC?
  408. DB2, vim, and dbext
  409. Ask for help from ORACLE board: matching normalized and denormalized tables
  410. DB2 'CASE' puzzle slqerr -811
  411. how to define such a trigger....
  412. DB2 Performance Monitor.
  413. Cross Platform db Restore
  414. Re: How to get stored procedure definition?
  415. Distributed statistics and optimizer
  416. How to get stored procedure definition?
  417. Can someone enlighten me on 'handles'?
  418. .databean.jdbclob from DB2 Control Center
  419. how to create Store procedures without using development center
  420. SMALLINT casting difference on Windows vs AIX
  421. Is there is a way in DB2 to return multiple fields from a single case
  422. DB2 9.5 fixpack 1 stalls when running script
  423. Re: perform date and time arithmetic, represent seconds and dates inDB2
  424. Update, case, and -407
  425. SQL-> RDF or other question about linked data? Win a pass toLinkedData Planet for best question.
  426. Can i drop a cloumn from a table in DB2 for Z/OS
  427. Re: DB2 Query Help
  428. root owns files in db2 instance directory.
  429. Control Center - Activity Monitor Permissons?
  430. DB2 Intelligent Miner - for 64 bit AIX 5L
  431. DROP PACKAGE with hex zeroes
  432. Performance Goals for DBAs
  433. Query from ORACLE board is not working in DB2
  434. stop remote instance
  435. stored procedure or SELECT statement
  436. SQL statement not supported error SQL1042N for MQT defn on a nickname
  437. monitoring backup
  438. Generate Unique Number in DGTT
  439. any warehouse database upgraded to v9.1? or v9.5?
  440. Stored procedure, first run slow
  441. decimal to date
  442. loading in to generated row change timestamp column
  443. LDAP and caching on DB2 9.5
  445. DB2 memory usage help
  446. Reading Arabic data from db2 v8 using db2 wire protool
  447. DB2 UDB Installation on Windows Vista
  448. ho w to see the output of "Message_Text"
  449. DB2 on z/OS different than on LUW ?
  450. move rows from one table to another
  451. Re: Long compilations
  452. Multitable insert in DB2 v8 os no Merge is avilable:
  453. Database Management
  454. TRUNCATE stored procedure
  455. How to fined un-unused indexes on DB2 /ZOS
  456. Re: Long compilations
  457. Plug-In extension for Control Center
  458. V9.5 and SQL1084C
  459. Get Diagnostics
  460. Multi-row insert timestamp error
  461. DB2 contoken split by PLI compiler
  462. Is this is output from EXPLAIN?
  463. Schema on Db2 database installed on Main frame machine zOS.
  464. How to calculate difference between 2 columns excluding nulls
  465. collating sequence
  466. Re: SQL - Unexpected result
  467. Re: SQL - Unexpected result
  468. problem: sum is incorrect (e-10)
  469. Rolling out V8 client using response file
  470. IDENTITY PK-FK corruption of data
  471. Re: DB2 equivalent for ORACLE SQL*Plus BREAK???
  472. Seeking simple after insert example
  473. Re: rollup for DB2 UDB for iSeries ?
  474. Throttle automatic runstats
  476. Symbolic links for containers?
  477. IDENTITY columns as foreign keys
  478. How to replace VALUES IN UNPIVOT QUERY
  479. LIST all available db2 server in my farm lan
  480. size of numeric data
  483. Cannot redirect restore into a different database name.
  484. DB2 Tools, DB2 administration server, transmitRunCmdMessage, probe:30
  485. Subquery decorrelation
  486. Altova v2008r2
  487. Re: Update Statement and frequent commits
  488. Instance choice in JDBC url connection
  489. Archive logs?
  490. about snapshot monitor
  492. Not able to assign select query "WITH UR" CLUSE TO A VARIABLE
  493. ANSI Dynamic SQL syntax in DB2 [789] for z/OS
  494. DataServices World (June 24, New York City) early bird registrationexpires 9 May
  495. Row and Statement based Trigger Question
  496. Re: Looking for SQL statements database
  497. Administration server startup error after installation of DB2 V9.5
  498. Federated database access
  499. Trouble. Please help.
  500. convert a decimal number into character
  501. parameter limit for XML datatype
  502. Shift_JIS to UTF-8 Conversion
  503. db2 connect 4 minut delay after adding partitions
  504. Date function in DB2 V8.1 for Z/OS
  505. Alter Table causes SQL0901N ( SQLSTATE=58004 )
  506. Again against generated columns or (missing) row value constructor inwhere clause
  507. db2 v8
  508. How to add leading zeroes
  509. How to reduce the highwatermark for a DMS tablespace?
  510. Question about tablespace design
  511. db2rbind after runstats?
  512. Deleting ID which owns scheduled tasks...
  513. Extract LOG file from Backup Image created by NCLUDE LOGS
  514. DB2 CONNECT configure and Sysplex support
  515. Determining Table Status?
  516. Best scripting language for DB2 with a java implementation?
  517. Space between characters
  518. Get a COUNT(*) for all tables in a schema?
  519. SYSSH200
  520. Problem using sqlj with type 2 universal driver - Db2, z/Os, v8.2
  521. SQL0437W Performance of this complex query may be sub-optimal. Reason code: "1". SQLSTATE=01602
  522. CLI Trace - Syntax Error
  523. Get "user" tables
  524. express-c and php very slow
  525. connect to db2 9.5 server slow
  526. ROLLFORWARD failed
  527. Dynamic statement cache on LUW
  528. concept behind in db2 software as root with some files as worldexecutable
  529. db2 8.2 base release download
  530. Select privilage on all the tables in a schema.
  531. commit active -- forever
  532. Question about MIN/MAX optimization
  533. Commit Active
  534. safe fallback procedure in windows on version 8 fixpack 14 to backon Verison 8 no fixpack level
  535. What is the optimal average bufferpool read time in a multipartitioon datawarehouse?
  536. Current week job updates-visit
  537. DB2 UDB Warehouse
  538. db2stop and db2start require password in partition env
  539. Re: How do I turn 2 separate select queries into the columns of 1select query
  540. Group privileges and views
  541. Sleep command in db2
  542. can a trigger do an execute immediate?
  543. Moving tables between an iSeries and DB2 for Linux
  544. A simpler truncation function that renders credit card numbersunreadable
  545. Learn querying DB2 system catalog tables -basics
  546. Raise signal with dynamic message_text
  547. Java Architects - Immediate Opening
  548. Query Help
  549. Deadlock due to table level exclusive lock
  550. db2vshelpreg.exe error