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. String up to 2048 characters long?? Database
  2. Referential database
  3. Timeout for EXCHANGE between clone and base table
  4. DB2 interview questions
  5. Copy table from one tablespace to another
  6. query to transpose row data into column
  7. how do i set password for a table in access to protect the edit
  8. I need to retrieve the users's data whose their emailid's are in mixedcase
  9. Access Navigation Form with other navigation forms
  10. Stored procedure is taking long time in execution while query is runing fast
  11. query returns empty records despite having equal values in all relational tables.
  12. I am working with access i want to set date for ordering and delivering of item. i wa
  13. Import CLOB Data from DB2 to Excel Using VBA Script
  14. store procedure to insert multiple records at a time into table?
  15. Starting DB2 unix when Log Files Accidently Deleted
  16. Wanting older 32 bit Editions of DB2 for Unix/Linux/Windows
  17. Can we Created a 8k page size Tablespace for already created 4k page size database
  18. Move data from current table to history db2 table
  19. I want to know how can I move data from current table to history table in DB2 with ro
  20. Tablespace state issue
  21. Convert a varchar column in a db2 table to UTF-8
  22. How to copy one column into another in DB2 sql
  23. StoreProcedure............................
  24. Maintain data type in make table query
  25. db2 alter sequence seqname restart with nextval retrieved from SQL
  26. RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP
  27. export a table from db2 without column headers
  28. Query to increase scale size of column db2
  29. How Do you write WHERE condition For timestamp
  30. connect to db2 database and execute script
  31. auto execute sql script for db2 database
  32. Vba form
  33. Insert, update, delete
  34. 250 columns in a tables
  35. System views permission for Public role
  36. how to know last committed transaction of backup image
  37. Using DAYOFWEEK to find the Previous rundate
  38. can we get the list of LSN from db2 logs without any db2 utilities
  39. can we use any log file to read using readLogNoConnAPI
  40. How to get the first LSN number from the DB2 binary log files
  41. Adding a Row Number to Duplicate Accounts
  42. attempting to use restore redirect for 3 tablespaces. Job fails SQL2034N The address
  43. 24x7 online logs / traces using DSN1LOGP / DSN1SMFP (similar to CA Log Analyzer)
  44. SQL to retrive 1 month data which is 4 months old
  45. Like in host variable in DB2 Query
  46. jdbc connection problem unable to connect
  48. DB2 online backup hang, cannot connect to DB
  49. Error DIA5000C A DRDA as Token "RECOVERABLE" was detected
  50. SQL0104N An unexpected token"." was found following "".
  51. MSU calculation for DB2 (to decide DB2 licence and DB2 computing capacity purchase)
  52. Into how many divisions DB2 is classified, for example DB2 framework, DB2 LUW.
  53. creating a new database View using the Optimize clause is throwing error sqlcode=-104
  54. SQL Converting decimal type to date type
  55. Check a date on a DB2 table to see if it falls within the last 24 hours.
  56. Supra To DB2 Migration - Need advice on the key set up on variable table
  57. How fetch 2nd last record for timestamp on same Date.
  58. how to update the data db2 based on the last digit number 2 ??
  59. Returning Mulitple Result Sets in DB2
  60. How to see explain plan in iseries - DB2 Database
  61. how to change dates in bash script running db2 commands
  62. Non-Recoverable Option for DB2 Enterprise Stage
  63. Convert Char string with Sign to Decimal in DB2
  64. Got Error as directory not found when trying to connect to database from db2cmd
  65. How to remove duplicates for below scenario
  66. find memoery usage for specific instance??
  67. DB2 An unexpected token "END-OF-STATEMENT" was found error
  68. distinct with order by usage is not bringing unique values
  69. Migration of Tape data (DB2) to SQL server
  70. Getting Result from Null Query. I would like to have the document name from the query
  71. cannot connect to DB2 mainframe for getting tables from metadata
  72. How to get the version of a schema in DB2 database
  73. How do you replace a shared object that contains a DB2 UDF?
  74. designing table in datawarehouse
  75. DB2 External procedure: SQLJ.INSTALL_JAR failing
  76. "P1: begin" and "P2: begin" in a DB2 SP
  77. DB2: Extract definition of a global temp table created using “as select”
  78. How to set up no lock on tables on db2
  79. I need help creating an AFTER UPDATE trigger to add an ‘UP’ record to the Log every t
  80. Please help with INSERT
  81. I need to know if I'm running my process on the 3rd Thursday of the month. Thank you
  82. Windows Clustering and HADR split brain issue
  83. Getting sqlcode -305 instead of 100 while fetch
  84. Active Directory
  85. To Retrieve last inserted records according to their insertion timestamp
  86. Execute Immediate in cursor on ibm db2?
  87. DB2 Stored Procedure - Replacing COBOL-DB2 update modules with DB2 Stored Procedure
  88. How to override the path for my UDF?
  89. -501 error while calling one stored procedure from another stored procedure in db2
  90. DB2 8.2 version I need some inovation idea's to implement in my Working environment
  91. Connect to DB2 database from shell script
  92. how to update current date and current time in DB2 table
  93. Db2 cursor for update with join syntax
  94. How to get the count of clob data?
  95. The use of an hexadecimal variable
  96. Default Allowed Access for RUNSTATS DB2 10.5 on AIX ?
  97. Is there any online site for DB2 querying.
  98. "create tablespace" fails with EXTENTSIZE = 32
  99. Security plug in LDAPAUTH versus Server_Encrypt
  100. Can we work on more than one DB2 database through shell
  101. Update Query needed to update the existing column
  102. fetching a last record inserted from a table and updating it.
  103. Retrieve SQL statements Info from MON_GET_PKG_CACHE_STMT
  104. dBase V SQLDBS Error when trying to open SQL
  105. Write into text file using Db2 Stored procedure
  106. An unexpected and critical error has occurred: "BadPage" continuously on DB2 9.5
  107. Is Query with Union All on federation run parallel?
  108. Use of Like where character = %
  109. How to know DB2 Runstats Profile
  110. How do I fetch a result of a select query in a temporary variable?
  111. array declaration
  112. how to call a stored procedure with no parameters into another procedure
  113. how to create a db2 triggers to copy one filed to another in same table before update
  114. Rollback on a DB2 table doesnt rollback the data - VB.NET app
  115. DB2 syscat.functions table
  116. Multiple DB2inst1 process are running.
  117. Deletion of 10 million records from a table
  118. db2 query fetched data is showing randomly sometime and somtime not in multiple serve
  119. Initialize variable in dbartisan(db2) & return a result set from begin atomic block
  120. how to run db2 sql statement from unix command prompt and store the output in csv fo
  121. SQL30081N A Communication error has beeb detected
  122. Parameter value differs on my procedure
  123. Getting 500 internal server error in enterprise manager while running the sto
  124. DB2: Round timestamp to 29 mins
  125. DB2 force application all and db2start
  126. how to extract output file comma deli. calling XX.sql file
  127. DB2 Federation - Command line based
  128. How do I set up the developer's client in Linux and linkage with the database server
  129. I have a function that modifies data and returns a scalar. The function got created,
  130. Converting Oracle Query to DB2 Query
  131. MQT staging table getting SQL code
  132. Limit DB2 Audit to certain users
  133. Need to insert 2 different set of data into single table
  134. Question regarding FstTup in a DB2 Explain plan
  135. Passing Date Parameter to DB2 Stored Procedure
  136. SQLBindParameter with a hexadecimal containing one '00' like x'420000F3'
  137. How to exit from before insert trigger in DB2?
  138. Creation Trigger with variables
  139. Type Casting In Query calling form jsp
  140. db2 date ?
  141. DB2 Tablespace in Drop Pending state after restore
  142. Creating an Update query with an embedded select statement
  143. DB2 "No Storage Available for allocation" DIA8305C Memory allocation failure occurred
  144. bash shell version of db2uext2 (DB2 USEREXIT),backup archive log to remote host!
  145. how to connect to db2 database in crontab jobs scheduling
  146. changing columns positions in db2 table
  147. How to collect DB2 performance counter values by using query?
  148. Looking for tools to move AS/400-iSeries data to DB2
  149. Stored Procedure( OUT PARAMETER) CANT CALLED.. HELP ME
  150. Can DB2 stored procedure run a .sql file?
  151. Inserting large string into DB2 filed.
  152. SQL0723N An error occurred in a triggered SQL statement in trigger "DB2ADMIN.TRG_MQ_
  153. On using db2 Load to load 1252 data in to DB2 (codeset 1208). The German umlouts are
  154. Cannot Start the DB2 Instance after Config Change
  155. Insert into values for binary data type
  156. Can we delete dmp files in the DB2 Database?
  157. is there a tool or utility which can migrate data from IDMS to DB2
  158. Time interval
  159. update using DB2 MERGE statement involving 2 tables errors out version 10
  160. How to know the subsystem of a DB2 table
  161. how to change locale value in db2 by executing sql statement
  162. I want to know the ip address of the DB on another laptop
  163. to create table inside stored procedure
  164. need help in roolback options
  165. ORA-06503: PL/SQL: Function returned without value
  166. Insert rows into a table by 'With' clause
  167. A particular record is not deleted & ddl opearion allowed
  168. Error Accessing a table space container. SQLSTATE=57048
  169. TRUNCATE ERROR SQL0104N An unexpected token "table" was found following "truncate ".
  170. Unique Rows using Left outer- I am trying to build a query which will give me unique
  171. RRN in trigger.
  172. I want to export a table from ACCESS to DB3.
  173. Extract text (>32500 bytes) from SYSCAT.ROUTINES
  174. Haw to write query to get result in single line in DB2
  175. creating a table as i need for example tree...
  176. Limit Number of Rows Updated in DB2 MVS
  177. DB2 compound sql giving delimiter error
  178. Strange behavior of FOR LOOP CURSOR
  179. Create a federation Windows to ISeries
  180. Create dynamic cursor got ERROR: Invalid use of an aggregate function or ...
  181. Need no data found exception in db2
  182. Tablespace and container states after tablespace damage
  183. Stored Procedure abend SQL state [38503]; error code [-430]
  184. Restore got stuck in between in DB2
  185. case statement column's used in order by , show error 'Invalid Column in the context'
  186. how to get DB2 date version 5.2
  187. SQLSTATE=22001 while trying to load data.
  188. Help with using database partition expressions
  189. send a sms to my customers when database updated
  190. IBM DATA STUDIO Z/OS XML and Schemas
  191. add picture of jpeg format to a db2 table
  192. how to restore the existing production db in development environment
  193. Produce output based on values in table
  194. DB2 multi-thread application and sql error Log full
  195. how to identify greater than one changes of a field in one day from mainframe DB2 tab
  196. Syntax error alter column for bit data
  197. To extract month and year from a column in the table
  198. Unable to create varchar column size 35000
  199. delete data frm tableA n put tat in tableB
  200. List contents of all SPs in schema
  201. How to update the status of a particular row as 1 if the whole record already exists?
  202. Recover deleted rows in table db2 from log file
  203. DB2 9.7 Function + NickName + Dynamic=> Problem
  204. Convert CHAR expression to Binary output (SQL syntax)
  205. split a contents of a field of each record and store in another table
  207. Update or merge field from 2nd table - DB2 iSeries
  208. Calling a stored procedure in a user defined function
  209. How to import sql file
  210. Log file corrupted - how to recover data
  211. DBM parameter NUMDB has value 8. Should I change it to 1 because I have only 1 DB?
  212. Import flat file in db2 table using a clob datatype
  213. Pass table name as param showing error
  214. ixf load error with truncated values - same ixf import is OK
  215. No of rows scanned for execution of query
  216. Locking in db2
  217. db2 9.7 active-active cluster
  218. Stored procedure in DB2
  219. sql prepare in db2 9.7 does not work on db2 9.5
  220. [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004
  221. How to execute query "select * from Emp where emp_id=2" in DB2
  222. Not a valid Command Line processor command
  223. listagg and ignoring duplicates
  224. db2 restore fails (symantec net backup)
  225. How to convert columns to rows
  226. Fox pro dos 2.6 password error. I don't know the password
  227. rounding milliseconds to seconds in db2
  228. why db2_all command is not needed to get rows count from table in DPF environment.
  230. Please send Automated DB2 Backup Script on Windows machine
  231. DB2 Stored Procedures called from REXX
  232. MQT over multiple table and Incremental Refresh
  233. nested table type
  234. using union with table type
  235. nls_database_parameters
  236. SQLCODE -489109819 while data loading
  237. Question about tablespaces
  238. Dynamically Setting the Schema Doesn't Work during Fetch
  239. SQL3110N The utility has completed processing. "49" rows were read from the
  240. How to do database mirroring with a witness
  241. How to change privillages for DB2 10.1 ( IBM Data Studio )
  242. Database can't be accessed after restore
  243. DB2 PREP and BIND one source with several authorization identifiers
  244. how to identify rows in the result table with UNION
  245. Error: calling the procedure in a function
  246. How to migrate view tables into real tables?
  247. How to drop corrupted tables?
  248. Container in Use Error when Restoring Offline Backup Image with Data Studio 3.1.1
  249. Restoring Offline Backup to my DB2 v10.1
  250. all sql scripts in db2 should store UTC
  251. DB2 Connect, Dynamic SQL, and chosen Isolation Level
  252. How to configure schema in db2?
  253. Getting my data and queries from my DB2 UDB to Dataquant
  254. Deleting records older than 30days
  255. How long does DB2 take to release secondary logs after a commit.
  256. Using Select and passing parameter to procedure
  257. Need Help in finding row size of a table in DB2
  258. Shared Memory Allocated to DB2 on Windows server 2008
  259. Error in executing single dynamic query that has multiple SQL statements
  260. Cancel DB2 reorg process
  261. calling global temporary table from a function not working
  262. db2 9 fundamentals certification
  263. What is a non-inline function in DB2 ?
  264. IDMS to DB2
  265. .bat file call DB2 stored procedure, without the connection string?
  266. DB2 archive log file layout
  267. how i can increase db.mon_heap parameter in db2 database
  268. if exists
  269. Generate csv file with headers...using db2 export ?
  270. SQL Error for DB2
  271. DB2 : Restore vendor API sqluvint doesn't give proper restore type
  272. DB2 process concurrency/ lock question
  273. Numbers of combinations for columns
  274. How to Distinguish between online and offline backup in sqluvint call?
  275. What is more reliable char or varchar?
  276. DB2 load
  277. Arabic language in DB2 database
  278. Using "LIKE" predicate in embedded SQL in Cobol
  279. Include vs copy
  280. Cursor not defined
  281. Replicate Data to Another Database
  282. Convert BIGINT to TIMESTAMP
  283. Loading a |^* delimited file to a table
  284. Migration from ORacle to DB2
  285. How to Create DB2 partition.
  286. Completed LOAD phase in db2diag.log, db2 load never completes
  287. Cannot Setup DB2 HADR
  288. Count table in DB2
  289. How to retrieve alerts/information from a db of alerts that happened between 7
  290. is an undefined name. SQLSTATE=42704
  291. DB2 v 9.1 to Teradata
  292. How to establish a DB2 connection in while loop using Shell script
  293. connect and db2
  294. sql 1390c error while installing DB2 8.1 on windows 7
  295. REPLACE in packages vs plans
  296. DB2 Error: "MODIFIES SQL DATA" clause has not been specified
  297. How to get out of "BACKUP PENDING. SQLSTATE=57019 on DB2" State
  298. changing schema name after database restore
  299. Replication between 2 As/400 db2 databases
  300. DB2 v9.0 (Enterprise) vendor code
  301. not able to run query from jmeter
  302. Convert varchar to time
  303. Tablespace level issue
  304. How to insert only PNG & jpeg image in DB2
  305. Want to have a key field in 2nd PF in Join LF
  306. Installation of IBM DB2 spatial extension for mac os
  307. JDBC callable insert with registered parameter??
  308. Datastage conversion
  309. SQL0289N Unable to allocate new pages in table space "<tablespace-name>".
  310. Compare 2 columns having similar data
  311. A minor error occurred while installing "DB2 ESE"
  312. If we give this year and weekid like 201106 we have to find last week data?
  313. Db2top
  314. Any one have a powershell script to prune DB2 Logfiles?
  315. how to reorg table that's in pending state ?
  316. SQL0204N error in reverse engineering from db2 to power designer
  317. VARCHAR vs CHAR in DB2 z/OS
  318. Db2 get diagnostic does not returns # of rows
  319. DB2 Nested Stored Procedures and labeled_begin_atomic error
  321. Comparing a string consisting of two single quotes
  322. SQLDA max length for sqlname
  323. " SQL0440N " - error while executing store procedure on v9.7fp4
  324. Jar for DB2 type 2 driver
  325. Errorcode=-668, sqlstate=57016
  326. Create schema
  327. Find Tables/Views used in a View.
  328. Migrate from oracle to DB2 incl. 32 to 64 bit unicode
  329. cursor for
  330. Why explain plan not same?
  331. DB2 tablespace (USERSPACE1) from Drop Pending to Normal stats?
  332. Data partitioning
  333. DB2_CREATE_DB_ON_PATH registry entry does not exist
  334. Websphere Message Queue
  335. B2 Control Center, Missing Database details
  336. Backup Failure - 4 node DPF Setup One node is down
  337. grant privileges in db2
  338. Index length of in the DB2v9.
  339. Query to count the rows count of one column in two tables
  340. Comparision of date in SQL
  341. federation
  342. Federation from oracle to db2
  343. connectivity with database
  344. DB2 Load statment between two tables
  345. Stored procedures
  346. Restart Identity Column Dynamically
  347. Need to create DB2 DSN with the hepl of vbscript or commands
  348. How long does a HADR take to switch from primary to Secondary?
  349. DB2 instance hangs on query
  350. Import in DB2 from oracle dump
  351. Federated Database Objects
  352. How can I get totals of fields from multiple rows, based upon the value of the field?
  353. DB2 Time Stamp format
  354. How to display message in DB2 SQL PL ?
  355. Not able to connect to db2 from java
  356. Selecting the most updated record from each category/group of records
  357. Insert into conditionally
  358. DB2 Clob Data Memory Limit Reached PHP ODBC
  359. DB2 load
  360. Access 2 different databases from one SQL script
  361. How to get list of all table names in db2
  362. Oracle SQL Statement to Microsoft Access
  363. cte odbc sqlstate 42601
  364. Check foreign keys values
  365. Connect Z O/S DB2 database using SQL DEVELOPER
  366. How to get output of queries to files at runtime
  367. how to convert date 'yyyy/mm/dd' to 'dd-mm-yyyy' ?
  368. DB2 Store Procedure with Parameters in Create View
  369. DB2 login issue
  370. capture db2 output in shell script
  371. Table unload in dclgen Copybook Format
  372. Online Reorg causes a timeout with application in Runstats phase
  373. Db2 user login
  374. MYSQL inner join
  375. Error: DB21034E The command was processed as an SQL statement
  376. DB2 log use monitoring - what is the best way to determine usage?
  377. carriage return in Access
  378. db2 cpl snytax to continue sql on next line
  379. Store a query result in a variable
  380. Error invalid lob object. See attached Throwable for details. ERRORCODE=-4461, SQLST
  381. Sql0102n error While inserting a large text into a clob column
  382. DB2 user defined function problems
  383. Writing strings from stored procedures to he text files
  384. creating log file for given db2 stored procedure
  385. Installing DB2 in Windows 7
  386. Exception and Handler
  387. How to Find which SQL Statement is executing
  388. Varchar length question
  389. Issue defining DB2 to VTAM
  390. date comparing with particular date in shell script
  391. SQL0670N createTable with more than 365 Clob columns
  392. Null Indicator in DB2 Load utility for pipe Delimited files
  393. Db2 load invalidates packages
  394. DB2 SQL select
  395. how to grant only select access to a user on DB2 9.5 on windows 2008
  396. DB2 SQL Syntax Validation
  397. SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2
  398. Client For DB2
  399. db2 archive log shipping
  400. index and rows read
  401. can we use a agregate function inside a case statement in db2?
  402. about db2 bind db2cli.lst after install a fixpak
  403. Help me ! Reason code: "6". SQLSTATE=42724
  404. Increase the time an Access Form opens
  405. DB2 - Primary Index
  406. Trim Timestamp XML Tags in DB2 column - Using SQL to query
  407. how to handle parent-child hierarchy in db2 udb V9.5
  408. SQL3126N : Remote client requires absolute file path or directories
  409. Merge in DB2
  410. db2 list history backup (info regarding output)?
  411. Creating Triggers from DB2 with Target Table in MS SQL Server database
  412. Fetch data from DB2 using INNER JOIN with access file
  413. When would you NOT see DB2 objects in PACKAGEDEP if Java is being used?
  414. Effects Of Ongoing Reorg Killed Forcefully.
  415. DB2 Qsec Audit
  416. List of nodes from list of instances?
  417. About command of attrib
  418. opening a ref cursor in dynamic sql
  419. I wanted to drop a column of a tabale but get a sql error with -145
  420. SQL0444N reason code 6
  421. To check the locks on all the tables in a database.
  422. Override values while loading table in db2 z os v8
  423. how to handle archive logs in sql replication environment?
  424. In db2 stored procedure, how can I replace an input string?
  425. Deferred referential integrity in DB2
  426. DB2 Delete query issue
  427. DB2 Compatibilty with Windows 7
  428. In replication,the capture server capture active logs or archive logs?
  429. Does anybody now how big a NPSI DB2 v8 can be?
  430. Is there a way to rebuild an index without requiring exclusive lock on a DB2 file?
  431. SQL30081N A communication error with error code 10061
  432. load sequence and tables hierarchy
  433. How to calculate percentage in SQL DB2 query
  434. DB2 federated architecture
  435. Using Host Variables in Xquery
  436. how a partitioned table choose tablespace when I do not specify?
  437. how to caculate extents for a new table? thanks a lot
  438. Get only clob column names but not its data.
  439. How to delete a schema by using db2 -tvf file.sql command?
  440. In datacom how to find a table name for creted views
  441. How to clear the log files from the circular logged database?
  442. Extraction of data from DB2 table
  443. How to run Oracle SQL stored procedure in DB2 database environment?
  444. bufferpool size automatic without enabling STMM?
  445. Sql10007n
  446. How to replace a special character in DB2?
  447. How to turn off implicit cast db2 9.7
  448. How to find no.of hash partitions per database partition, of a table?
  449. I want to add the SUM(BL_US_CURY_AMT) + FUND_CASH_BAL_AMT into FUND_CASH_BAL_AMT.
  450. How to modify stored procedure to work on date range?
  451. Date Conversion from String
  452. Points of consistency are not getting created when running Load with Savecount!
  453. how to granr reorg privilege to any db2 user
  454. db2 bind db2ubind.lst error,help.
  455. Cursor stability isolation level
  456. How to use db2iupdt -w 64 to update my instance from 32bit to 64bit?
  457. how to migrate db2v8 32bit to 64bit? help
  458. [IBM][CLI Driver][DB2/NT] SQL0245N The invocation of routine "TIMESTAMP" is ambiguou
  459. How to find the nodes of a partitioned database?
  460. How to Redistribute database with DISTFILE option:?
  461. "A file or directory in the path name does not exist." - dlopen
  462. What is the difference between connect reset and db2stop force?
  463. A db2 trigger between two tables in two databases
  464. syntax for adding constraint say primary key to a column using alter command in db2
  465. Do you have some examples of the way customers "Document DB2 installations"?
  466. Why a SPILL SORT on *smaller* matchset and not on larger one?
  467. Help with SUB SELECT
  468. How Could I Tuning Performance of a Trigger with MultiCondition in DB2 ?
  469. Why is LOAD API messing up the order of presorted records in the source data?
  470. How to increment a variable inside FOR loop in Stored procedure?
  471. How to get DB2 everyplace to replicate?
  472. How to keep the newly generated sequence value unchanged for insert?
  473. Can I get an example of a DB2 Stored Procedure with Loop & Commit?
  474. How to insert picture into BLOB in DB2 using command editor?
  475. Are nested cursors possible in DB2?
  476. Why does SELECT ColumnName throws up SQLSTATE 42703 error?
  477. Why is SQL stored procedure taking long time to complete?
  478. How long has UDB DB2 Been around?
  479. How to connect to DB2 connect server using Java?
  480. How to get the difference of two column values in db2?
  481. How to pass values from a file to a query in shell script?
  482. Why is configuration assistant empty after Installing DB2 Connect v9.7 on Win 2008?
  483. How to find the primary key of a particular table?
  484. What is the difference between online and offline reorg in DB2?
  485. max(char10) is giving wrong data where column has alphanumeric data
  486. How to import multiple tables in .ixf format to database?
  487. DB2 Query cost on DB2 9.5 on AIX
  488. DB2 v9.5 Trigger Question
  489. How to alter a column from NULL to NOT NULL?
  490. What to check to improve load job performance in DB2
  491. What to check to improve database performance in db2?
  492. what db2 server version does qtp 9.2 supports?
  493. How to load the generated column data into table?
  494. how to find out the last generated key column in db2?
  495. Reorg and then Image Copy
  496. statement and plan "hash value"
  497. How to delete statement by joining two tables?
  498. DB2 client 8.2 and 9.7 in one Windows 2003 machine.
  499. how to store the multiple languages data into table?
  500. What are the effects DB2 partitioning on performance and maintenance?
  501. Can we use For Update Of Clause with Cursor where we are using for 4 tables?
  502. SQL0104N An unexpected token"" was found following"". Expected tokens may:"
  503. Modify db2ha_sample_HADR.xml to reinstall HADR for instance with 6 databases.
  504. Why would DB2 triggers work some time and not others
  505. db2 one procedure is executing very slow , previously it was fast
  506. How to change the password and username of the database ?
  507. IBM DB2 Services shutdown problem
  508. Wildcards in DB2 SQL
  509. How to fix error: . . . queue was not created within timeout period?
  510. What is the SQL to return all stored procedures in a schema in AS400?
  511. How to perform a query for a string which contains an "&"?
  512. How to use 16 bit software on 32 bit machines?
  513. Why is the Procedure not returning the result set?
  514. How to to start DB2 in services.msc or command prompt?
  515. How to Fetch top %, as read only?
  516. How to create a Database in DB2 using command line processor on remote DB2 server?
  517. How to fix Password too short error message?
  518. Why does "SET INTEGRITY" randomly hang?
  519. How to perform rollforward after having restored db2 v8.1 data into db2 v9.7?
  520. How to pass table name in DB2 Procedure?
  521. How to call a db2 API?
  522. DB2 Connect, CLOB's & Special Characters
  523. How to insert multiple records in single job?
  524. How to create pivot tables?
  525. What is the best way to make a copy of production db using DB2v9 Windows?
  526. For MRF (say 100 rows), what is SQLCODE when the last fetch of 40 rows is reached?
  527. How to compile a C-based UDFs using GNU gcc or IBM xlc?
  528. Report Count IIF Help
  529. DB2 Point in Time Recovery
  530. DB2 DB cleaning
  531. Can i extract particular tables from the db2 backup?
  532. How to set the New database in to the IBM TDS , if it is already there.
  533. sql error3055N
  534. How to update only first 1000 rows of a table
  535. db version from backup image
  536. does a set integrity imediate checked statement write out log records, can it not
  537. How to configure clustering from the instance level?
  538. HADR monitoring with custom scripts
  539. DB2 Configuration won't open
  540. can i create a index using substric in DB2 9 ?
  541. Lock table but remaining lock escalation
  542. How toI change this time duration 1.80 into this 2.20
  543. How can i tell if restore is actually running?
  544. Does PL/I work on DB2 v8?
  545. Write a stored procedure with a table name as an argument to insert data into table
  546. 'hash index' in DB2 V10.
  547. Question with Automatic client reroute HADR
  548. priviledges in db2
  549. How to pass a shell variable to a .sql file
  550. Why is the database size is larger than the server disk space?