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. Data change table references and SQLCODE -20165
  2. How to compare several rows in one table???
  3. space utiilization in a DMS tablespace
  4. Error While installing DB2 on RHEL5
  5. DB2 & Oracle source code reusability
  6. Db2Viper2beta on Windows Server 2k8beta3?
  7. Can stored procedure have call to subroutines
  8. join with example
  9. fetch cursor
  10. Stored procedures and Global temporary tables
  11. DB2 DBA 702 Certification exam
  12. DB2 Logging in Materialised queries
  13. db2 with cd
  14. Insert into AS400 table locks bacuase of trigger
  15. prevval and nextval for a sequence
  16. Deadlock/timeout error
  17. Stored Procedures Updates
  18. Restoring, can't redirect tablespaces
  19. Sort Performance
  20. Able to alter or drop a table but cannot create the table, when no permissions are given to that user
  21. SSIS and DB2 Schemas
  22. IMPORT with METHOD N
  23. how to import db2move.lst
  24. size of the database ?
  25. DB2mscs command
  26. Granting DML privileges on all the tables of a schema to a user
  27. Runstats Utility
  28. Short circuit boolean eval in trigger WHEN clause?
  29. Sqlcode +97
  30. SQL need to be optimized
  31. Delete/update Sql/400 Stored Procedure Not Working
  32. History query question
  33. Basic Cron job not working in UBUNTU
  34. faster CPU vs more RAM
  35. waiting on archive
  36. Create Table sql0204 error
  37. SQLPRIMARYKEYS corrupted
  38. IBMDEFAULTBP setting
  39. "I" is not valid in the context it is used - db2 command line sql
  40. db2updv8 necessary for FP14 -> FP15?
  41. oad done on a table with nonrecoverable option on a archive loging enabled Database
  42. Main differences between DB2 v7 & v8 in a Z/OS env
  43. Writing a stored procedure in command editor
  44. Write a cobol program without using session table
  45. Improving Performance in DB2
  46. DB2 Not ATOMIC Compund SQLs
  47. Fixpak installation in db2 udb
  48. Syntax to Update Timestamp Column
  49. How to run db2commands in windows cmd prompt
  50. Reason for DB2 error code Sql0204n
  51. How do you get load to reject and not truncate data
  52. DB2 error SQL30081N on AIX version 5.2 / 5.3
  53. dropped a not null column from a table, error while running stats
  54. dropped a not null column, having problem in Update
  55. Definition of empty table
  56. DB2 Installation Problem
  57. Executing DB2 commands from Windows command prompt
  58. The database alias "MONITOR" already exists Can't Not Drop it
  59. Invalid cfg for DAS tools catalog (or maybe db2fm)?
  60. Sorting data within inline queries
  61. Hang on archive
  62. XSU Java package with DB2
  63. Tracking DML changes for important tables
  64. writing output of Stored Procedure to an outputfile
  65. Restore backup performed on Unix server to a Windows server
  66. some arbitrary application ids in "db2 list applications"
  67. tracking DML on important tables
  68. Automatically disconnecting DB2 clients which are inactive for some time
  69. Efficiency of DB2 LOAD RESUME vs REPLACE
  70. fortran db2 on Windows
  71. OracleXMLQuery class with DB2
  72. Unresolved external with DB2 v9
  73. Informix current sessions with database names
  74. ORDER BY CASE Problem
  75. db2 CASE statement in ORDER BY clause
  76. ODBC connection to V7 and V8 databases simultaneously
  77. Verify File before import
  78. Java scalar function slow
  79. .Net Framework Data Provider for DB2?
  80. Table Functions using Db2 on Z/Os
  81. INSERT binary data
  82. Insert using RRN?
  83. DB2 as web service client?
  84. Interface tools for DB2
  85. SQL1032N No start database manager command was issued. SQLSTATE=57019
  86. TSA binary for Windows
  87. That works faster in DB2 for creation of an index?
  88. Adding a not null column to a table with 0 rows
  89. db2_deinstall command
  90. How to use DB2 ODBC on z/os with COBOL
  91. Error comes when insert records
  92. SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found.
  93. Mainframe file loaded into DB2 table
  94. Use of SELECT [Fields] INTO [var] in UDFs
  95. How to find out last REORG timestamp ?
  96. HADR primary to standby
  97. ADM1844I - Many Many Warnings in the event viewer... Why ?
  98. DB2 privileges, Direct and Indirect SYSADM
  99. How to Handle IF THEN ELSE IN DB2
  100. Effects of Increasing the locklist parameter
  101. Problem with accessing 2 different tables using the same binary
  102. Combine queries for single output
  103. Another Bizzare Crash...But no Recovery. SOS!!
  104. SQL Server 2000 linked server to Db2 on z/OS
  105. DB2 Merge performance
  106. informix/db2
  107. DB2 function
  108. How to write query with two select statements in db2
  109. SQL or stored proc
  110. rid
  111. Odd Diag Log Message on V9 FP2
  112. load/import in db2
  113. how to change user password
  114. query runtime problems - same tables joined together
  115. How to IMPORT MS EXCEL worksheet in Kanji (Japanese) to db2/400
  116. maximum number of column can be set as Primary key in DB@ V8
  117. updating the locklist
  118. How to get the zero's for unsatisfied fields in group by clause in DB2
  119. Need to connect to Db2server
  120. converting Oracle PL/SQL function to DB2 v9
  121. Sqlstate 42972 from Query
  122. stored procedures perf. question
  123. Data load in DB2
  124. db2 exam 701 dumps
  125. Return columns using db2_columns() via PHP
  126. print value during execution stored procedure
  127. Query question
  128. Indexing of table in DB2
  129. setting user name password and user name for automating create script
  130. High water mark
  131. declared global temp table with merge
  132. The Question about REDIRECT RESTORE
  133. sql error -530
  134. When should we Reorg
  135. Background Process for Reorgcheck
  136. Background Process For Backup
  137. db2 on raid5, striped disks, SAN
  138. Alter column precision
  139. Select null as xyz from sysibm.sysdummy1
  140. fastest way to delete 1 billion rows from a table haveing 9 billion records
  141. Select null as xyz from sysibm.sysdummy1
  142. Generated Column
  143. Poll: DB2 V9.1 Adoption
  144. Count the transactions happened in a database
  145. Describe Sql View
  146. Select From Db2 W/php Error
  147. Not a trial, a commercial tool you can use for no charge for as many databases as you want
  148. Backup Information
  149. compare the tables between TEST and DEV
  150. DB2 Control Center not responding
  151. Is there any attribute which indicate the last access date?
  152. How to determine the DB2 version
  153. Querying "Sequence" in Select statement
  154. Got a intresting problem
  155. Backup Information
  156. Conversion of Oracle 9i to DB2 V9
  157. Software Testing Tools
  158. Sybase to DB2 Data Movement
  159. expanding a default value
  160. DB2 V8 (mainframe) Install - 'Resource Not Available' Msg
  161. how to replicate the SQL Server 2005 Procedure to DB2?
  162. DB2 execute permissions issue
  163. Disabling the DB2DETAILDEADLOCK event monitor
  164. Problem in Automatically generated columns while copying schema
  165. "channel DB2"
  166. When is an offline backup not really offline?
  167. Incorrect results using FULL OUTER JOIN in DB2 v8
  168. DB2 Two "how to" questions - [conditional loading and variable use]
  169. DB2 Automated Backup configuration parameters (DB2 UDB v8)
  170. package name restrictions
  171. Selecting Field Description With DB2 and SQL
  172. Archiving Older Data
  173. SQL0206N "BLOB" error
  174. DB2 on AIX throw exception with SQL that has (
  175. DB2 V8.2 - Value compression question
  176. problem with POSSTR
  177. Error while declaring a global temporary table
  178. INSERT IGNORE in db2
  179. J2EE Professionals for Bahrain
  180. Reading Tables & Columns
  181. db2 restore database
  182. Multi Row Insert using an SP in DB2
  183. exam cost??
  184. using Dynamic SQL for Update
  185. Express-C
  186. DB2 Viper 2 compatibility features
  187. Dump of a schema in DB2 / Admin_Copy_Schema
  188. Database Size Problem
  189. Funny
  190. Help me on Query fine tune.Explain report details provided.
  191. Problem with AutoCommit & problem with XML insert
  192. Db2
  193. setting the termination character in CLP
  194. Nested case in DB2
  195. Nested case
  196. DB2 Z/OS Stored proc help
  197. Db2
  198. setting pause on output in CLP (Db2 9)
  199. How to change a column from a not null to null
  200. Oracle EXPORT and DB2 LOAD
  201. SAP DB2 userids
  202. Perl DBD::DB2 connect error
  203. COM.ibm.db2.jdbc.app.DB2Driver
  204. How to insert and retrive data from Visual Stidio 2005 (MFC) into DB2???
  205. IBM][CLI Driver] SQL1032N No start database manager command was
  206. How to export resultset to CSV
  207. How to export resultset to CSV
  208. How to export resultset to CSV
  209. How to export resultset to CSV
  210. How to export resultset to CSV
  211. if "all applications disconnection" is anathor tigger of page cleaner?
  212. killing application/thread automatically
  213. importing data with CR-LF
  214. Insert values into a table B based on a flag on table A
  215. Sql performance Tuning
  216. Database inconsistant?
  217. Sql-Translation: Oracle to DB2
  218. DB2-quries
  219. lock escalation
  220. Unicode...
  221. Tablespace STUCK in Roll Forward in Progress State...
  222. How to make a generated column function of other columns?
  223. db2 pring command for dynamic queries
  224. Calling a nested stored procedure in DB2
  225. Performance of JOIN vs. singleton SELECTs
  226. How many cursors?
  227. What are the process to add another DB2 database to existing Instance?
  228. connect as400 to mysql
  229. substr of a number's field
  230. Emptying index advisor cache
  231. DotNet compatibility of BLOB datatype
  232. positioned update
  233. Tablespace remains full after deletions
  234. Big problem with DB2 and Clobs...
  235. How can i Connet from 1 DB2 Server/Client to Remote Server on AIX
  236. The Best DB2 Articles
  237. DB2 Automated Backup configuration parameters.
  238. Need help getting DB2 Connect to catalog a remote AS400 DB2 server
  239. Load Data from fixed length/delimited feed file
  240. How to get System Date in DB2 with SQL Statements
  241. I need help to fine tune below query..urgent please.
  242. MIGRATE DATABASE from 7.2 to 8.2
  243. How to find no.of deleted rows
  244. DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501
  245. Examination 070-229 Resource
  246. ERROR SQL in DB2
  247. Restoring the event monitor file
  248. plz help:i want to create db2 account Not using OS account
  249. CREATE PARTITIONED TABLE - SQL0104N error
  250. 5th Fast Track Automation batch from Quality Globe from August 9th.
  251. SELECT of Members
  252. inserted values required with the given format
  253. Compare two databases in different subsystem
  254. Lock Escalation
  255. Troubles inserting to a new unicode table....
  256. clientside backup of partioned database
  257. quiesce database problem
  258. Prevent database user to access another database
  259. Use of REORG TABLE in a C++ Applikation for db2 Version 9
  260. CLOB columns change after database restore
  261. Need to display the header as the top row in the recordset
  262. Laptop Version ?
  263. Db2admin password
  264. check constraint
  265. DB2 load utility and subsytem
  266. DB2 Concepts
  267. DB2 Vers 8.1 installation error on WinXP
  268. DB2 connectivity
  269. TCP/IP Communication Error
  270. mainframe (7.1.1) lock escalation
  271. application id
  272. how to get even or odd number rows from database in db2
  273. [Question] DB2 LUW V8, regarding after drop tablespace behavior
  274. DB2 INSERT search for space
  275. runstats from reorgchk update stat
  276. Outer Joins in MQT`s
  277. migrating SQL Server data to DB2
  278. SQL stored procedure in Z/OS (DB2 ver 7)
  279. how to *really* remove a database in DB2 ..
  280. Insert v/s Load
  281. creatin a trigger
  282. To create a trigger
  283. xml
  284. connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
  285. execution time in HADR
  286. ClientBean and ReportBlox
  287. V8.2 Check if nonrecoverable load was done
  288. sql update to a substring
  289. V9 Column Rename
  290. HADR performance issue
  291. Sqlstate = 56038
  292. db2 replication Center
  293. Error activating a database/cannot allocate agent
  294. DB2 Common gcf error
  295. QMF vs SPUFI
  296. import from NUL converted to ordinary delete
  297. Problems with starting DB2 service on windows
  298. SQLJ default context override
  299. DB2 queries
  300. Migrate Data from Oracle 10g Express to DB2
  301. Order of Where and Composite Key
  302. Stored Procedures for DB2 z/OS Developed with SQL Language
  303. Very basic formatting question
  304. DB2 Container Size Limit
  305. at the start of db2
  306. First process in db2 startup
  307. Errorr execute immediate
  308. displaying a date
  309. Get error SQL0723N when trying to insert a row into mainframe DB2 from web server
  310. Mqt Store Procedure
  311. Newbee Query Problem
  312. IN versus ANY versus EXISTS
  313. DB2 Load utility
  314. describe command
  315. Specifying Record Delimiter
  316. SQL0338N-Error
  317. Delete rows from two tables
  318. db2 sql query
  319. SQLCODE: -805, SQLSTATE: 51002 , this is the error code
  320. Temporary table in DB2
  321. Summing a column as a seperate column in the same query
  322. db2_pconnect SQL10007N Reason code: "3"
  323. Nested selects
  324. Invoking Stored Procedures in Triggers
  325. Oportunidade Stefanini It Solutions
  326. BEFORE OPTION
  327. Max length Locate can handle
  328. MF COBOL/DB2 Error
  329. Clob In Db2 Aix
  330. DB2 "Net Search Extender" for v9.1
  331. Define a return value in store proc.
  332. Creating Function Template in UDB 8.2 with TABLE return type for Federation
  333. SQL Error in DB2 and MS Access
  334. DB2 migration utility ?
  335. Looking for a db2 tool that converts Oracle to Db2 - Migration assistant?
  336. DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
  337. 64bit client application in a 32bit instance
  338. Software Testing Cycle
  339. DB2 Certification Exam question
  340. Packages and Procedures
  341. DB2 online data copy
  342. Db2-cobol Program
  343. Isolation level - interesting scenario
  344. Update difficulty
  345. Interesting isolation level problem
  346. access level problem in multiple instance
  347. db2 offline db restore from v7.2 to v8.2
  348. Version Recovery (Db2 on AIX)
  349. Formatted CURRENT DATE
  350. SQL0104N An unexpected token "DATABASE" was found following "CREATE ".
  351. After merging - how to bring over parent_ids
  352. DB2 database shutdowns after excecution of sqlj procedure
  353. VARCHAR field that is not NULL
  354. DB2 ver 7.1 Processing was cancelled due to an interrupt
  355. Help on Null
  356. LIbrary System
  357. db2 704 exams
  358. Very urgent.. need threshold levels for db2 monitoring metrics
  359. SQL Code -181
  360. 4th Fast Track Automation batch from Quality Globe from July 24th.
  361. iNFO O db2 CERTICATION REQUIRED.
  362. How to reduce the ImageCopy job run time
  363. how to ignore errors when creating stored procedure?
  364. help in DB2 Load command
  365. db2 wsad connectivity
  366. Import SPF via Script
  367. SQL0332N There is no available conversion for the source code page
  368. library system
  369. SQL0206N, case statement and time calculation
  370. Failed to load libaio
  371. Asp - Db2
  372. db2 doubt
  373. Catalog Node : Port Number
  374. HELP! declare global temporary tables?!?
  375. HOW to convert a character type into date format
  376. need a little insight on index that allows reverse scans
  377. select from a sequence and from a table in the same statement
  378. update from a select
  379. Storage quantity
  380. Commit Active problem solved (db2rhist.asc)
  381. STOP RUN in DB2 stored procedure
  382. how do you add a zero to the left of an integer
  383. view tables
  384. Retrieving latest row
  385. Error in DB2 (COBOL/DB2/CICS )
  386. Space instead of Null
  387. plan and package
  388. IBM supplied WLM stored procedures
  389. Client compatibility
  390. Oportunidade Stefanini It Solutions
  391. How does threads work in DB
  392. load vs. import ( warnings )
  393. row_number
  394. LOAD and LOAD with AMDIN_CMD
  395. Replication tutorial
  396. DB2 subsystem
  397. SQLCODE groups
  398. Db2
  399. Is there any command or tool for doing DB2 Catalogs reorg/check?
  400. complile and execute a stored procedure.
  401. Run DB2CMD commands through PowerShell
  402. DB2 versus UDB
  403. Controling tablespace for a primary key index in alter table
  404. Db2 700
  405. Need help on data replication and available options
  406. Rename a tablespace file?
  407. Is there any way to make my transcripts of the DB2 certifications viewable for public ?
  408. How to speed up this SQL statement
  409. How to extract sequences in db2 udb 8.2
  410. log table changes with a trigger...
  411. IBM and AGS Announce Availability of New Solutions for Informix Dynamic Server
  412. Contokens
  413. check pending state
  414. message in db2diag.log
  415. DB2Dart Report meaning
  416. problem during database connection test in db2 stored proc
  417. db2dascln
  418. db2 iseries
  419. Application inventory DB
  420. list of parameters that has to monitored by a DBA in db2 UDB
  421. list of Parameters that has to monitored by a DBA in db2 UDB
  422. Renaming an instance
  423. Could this be DB2 or an Access problem??
  424. How to take the database backup
  425. How to define my own exception in db2 stored procedure
  426. DB2 Trigger Help
  427. update a column on particular table relation with multiple tables
  428. ROW_NUUMBER LOOP
  429. Software Quality Management
  430. Need Help with db2 db2start throwing SQL6048N error
  431. Query help...
  432. DB Backup error
  433. DB2 Driver- ClassNotFoundException-Please help
  434. Oportunidade Stefanini It Solutions
  435. Ibm Db2 Sql
  436. Error in loading data into DB2 table
  437. common problems found in db2
  438. Universe locks
  439. command for viewing DB2 configuration parameters
  440. IBM Establishes Global Center of Excellence for Nuclear Power
  441. Corrupt Trigger Nameless
  442. Stored Procedure
  443. Error uninstalling DB2 V9.1 (XP Home)
  444. DB2 700 Exam
  445. SQLDA corrupted when using VARGRAPHIC type parameters
  446. DB2 Certification
  447. db2ReadLog, Variable format data
  448. How to do DB2 Clustering
  449. db2jstrt or db2jd on OS/390
  450. db2look -tw
  451. What are the Files generated after db2 installation
  452. Cobol precompiler query
  453. Installing and Operating DB2 Within Windows Domain
  454. Tables and Columns security in database db2
  455. Long running of DB2 Queries
  456. Creating Indexes For Declared Temporary Tables
  457. How to execute a procedure in DB2
  458. CMMI Practices
  459. DB2 trigger failing while calling stored procedure
  460. How to change the primary key for already existing table?
  461. Statistics with volatile table
  462. Cannot Load
  463. Third Fast Track Automation batch from Quality Globe from July 5th.
  464. "Best Fit" Match against multiple tables?
  465. PHP5, ibm_db2 connection problem
  466. COBOL DB2 V8 Mainframe - moving data from one table to another
  467. Primary Key
  468. DB2 Model
  469. Primary Key
  470. specified attributes not existing with existing column error on Altering table
  471. Getting error whle changing the Datatype of a column in the table.
  472. When to use cursors?
  473. Migration from V8(solaris) to V9(redhat)
  474. normalizing two related tables
  475. How to specify the creator in db2connect
  476. Left outer join with case
  477. Dates, DB/2 and Java
  478. Query's Strange Behavior
  479. [IBM][CLI Driver][DB2/6000] SQL0952N - HELP
  480. DB2V8.2 DPF CPU Usage
  481. AS400JDBCDriver, encoding charset
  482. Issues when deploying applications on WebSpeher process server.
  483. [IBM][CLI Driver] SQL1284N The attempt to connect to database
  484. Query from more than 2 database
  485. Query from more than 2 database
  486. Please..need SHA1 implemented in DB2 version 8
  487. Need help on deleting log file (log_dir)
  488. UDF's crash after new CPU installation on AIX!
  489. set integrity
  490. The database manager is not able to accept new requests, has terminated all requests
  491. how to declare temp tables in a user-defined function
  492. Non-SOAP Web Service in DB2 9
  493. Event monitor that gives more lock info?
  494. Error Message Retreival in SQL Stored Procedures
  495. Applying CURRENT TIMESTAMP On Updates
  496. Db2
  497. What is the difference between BIND REPLACE and REBIND commands?
  498. Basic doubt in union.
  499. JDBC: Connected but no tables shown
  500. DB2 SQL Query
  501. timestamp
  502. Db2javit:rc=9505
  503. Delete table command in DB2 SQL ?
  504. db2 9 processes on linux.
  505. how to add a logical partition on the same computer.
  506. Replication : when asn.IBMSNAP_UOW is pruned ?
  507. BACKUP PENDING(Help me,Please)
  508. Inoperative packages vs. invalid packages
  509. Self Join in DB2 SQL
  510. Troubles using DB2, Websphere 3.5 and Java
  511. Effect of manually updating AVGCOMPRESSEDROWSIZE?
  512. is this table function possible for IBM DB2 v8.2?
  513. Mapping between Package and DBRM.
  514. JDBC type 4 driver for DB2 v7.1
  515. case and count
  516. SIMPLE but SLOW SELECT query!!!
  517. where do i declare the user temporary tablespace?
  518. temporary global tables
  519. Replication error
  520. functions that returns a table
  521. I cannot find License key
  522. Data Dictionary counterpart in DB2
  523. lock escalation : how "expensive"?
  524. INSERT Trouble
  525. How to create user Temporary table in DB2
  526. Migrate from v7 to v9, 32 to 64 bit
  527. How to Update Blob with JDBC?
  528. Generated Always As Identity
  529. COMPRLIB in backup
  530. Comparison of two rows in a table using SQL ?
  531. Setting a default schema for a particular group
  532. Removing a record from resultset using SQL
  533. Define tablespaces with different size paging into DB2
  534. Handling Null from a stored procedure
  535. truncate table for DB2 - differences
  536. Hosting Robots On Terminal Server
  537. Can Not Create Database - DAS Is Not Active
  538. what is a fully qualified table name in DB2 ?
  539. Script for db2 backup
  540. DB2 Trigger syntax
  541. DB2 Trigger syntax
  542. HTTP Web Service Consumer
  543. db2 inplace reorg and log space
  544. Online Reorg of LOB data
  545. Federated Systems Question
  546. Accessing data from an intermediate results table
  547. Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001
  548. DB 2 content manager replication
  549. SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
  550. db2 object comparison tool