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