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